SQL Workbench

SQL Workbench/J is a tool for working with SQL databases that supports Java clients. One can download it from the official website.

JDBC Driver

While SQL Workbench has some support for MonetDB, one still needs to download MonetDB's JDBC driver and configure it.

After SQL Workbench has been started for the first time, it will load its default welcome screen and starts the wizard to select database driver. Cancel this wizard and open the driver manager using the menu "File->Manage Drivers".

  1. Add a new Driver by clicking on the button in the top-left corner of the dialogue and typing in a name for the driver, e.g. "MonetDB".

  2. Click on the folder-like icon and navigate to the previously downloaded JDBC .jar file.

  3. The class name nl.cwi.monetdb.jdbc.MonetDriver should be automatically filled in.

  4. Type in a sample URL for the database connection, e.g. jdbc:monetdb://hostname:50000/database.

Database Connection

Next, to connect to a MonetDB database instance, open the "File->Connect" window.

  1. Type in a name for the connection.

  2. Selected the MonetDB driver from the "Driver" drop-down menu.

  3. Enter the details of the desired database connection by replacing the hostname, port and database name in the sample URL, e.g. use jdbc:monetdb://localhost:50000/db for a MonetDB server instance running on localhost port 50000 serving database db.

  4. Enter the username and password for the database

Click on "OK" to confirm the connection, and you are good to go.