SQuirreL

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. In addition, it comes with more useful features such as drawing dependency graphs based on the schema and foreign keys.

The latest version is available from the official download webpage. Check the Prerequisites, download and install the software.

After SQuirreL has been started for the first time, it will load its default welcome screen.

From the "Drivers" menu, select the "New Driver ..." option to add a driver for MonetDB.

SQuirreL_MonetDB_JDBC_Driver_Setup

In the pop-up dialog:

  1. Enter the driver "Name" MonetDB, an "Example URL" jdbc:monetdb://[host[:port]]/[database][?param1=value1[&param2=value2...]] and the "Website URL" https://www.monetdb.org/documentation/user-guide/client-interfaces/libraries-drivers/jdbc-driver/.
  2. Go to "Extra Class Path" tab and add the MonetDB JDBC driver jar file, e.g. monetdb-jdbc-12.X.jre8.jar. We recommend to always use the latest released JDBC driver. One can download the latest version of the JDBC driver from the MonetDB Java Download Area.
  3. Click on the "List Drivers" button and it will insert org.monetdb.jdbc.MonetDriver into the "Class Name" field.
  4. Click "OK".

Now one can create a new Alias to set up a connection to a specific MonetDB server.

SQuirreL_MonetDB_Alias_Setup

For the Driver, select MonetDB from the dropdownlist.

Enter a "Name", change the "URL" with the correct host, port and database name, enter a "User Name" and "Password" and click the Test button to verify the connection succeeds.

Tip: enable the "Auto logon" and "Save password encrypted" check boxes.

The Properties button allows you to configure more Driver properties, if needed.

Click OK button to save the Alias.

The setup of a MonetDB Driver and MonetDB demo Alias only needs to be done once. You may add more aliases to different MonetDB servers and/or databases or with different credentials.

On the left side click on the vertical Aliases tab page to see the available Aliases. Click on the just added MonetDB demo Alias. This will open a new tab page with icons and below it tab pages Objects and SQL.

The Objects tab page will allow you to quickly view the database catalog objects, such as Schemas, Table Types, Data Types and other Metadata.

The SQL tab page will allow you to enter and execute SQL statements or scripts.

Use the vertical Aliases tab on the left side to view or modify an Alias.