SQuirreL SQL is an open-source Java SQL Client program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
This is an excellent tool which is very stable and quite friendly to use. It replaced MS SQL Server Management Studio, Sybase Interactive SQL, and Oracle SQL Developer on my desktop. While I still have those tools when I need something unique to that database SQuirreL has been my go-to daily use tool for several years. Most of the developers in our shop have installed SQuirrel and like it.
Here are some of the niffy features:
The only con is that installation can be tricky but the rewards are worth it.
[Edited by ITPro, May 23]
This is a great language for working with data science. I'm a crazy fan of this. Nice!
Me and my coworkers really don't like this tool. Usability is bad, the process of setting it up to use a new DB is tedious (having to find and copy the drivers and tell Squirrel SQL where to find the drivers), it frequently freezes when doing simple things like just pasting a query into the query window, and doesn't respond to commands to close it, you get annoying prompts when closing it. But, at the same time, it's pretty much the only we've found so far that does what it does. It's just overall annoying to work with, but it's the only thing I have that does the job I need, so I grudgingly use it.
I am looking for a good replacement. Perhaps Dbeaver will be good.
[Edited by kylehipke, November 13]
This tool is VERY good. Am using it with IBM DB2 9.7 to great effect.
Our users have written 4 comments and reviews about SQuirreL SQL, and it has gotten 55 likes