2.3 SQuirreL

SQuirreL SQL Client is a graphical Java program to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands, etc. It's a very cool tool. It can even draw dependency graphs based on the schema and foreign keys.

The latest versions is available from their website. Download and install the software. The following scheme works for version 2.5.

After starting SQuirreL for the first time, it will load its default welcome screen. Locate the Drivers window and click to add a driver. In the pope's form enter the driver name MonetDB, the example URL jdbc:monetdb://localhost/demo, the website http://monetdb.cwi.nl. Now goto Extra Class Path and add the MonetDB JDBC driver that came with your distribution, typically installed in ${prefix }/share/MonetDB/lib/monetdb-X.Y-jdbc.jar. Finally, add the class name nl.cwi.monetdb.jdbc.MonetDriver.

Restart SQuirreL. The MonetDB driver should be marked ok. Create an alias to setup your first session. Explore the application and have fun!