I am looking for a GUI to quickly check an HSQL (Hyper SQL) database.


  • Fast to set up
  • Can be started from command line with filename as an argument
  • See tables
  • Run queries
  • Open source

The HSQLDB JAR itself actually contains such a manager:

java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager

To open db.data:

java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager --url jdbc:hsqldb:file:db.data

It is not the nicest GUI on Earth though:

HSQLDB database manager Ubuntu

| improve this answer | |

LibreOffice Base is designed to do exactly what you're asking. You can make custom data entry forms, queries, and reports. If you read this tutorial you'll know everything you need.

| improve this answer | |
  • Is it compatible with any HSQLDB file, in particular HSQLDB files not created with LibreOffice Base? – Nicolas Raoul Oct 8 '14 at 3:43
  • @NicolasRaoul: While I haven't actually tried it yet, yes this is supposed to work. It's supposed to work with MySQL and a bunch of other databases too. – DanielSank Oct 8 '14 at 3:44
  • @NicolasRaoul: I was actually just working through a part of that tutorial I linked. The form building capabilities are pretty darn good. – DanielSank Oct 8 '14 at 3:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.