SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.4.x. We recommend 1.5.x. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.
SQuirreL's functionality can be extended through the use of plugins. A short introduction can be found here. To see the change history (including changes not yet released) click here.
Susan Cline graciously took the time to document the steps she followed to setup an Apache Derby database from scratch and use the SQuirreL SQL Client to explore it.
Quite some time ago Kulvir Singh Bhogal wrote a great tutorial on SQuirreL and published it at the IBM developerWorks site. He has kindly allowed us to mirror it locally. The tutorial is not really up to date but especially for doing the first steps it is still of help.
SQuirrel was originally released under the GNU General Public License. Since version 1.1beta2 it has been released under the GNU Lesser General Public License.
Product's homepage
What's New in This Release: [ read full changelog ]
Enhancements:
· New default editor (RText) is used instead of the classic NetBeans Editor
· New plugin for Netezza database
· Connection keep-alive configuration for Sessions
· New Polish translation
· Custom driver properties can now be added or removed
· Support for generating Oracle SQL*Loader control files
· The Graph plugin allows constraints to be added graphically using the model
· Many other improvements were made for performance and ease-of-use.
· A number of bug fixes