Universal SQL Client Version 4.8.0
 

Menu

Home

Download and Installation

Plugins

Translations

Introduction, Screenshots

Programming

FAQ

Old Versions

 

 

On SourceForge

Project Home

Downloads

News

Mailing Lists

Bugs

Feature Requests

GIT

 
 

On GitHub

Project Home

Stable downloads

Snapshot downloads

Bugs/Feature requests

GIT

 

 

Database Links

Drivers

  

 

SQuirreL SQL is hosted at:

SourceForge.net
and
GitHub.com

IDEs used by SQuirreL developers:

IntelliJ IDEA
Eclipse

SQuirreL's SQL editor is based on:

RSyntaxTextArea 		 
  
 

New Features   Latest News   Overview   Download and Installation   Introduction, Screenshots   Programming   Mailing Lists   GIT  

 

 

Feature highlights of 4.8.0:

  • Saved Session Groups: store and restore groups of Sessions
  • Cell detail display at the right of SQL results
  • Cell detail display and cell detail popup support image display
  • Renaming additional SQL tabs
  • Fixed dark theme
  • Java 22 compatibility
  • Many more features and bug fixes
All new features and bug fixes of the 4.8.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

Since snapshot snapshot-20250504_2040 the minimum required Java version is 17.x.

The latest snapshot, snapshot-20250511_2032, includes the following
new features compared to the previous news entry:
⇒ Searching all open SQL results and cell data dialogs
⇒ Java 24 compatibility
⇒ Code completion for JOIN ON clauses
⇒ Cell data display highlights JSON and XML after reformatting
⇒ Choosing fonts for MS-Excel export
⇒ Aliases can be made read-only

For all new features and bug fixes see our change log at SourceForge or GitHub.

snapshot-20250511_2032 releases on SourceForge are:
Download installer for Windows/Linux/others
Download installer for Mac OS
snapshot-20250511_2032 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.

New snapshot snapshot-20241219_2026 containing the following new features since the 4.8.0 release:
⇒ SQL result tabs that match the current SQL in the editor are marked
⇒ SQL result's find function now offers to narrow the columns to search
⇒ SQL result's detail data display now allows to automatically reformat XML or Json
⇒ Numeric values can be right aligned
⇒ Export to MS-Excel allows to configure auto filtering
⇒ Header rows of MS-Excel exports can be made bold/centered/frozen
⇒ Option to change the statement separator during SQL execution using --#SET TERMINATOR <separator>
⇒ Besides sums, means and deviations can now be displayed for selections in numerical columns
⇒ New Alias tree icons which for FlatLaf Look and Feels show if top level folders are expanded or collapsed

For all new features and bug fixes see our change log at SourceForge or GitHub.

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

SQuirreL 4.8.0 is released (09/01/2024), feature highlights of 4.8.0:
⇒ Saved Session Groups: store and restore groups of Sessions
⇒ Cell detail display at the right of SQL results
⇒ Cell detail display and cell detail popup support image display
⇒ Renaming additional SQL tabs
⇒ Fixed dark theme
⇒ Java 22 compatibility
⇒ Many more features and bug fixes
For all new features and bug fixes see our change log at SourceForge or GitHub.

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

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

The new snapshot snapshot-20240722_2010 allows to display cell details on the left of SQL result tables.
The cell detail display as well as the cell detail popup allow to view images stored in the database.
This snapshot is a release candidate for the 4.8.0 release. It would be nice if you gave it a try.
For all new features and bug fixes 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

New snapshot snapshot-20240617_2003 that fixes NullPointer when importing files.
For all new features and bug fixes 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

New snapshot snapshot-20240611_1959 that fixes SQuirreL's dark theme which was broken in the 4.7.1 release
and comes with the new Saved Session Groups feature which allows to store and restore groups of Sessions together with their SQL editors.
For a complete list of all features and bugfixes since the 4.7.1 release see SQuirreL's changelog 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. From the 4.9.0 release on the minimum required Java version will be 17.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.