Open and Design H2 Database Schemas in DbSchema

H2 is the pure-Java database inside Spring Boot defaults and countless integration test suites — and its schema usually exists only in code. DbSchema opens H2 in file, in-memory, or server mode and replaces hand-written DDL with a graphical table editor and ER diagram.

Open a file database while the owning application is stopped
Check the tables Hibernate auto-DDL actually produced
Fill test schemas with foreign-key-aware synthetic data
Export DDL for your Flyway or Liquibase scripts

available for

ISO-27001 certified

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

Free Download

DbSchema opening an H2 database as an editable ER diagram

Trusted by teams at

The Database Ships Inside the App
Its Schema Hides There Too

An H2 database often lives only for a test run or sits bundled inside an application JAR, so schema design and verification happen programmatically — one ALTER at a time, checked by reading logs.

DbSchema gives that schema a face: open the database, see every table and relationship on a diagram, and edit structure through forms instead of DDL — ideal when debugging a Flyway migration between test runs.

Open, Edit & Verify
H2 Schemas Visually

From database file to reviewed change, no application launch required.

Reverse engineer an H2 file database into an editable diagram

From H2 File to Editable Diagram

DbSchema opens a file-based H2 database directly — the owning Spring Boot application stays off — and reverse-engineers tables and relationships into a diagram.

Preview H2 DDL changes before applying them

ALTER Statements, Written for You

Add columns, change types, and define foreign keys in the table editor; DbSchema previews the DDL before applying it — copy it straight into a migration script.

Browse the rows inside an H2 test database

Look at What the Tests Wrote

Browse table contents, follow foreign keys between rows, and filter values — the fastest way to inspect fixture data without writing a query.

Schema and Code,
One Repository, One Review

Your H2 schema already travels with a Java project — DbSchema makes that official. Keep the design model file next to the source, let pull requests show structural diffs, and hand reviewers DDL they can read instead of Hibernate log output.

H2 schema synchronization between the model file in Git and the database

Read Git Workflow Docs

H2 Connection Modes and URLs

The H2 JDBC driver ships bundled with DbSchema, so no separate download is needed for any connection mode:

File — jdbc:h2:~/test resolves relative to the user home directory; an absolute path works as jdbc:h2:/data/mydb.
In-memory — jdbc:h2:mem:testdb, shared within the same JVM.
Server — jdbc:h2:tcp://host:9092/~/test, after starting the server with java -cp h2.jar org.h2.tools.Server -tcp.

Whichever mode you pick, DbSchema reverse-engineers tables and relationships into an editable diagram, even when the owning Java application is offline. More setup notes live on the H2 JDBC driver page.

Open Your H2 Database Right Now

No signup, no account — install and point DbSchema at the file.

Download Free

Frequently asked questions

Yes. DbSchema connects to H2 in file-based, in-memory, and server modes, and bundles the H2 JDBC driver so no separate download is needed.

Yes. DbSchema can open a file-based H2 database directly in a disconnected mode, letting you inspect or modify the schema between application runs.

Yes, using the Pro edition data generator, which fills H2 tables with configurable synthetic values while respecting foreign key relationships. A 15-day Pro trial is included in the same free download.

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