Open and Design H2 Database Schemas in DbSchema

DbSchema gives H2 teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

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

H2 is a pure-Java relational database that runs in-process, making it the default embedded database in Spring Boot and a mainstay of Java integration test suites. Because H2 databases often exist only during a test run or are bundled inside an application JAR, schema design and verification are typically done programmatically. DbSchema provides a visual alternative: connect to an H2 file, in-memory, or server-mode database and use a graphical table editor instead of writing DDL by hand.

Design H2 Schemas Without a Running Application

DbSchema can open an H2 file-based database directly, without requiring the owning application to be active. This disconnected mode lets you inspect and modify the schema of a test database between runs — useful when debugging a Flyway migration or verifying the table structure produced by Hibernate auto-DDL.

Download DbSchema Free See H2 Features

Edit Tables with a Visual Editor

Add, rename, or drop columns, change data types, set default values, and define foreign key relationships using the table editor. Changes are previewed as DDL before being applied to the H2 database — no need to write ALTER TABLE statements manually for iterative schema work.

Populate Test Databases with Generated Data

H2 databases used as test fixtures need realistic data to exercise business logic thoroughly. DbSchema's data generator fills tables with configurable synthetic values — names, email addresses, dates, numeric ranges, and foreign-key-aware references — so integration tests run against populated schemas rather than empty tables.

From Download to H2 Schema Diagram

DbSchema supports all three H2 connection modes. To go from install to a working diagram:

1. Install DbSchema — the H2 JDBC driver is bundled, so no separate download is needed for any connection mode.
2. Create a connection and choose H2 as the database type.
3. Pick the mode that matches your setup: a file-based database uses jdbc:h2:~/test (relative to the user home directory) or an absolute path such as jdbc:h2:/data/mydb; an in-memory database shared within the same JVM uses jdbc:h2:mem:testdb; server mode uses jdbc:h2:tcp://host:9092/~/test after starting H2 with java -cp h2.jar org.h2.tools.Server -tcp.
4. Connect — DbSchema reverse-engineers the tables and relationships into an editable diagram, even if the owning Java application is not running.

Why Use DbSchema with H2

• Open H2 file databases without starting the owning Spring Boot application
• Design schemas visually and export the resulting DDL for Flyway or Liquibase scripts
• Populate test databases with realistic synthetic data for integration tests
• Inspect the schema produced by Hibernate or JPA auto-DDL to catch structural issues early
• Document H2 schemas shared across multiple microservices in a monorepo

Debugging a Hibernate auto-DDL mismatch or just tired of reading H2 schemas in plain text? Download DbSchema for free and open your H2 file or in-memory database as a visual diagram in minutes.