Universal SQL Client Version 2.6.5a
 

Menu

Home

Download and Installation

Plugins

Translations

Introduction, Features, Screenshots

Programming

FAQ

Old Versions

 

 

On SourceForge

Project Home

Downloads

News

Mailing Lists

Bugs

Feature Requests

CVS

 

 

SQuirreL SQL is hosted at:

SourceForge.net

IDEs used by SQuirreL developers:

IntelliJ IDEA
Eclipse

SQuirreL's SQL editor is based on:

Eclipse 		 
  
 

New Features   Latest News   Overview   Download and Installation   Introduction, Features, Screenshots   Programming   Mailing Lists   CVS   Of Interest  

 

 

Translators (I18N) needed

Currently available translations

 

 

2.6.x Highlights:

  • Enhancements
    • New plugins provide enhanced capabilities:
      • Hibernate Plugin:
        • allows to generate SQL statements from Hibernate HQL statements
        • shows object tree of mapped objects
        • HQL Tab which supports code completion and syntax highlighting
      • SQL Parametrisation (by Thorsten Mürell): This plugin allows you to put variables into your SQL statements.
      • Data import (by Thorsten Mürell): This plugin allows you to import arbitrary files into the database.
    • Previously unsupported types were added to various plugins (e.g. Oracle's SYS.XMLType)
    • New source tabs are available for many of the existing plugins
    • Added support for OS/400 to the DB2 plugin.
    • Added Substance 4.0 LAF to the Look-and-Feel plugin
    • Drag-n-Drop support was added to the SQL file editor to allow files to be dragged from the desktop into an open editor.
    • Many other improvements were made for performance and ease-of-use.
  • A number of bug fixes

For all changes see Changelog. Likewise, please refer SQuirreL's help section for an overview of all features.

Download

Introduction, Features, Screenshots

  

 

Latest News

SQuirreL SQL Client: Version 2.6.5a released
2008-03-09 18:35
Read More »

SQuirreL SQL Client: Version 2.6.5 released
2008-03-04 07:47
Read More »

SQuirreL SQL Client: Version 2.6.4 released
2008-01-15 15:06
Read More »

Site news archive »

  

 

Overview

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, see Introduction. The minimum version of Java supported is 1.5.x as of SQuirreL version 2.4. 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.

For a more detailed introduction see the English or German of our paper on SQuirreL.

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.

 

 

Download and Installation

The SQuirreL SQL Client is installed with the IzPack Java installer. Download the file squirrel-sql-<version>-install.jar and execute it using the following command:
   java -jar squirrel-sql-<version>-install.jar

Make sure that you have write privileges to the directory that you want to install into.

Note that some browsers may attempt to open this file rather than download it. In this case, right-click on the download link and click your browser's equivalent of the "Save as..." menu item.

On Windows, execute the file squirrel-sql.bat to run the application. On Unix, the file is squirrel-sql.sh.

The most important downloads are:

See the plugins page for instructions on installing plugins.

To checkout SQuirreL from CVS use the command:
   cvs -z3 -d:pserver:anonymous@squirrel-sql.cvs.sourceforge.net:/cvsroot/squirrel-sql co -P sql12

Click here for detailed information on how to program SQuirreL.

Click here for detailed information on the build and release system.

  

 

Mailing Lists

There are three mailing lists for SQuirrel. The announcements mailing list is a read-only list that will keep you informed about new versions and other information.

If you have any questions about SQuirreL send them to the users mailing list. All messages sent to the announcements mailing list will also be sent to this one so you don't need to subscribe to both.

For developers there is a developers mailing list. If you are interested in helping to develop SQuirreL or in writing your own plugins then this list is the one you want.

Both the users and developers mailing lists only allow subscribers to post to them. This is because of past experiences with spam.

  

 

CVS

CVS is hosted at SourceForge. The CVS module for maintenance of the 1.1 release is squirrel-sql and development for 1.2 and 2.x is in the sql12 module.

  

 

Of Interest

JFaceDbc is another SQL client tool which uses the low level SQL code from SQuirreL. Rather than the standard Java Swing GUI toolkit it uses the GUI toolkit from the Eclipse project.