SQuirreL is a graphical SQL client application that can be used to browse and query a JDBC compliant database.
As Crate supports JDBC with its Crate JDBC driver, it can easily be used with SQUirreL.
Copy the Crate JDBC standalone jar to the SQuirreL lib folder. On OS X, when installing SQuirreL with the MaxOS X installer, this is
Drivers tab and add a new driver, adding the following information into the form and confirm by pressing ok.
Aliases tab and add a new Alias, Choose your new driver (called crate in our example) and enter your database URL. Username and password are not supported, so leave them blank.
Connect your alias to your crate instance.
You can browse Crate using the Object Tree Worksheet, that is the usual view you use for browsing your tables and get information about their schema.
When browsing a table’s content using Content, it is possible to edit the table contents by right-clicking and choosing Make Editable.
Using the SQuirreL SQL Editor it is possible to execute arbitrary SQL commands and scripts.