Graphical Schema Design for HSQLDB Databases

Connect DbSchema to HSQLDB and turn the live schema into an editable visual model: explore relationships in interactive ER diagrams, plan changes on the canvas, and generate reviewed SQL scripts for deployment.

The workflow is designed for visual modeling, schema documentation, and deployment — keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See HSQLDB Features Download HSQLDB JDBC Driver · All drivers

HSQLDB (HyperSQL Database) is a compact, standards-compliant SQL database written entirely in Java. It has long served as the embedded database for Java desktop applications, legacy Java EE components, and unit testing frameworks such as DBUnit. Its small footprint and full SQL-92 compliance make it well-suited for testing complex queries, but the absence of a built-in visual interface means schema work is typically done in code. DbSchema brings a graphical schema designer to HSQLDB with support for file-based, in-memory, and server-mode connections.

Work on HSQLDB Schemas Without a Running Application

File-based HSQLDB databases can be opened directly in DbSchema even when the application that owns them is offline. This makes it practical to review, document, or modify a schema outside the normal application lifecycle — particularly useful for legacy systems where schema changes are still applied manually through DDL scripts.

Download DbSchema Free See HSQLDB Features

Edit Table Structure with a Visual Editor

The table editor provides a form-based interface for defining columns, selecting types, setting nullable flags, specifying default values, and configuring constraints. HSQLDB-specific types such as LONGVARCHAR and BINARY appear in the type picker alongside standard SQL types, reducing the need to consult the HSQLDB SQL guide for each change.

Generate Test Data for HSQLDB Schemas

When HSQLDB is used as a test database, it needs data that exercises edge cases in business logic. DbSchema's data generator respects foreign key constraints and lets you configure per-column generation rules — regular expressions, enumerated value sets, date ranges, and numeric distributions — to produce data that mirrors the shape of production records.

Set Up the HSQLDB Connection in DbSchema

DbSchema includes the HSQLDB JDBC driver, so standard HSQLDB versions need no additional download:

1. Download and install DbSchema, then open the new connection dialog.
2. Choose HSQLDB as the database type.
3. Supply the matching JDBC URL: jdbc:hsqldb:file:/path/to/db for a file on disk, jdbc:hsqldb:mem:mymemdb for an in-memory instance, or jdbc:hsqldb:hsql://host:9001/dbname for server mode, launched beforehand with java -jar hsqldb.jar --database.0 file:mydb --dbname.0 mydb.
4. Connect and let DbSchema reverse-engineer the tables, columns, and constraints into the diagram, whether or not the host application is running.

Why Use DbSchema with HSQLDB

• Open HSQLDB file databases without launching the host application
• Design schemas visually and generate DDL scripts for deployment or migration
• Populate test databases with constraint-aware synthetic data
• Document legacy HSQLDB schemas that have no existing ERD
• Compare HSQLDB test schemas against production databases to catch structural drift

Have an HSQLDB test fixture with no ERD to speak of? Download DbSchema for free and turn the file, in-memory, or server-mode database into a documented diagram.

Related databases

Teams working with HSQLDB often use these engines too. Explore dedicated guides and JDBC setup for each.

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cache
• Cockroach

Browse all 100+ supported databases