Universal SQL Client Version 4.6.0
  
 

 
 

Feature highlights of 4.6.0:

  • Data compare function
  • Search function for preferences/configurations
  • Enhanced BLOB and CLOB loading configuration
  • Export of multiple SQL results
  • Java 20 compatibility
  • Many more features and bug fixes
All new features and bug fixes of the 4.6.0 release can be found in our change log at SourceForge or GitHub.

Download SQuirreL SQL Client


Support us:Support This Project



Review SQuirreL on Sourceforge

 
 

Latest News

New snapshot snapshot-20230613_2108 that fixes missing user text field in the login dialog.
This is relevant if the username is not saved in the Alias definition. See GitHub issue 14.
New feature: The SQL editor offers to compare selected text or complete editor content to clipboard.
For details see our change log at SourceForge or GitHub.

The snapshot releases on SourceForge are:
Download installer for Windows/Linux/others
Download installer for Mac OS
The snapshot releases on GitHub are:
Download installer for Windows/Linux/others
Download installer for Mac OS

Note: We don't anounce every snapshot release here. If you are interested please check
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases
or
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots
for the latest snapshots regularly.

SQuirreL 4.6.0 is released (06/04/2023)

Feature highlights of 4.6.0:
⇒ Data compare function
⇒ Search function for preferences/configurations
⇒ Enhanced BLOB and CLOB loading configuration
⇒ Export of multiple SQL results
⇒ Java 20 compatibility
⇒ Many more features and bug fixes
For all new features and bug fixes see our change log at SourceForge or GitHub.

4.6.0 releases on SourceForge:
Download installer for Windows/Linux/others
Download installer for Mac OS

4.6.0 releases on GitHub:
Download installer for Windows/Linux/others
Download installer for Mac OS

New snapshot 20230519_1436 adds a stability improvement and is a candidate for the 4.6.0 release.
It would be nice if you could give it a try.

For details see our change log at SourceForge or GitHub.
The snapshot releases on SourceForge are:
Download installer for Windows/Linux/others
Download installer for Mac OS
The snapshot releases on GitHub are:
Download installer for Windows/Linux/others
Download installer for Mac OS

 
 

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.

From the 4.3.0 release on the minimum required Java version is 11.x.

SQuirreL's functionality can be extended through the use of plugins.

A short introduction can be found here. The change history (including changes not yet released) is available on SourceForge and on on GitHub.

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

Available downloads are:

On SourceForge On GitHub

Installation:

Prerequisite, Java must be available:
Java is open source and can be downloaded from https://adoptium.net.
SQuirreL will always run with the current LTS (Long Term Support) release of Java.
The minimum Java version required usually is the previous LTS release.

Installation of the SQuirreL SQL Client on Windows and Linux/Unix:
The SQuirreL SQL Client can be installed by the IzPack installer. Download the file squirrel-sql-<version>-standard.jar and execute it using the following command:
java -jar squirrel-sql-<version>-standard.jar    when you properly installed Java.
or
<path to Java directory>\bin\java -jar squirrel-sql-<version>-standard.jar    when you just unpacked the zip or tar.gz version of Java.
Note: On Linux/Unix replace backslashes (\) by slashes (/).

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.

Installation of the SQuirreL SQL Client on MacOS:
On MacOS the preferable way to install the SQuirrel SQL Client is the MacOS X installer squirrel-sql-<version>-MACOSX-install.jar.

Starting the SQuirreL SQL Client:
On Windows, execute the file squirrel-sql.bat to run the application. On Linux/Unix and MacOS, the file is squirrel-sql.sh.

Trouble shooting:
When SQuirreL SQL doesn't start:
On Windows try to add the line
  set JAVA_HOME=<path to Java directory>
to the top of squirrel-sql.bat
On Linux/Unix or MacOS try to add the line
  export JAVA_HOME=<path to Java directory>
after the line
  #! /bin/sh
of squirrel-sql.sh

Scaling problems on high resolution screens:
Set the JVM (Java Virtual Machine) parameter
-Dsun.java2d.uiScale=<scaleValue>
Example: -Dsun.java2d.uiScale=2.5
This can be done by editing squirrel-sql.bat on Windows and squirrel-sql.sh on Linux/Unix or MacOS
or by setting the SQUIRREL_SQL_OPTS variable before executing the start script.

Additional information:

To checkout SQuirreL from the Git repository use the command:

On SourceForge On GitHub

git clone git://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git
or
git clone http://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

Registered developers should use:
git clone ssh://<SF user name>@git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

git clone https://github.com/squirrel-sql-client/squirrel-sql-code.git squirrel-sql-git

SQuirreL's source code is in the sql12/ subdirectory of the clone. Click here for information on how to build and program SQuirreL.

See the plugins page for instructions on installing plugins.
 
 

Mailing Lists

There are several mailing lists for SQuirrel. All mailing lists require subscription for posting.

For questions about using SQuirreL send them to the users mailing list.

For developers there is the developers mailing list. This list is for those who are interested in helping to develop SQuirreL or their own plugins.

 
 

GIT

SQuirreL's Git repository is hosted at SourceForge and at GitHub. The SQuirreL source code is in the sql12 subdirectory.