Universal SQL Client Version 4.5.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

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.5.0:

  • Multiple caret/cursor editing
  • Global Preferences and New Session Properties search
  • Several improvements of Saved Sessions (feature to save and restore all SQL editors of a Session)
  • Configurable right mouse menus
  • Redesigned add/edit JDBC-Driver dialog
  • Java 19 compatibility
All new features and bug fixes of the 4.5.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

SQuirreL 4.5.0 is released (12/10/2022). Highlights are:
Multiple caret/cursor editing
Global Preferences and New Session Properties search
Several improvements of Saved Sessions (feature to save and restore all SQL editors of a Session)
Configurable right mouse menus
Redesigned JDBC-Driver dialog
Java 19 compatibility
For more details on all new features and bug fixes see our change log.

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

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

Latest snapshot 20220920_2105 offers
⇒ Java 19 compatibility
⇒ Search for Saved Sessions
⇒ Configurable right mouse menus through the option to move less used menu items to an attic submenu.
This snapshot is a candidate for the 4.5.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

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.

New snapshot 20220725_2137 which fixes start script problems on Windows
that kept SQuirreL from starting when the IzPack installer was used.
Also note the updated download and installation section below.

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 Getting Started and Introduction.
From the 4.3.0 release on the minimum required Java version is 11.x.
From version 3.8.1 to 4.2.0 version the minimum version of Java supported was 1.8.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.

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

SQuirreL's Wiki page can be found 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.

 

 

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:
The SQuirreL SQL Client can be installed by the IzPack installer. Download the file squirrel-sql-<version>-install.jar and execute it using the following command:
java -jar squirrel-sql-<version>-install.jar    when you properly installed Java.
or
<path to Java directory>\bin\java -jar squirrel-sql-<version>-install.jar    when you just unpacked the zip or tar.gz version of Java.
Note: On Linux/Unix or MacOs 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.

On MacOS:
On MacOS the preferable way to install the SQuirrel SQL Client is the MacOS X installer.

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.