The SQuirreL SQL Client uses JDBC to allow users to explore and interact with databases via a JDBC driver.
It provides an editor that offers code completion and syntax highlighting for standard SQL.
Plugin’s can be added to modify the application’s behavior and to add database-specific functionality.
SQuirreL SQL is written in Java with Swing UI, and so should run on any platform with a JVM.
SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License. For more information, see http://www.gnu.org/licenses/licenses.html#LGPL.
In this guide, we are using version 3.9.1 of SQuirreL SQL Client. If you wish to use a different version, please pay attention to when the version number is used in the instructions.
A list of plugins is available at http://squirrel-sql.sourceforge.net/index.php?page=plugins
Generally, installation is done by running the installer from the command line with a
java -jar squirrel-sql-<version>-install.jar type command. For details, see below.
To install SquirreL SQL:
Open a console/command line window
Decide which directory you want to install into
Make sure that you have write access to that directory
3.1. OS X
Run the installer .jar:
java -jar squirrel-sql-3.9.1-MACOSX-install.jar
Follow the installation guide:
4. Run Client
To start the client, use the provided startup script in the installation directory.
4.1. OS X
In the console:
5. Connection drivers
In order to connect to LeanXcale, you need to install the JDBC driver
You do need to install both the
6. Download JDBC driver
The JDBC driver can be downloaded from:
7. Install JDBC driver
To install the JDBC driver:
Expand/extract the downloaded archive
.jarfile from the expanded
Find the SQuirrel SQL install directory
.jarfile into the
When the driver has been placed in the
Open SQuirrel SQL
Apache Derby Client
Double click the entry
The configuration shows the driver options:
The driver is registered:
You can now set up the connection.
8. Connect to LeanXcale
In SQuirrel SQL, a database connection is called an Alias and are set up in the Alias tab.
The general format for the connection string is: