Graphical Schema Design for HSQLDB Databases

HSQLDB powers Java desktop applications, legacy Java EE components, and DBUnit test suites — compact, SQL-92 compliant, and typically managed entirely in code. DbSchema adds what HSQLDB never had: a graphical schema designer for file, in-memory, and server mode.

Open the database file with the host application offline
Pick HSQLDB types like LONGVARCHAR straight from the type list
Generate constraint-aware test data from per-column rules
Diff the test schema against production

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema designing an HSQLDB schema in a graphical editor

Trusted by teams at

Decades of Fixtures and Legacy Apps
Not One Diagram Among Them

HSQLDB schemas accumulate in DDL scripts and test setup code, applied manually on legacy systems that outlived their documentation. When a change is due, someone reads the scripts top to bottom to rediscover the structure.

DbSchema reverse-engineers the database into an ER diagram and keeps working outside the application lifecycle — review, document, or modify the schema whenever it suits you.

Reverse Engineer, Compare & Edit
HSQLDB Without Hand-Written DDL

Schema work through forms and diagrams, with the SQL generated for you.

Reverse engineer an HSQLDB database into an ER diagram

The Fixture, Reverse-Engineered

Tables, columns, and constraints come out of the database and onto a diagram — whether or not the host application is running.

Compare an HSQLDB test schema against the production database

Test Schema vs. Production Truth

Compare the HSQLDB fixture with the production database it stands in for, and catch structural drift before a green test suite misleads anyone.

Generate HSQLDB DDL from visual edits in DbSchema

Form-Based Edits, DDL Output

Define columns, nullable flags, defaults, and constraints in the table editor; DbSchema emits the DDL scripts for deployment or migration.

The App Owns the File
You Own the Design

With the schema in a DbSchema model file, design work stops depending on the application that embeds the database. Legacy constraints stay documented, and every change is deliberate.

Model the HSQLDB schema while the application is offline

Model with the App Offline

The design session needs neither the application nor a live connection.

History in Version Control

Commit the model file and the schema's evolution stops being archaeology.

Review HSQLDB DDL statements before execution

Statements Before Side Effects

Each edit shows its DDL up front; nothing runs until you have read it.

Stage HSQLDB schema changes across environments

Stage, Then Ship

Apply the identical reviewed change to test and production databases in turn.

HSQLDB Modes, URLs, and the Server

DbSchema includes the HSQLDB JDBC driver, so standard HSQLDB versions need no extra download. Match the URL to the mode:

File — jdbc:hsqldb:file:/path/to/db for a database on disk.
In-memory — jdbc:hsqldb:mem:mymemdb for a transient instance.
Server — jdbc:hsqldb:hsql://host:9001/dbname, with the server launched beforehand via java -jar hsqldb.jar --database.0 file:mydb --dbname.0 mydb.

Reverse engineering works the same in every mode. Driver notes live on the HSQLDB JDBC driver page.