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.
In the pop-up form:
MonetDB
, an "Example URL" pointing to the database of
interest jdbc:monetdb://<host>[:<port>]/<database>
and the "Website URL" https://www.monetdb.org/
.${prefix}/share/monetdb/lib/monetdb-jdbc-X.Y.jar
.nl.cwi.monetdb.jdbc.MonetDriver
into the "Class Name" field.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.