SQuirrel

SQuirreL SQL Client is a graphical Java program to, e.g., view the structure of a JDBC compliant database, browse the data in tables, and issue SQL commands. 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 website. Download and install the software. The following instructions work for version 3.4.

After SQuirreL has been started for the first time, it will load its default welcome screen. Locate the "Drivers" window and click to add a driver.

SQuirreL_MonetDB_driver_dialog

In the pop-up form:

  1. Enter the driver "Name" MonetDB, an "Example URL" pointing to the database of interest jdbc:monetdb://<host>[:<port>]/<database> and the "Website URL" https://www.monetdb.org/.
  2. Goto "Extra Class Path" and add the MonetDB JDBC driver JAR file. One can download the latest version of the driver from the MonetDB repository. If the driver come with one's (Linux-like) OS distribution, it is typically installed in ${prefix}/share/monetdb/lib/monetdb-jdbc-X.Y.jar.
  3. Click on the "List Drivers" button and it will insert nl.cwi.monetdb.jdbc.MonetDriver into the "Class Name" field.
  4. Click "OK".

Now one can create a new alias to set up a connection. Therefore, one needs to edit the alias to direct it to the proper database server (i.e. change the server URL) and use the proper user credentials.