Universal SQL Client Version 4.7.1
  
 

 
 

Feature highlights of 4.7.1:

  • Multiple Alias modification
  • Code completion offers contains mode
  • Timeout for SQL executions
  • Object tree: Save and restore selected nodes
  • Data compare to clipboard
  • Search function for table cell data popup
  • Edit toggle button on SQL result tabs
  • Graph Plugin (ER diagrams) allows to hide columns
  • Caret/Cursor position in SQL is displayed
  • Java 21 compatibility
  • Many more features and bug fixes
All new features and bug fixes of the 4.7.1 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

SQuirreL 4.7.1 is released (02/20/2024), feature highlights of 4.7.1:
⇒ Multiple Alias modification
⇒ Code completion offers contains mode
⇒ Timeout for SQL executions
⇒ Object tree: Save and restore selected nodes
⇒ Data compare to clipboard
⇒ Search function for table cell data popup
⇒ Edit toggle button on SQL result tabs
⇒ Graph Plugin (ER diagrams) allows to hide columns
⇒ Caret/Cursor position in SQL is displayed
⇒ Java 21 compatibility
⇒ Many more features and bug fixes
For all new features and bug fixes see our change log at SourceForge or GitHub.

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

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

The new snapshot snapshot-20240114_1941 is a release candidate for the coming 4.7.0 release.
It would be nice if you gave it a try.
Here are some highlights of the snapshot and the coming release:

⇒ Multiple Alias modification
⇒ Code completion offers contains mode
⇒ Timeout for SQL executions
⇒ Object tree: Save and restore selected nodes
⇒ Data compare to clipboard
⇒ Search function for table cell data popup
⇒ Edit toggle button on SQL result tabs
⇒ Graph Plugin (ER diagrams) allows to hide columns
⇒ Caret/Cursor position in SQL is displayed
⇒ Java 21 compatibility
⇒ Many more features and bug fixes

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 announce 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.

 
 

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.