Install SQuirreL SQL Client on macOS

Mac Tutorials - Herong's Tutorial Examples

∟Install SQuirreL SQL Client on macOS

This section provides a tutorial on how to install SQuirreL SQL Client on macOS.

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. Here is what I did to install SQuirreL SQL Client on macOS.

1. Go to SQuirreL Website at sourceforge.net/projects/squirrel-sql.

2. Click "Files > 1-Stable > 4.0.0 > squirrel-sql-4.0.0-MACOSX-installer.jar" to download.

3. Run the download JAR file, squirrel-sql-4.0.0-MACOSX-installer.jar, in a Terminal window to open the installation screen.

herong$ cd ~/downloads
herong$ java -jar squirrel-sql-4.0.0-MACOSX-install.jar

4. Select MySQL, Oracle and SQL Server to finish the installation.

5. Install JDBC driver for SQL Server:

Go to Microsoft Website at at microsoft.com/en-us/download/details.aspx?id=11774.
Download sqljdbc_6.0.8112.200_enu.tar.
Open the downloaded TAR file by running "tar -xf sqljdbc_6.0.8112.200_enu.tar".
Move JDBC driver files to /Library by running "mv sqljdbc_6.0 /Library/Java/JDBC".

6. Add JDBC driver for SQL Server to SQuirreL:

Start SQuirrel by going to "Applications > Squirrel".
Click "Drivers > SQL Server > Extra class path > +" to add the driver file.
Select "/Library/Java/JDBC/sqljdbc_6.0/enu/jre8/sqljdbc42.jar". When the driver file is loaded, SQL Server JDBC driver is ready.

7. Add connection alias to SQL Server database.

Start SQuirrel by going to "Applications > Squirrel".
Click "Aliases > +" to add a new connection alias.
Select "SQL Serve JDBC Driver" and enter server address, login name and password.
Click "Test" to verify the connection.