- The Object tree's root node has a new detail tab named "Client Properties"
- The Object tree didn't show tables when the JDBC driver didn't provide table types
- Support for Java 25
- SQL result table search now highlights results in cell detail display, too
- Cell data image display offers to scale images to fit the display size
- MS Excel exports offer to create tabs containing the exports' SQL statements
- Improved memory footprint
- Enhanced 'Copy separated by ...' function
- Searching all open SQL results and cell data dialogs
- 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
- 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
All new features and bug fixes of the 5.0.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
|
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 5.0.0 release on the minimum required Java version is 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.
Available downloads are:
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.
|
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.
SQuirreL's Git repository is hosted at
SourceForge and at
GitHub.
The SQuirreL source code is in the sql12 subdirectory.