VisuaLeaf is one visual workspace for H2, the Java database that most often turns up as the thing your tests and local environment run against: connect to a running H2 server, browse tables, auto-draw ER diagrams from your foreign keys, build SQL visually, and chart the results.
H2 is fast to start, easy to embed and usually invisible — which is exactly why a failing integration test is so hard to diagnose. VisuaLeaf gives you a real client for it: open the running database, look at what your migrations built, and query it like any other.
When H2 runs inside a JVM there is nothing to connect to, so the state your test just produced disappears the moment the test ends.
It works, and it is a browser tab with a text area — no schema tree, no diagram, no charts, and nothing saved between sessions.
Your migrations create real constraints, and nothing shows you the schema they produced until something violates one.
H2 can pretend to be PostgreSQL or MySQL for a test suite, which means the SQL that works here is not always the SQL that works in production.
Connect to a running server, browse tables, map foreign keys into a diagram, build SQL, and chart results — all in one workspace.
Server-mode connections, standard SQL, foreign keys, and results, explored, queried, and visualized instead of typed into a browser text area.
Manage tables visually instead of hand-writing DDL. Add, rename, and edit columns with their types, defaults, primary keys, and foreign keys, then work across tabbed panels for indexes and constraints. Hit Show DDL to read the full CREATE TABLE statement any time.
Open the database your test suite or local environment just created and page through the tables, columns, indexes and constraints your migrations produced. It is the fastest way to answer whether a schema change did what its author intended.
Auto-draw an interactive ER diagram from the real foreign keys and constraints in your H2 database, then drill into columns, indexes, constraints and CREATE statements — a genuinely useful check that the model in your code matches the one in the database.
VisuaLeaf connects the steps H2 users usually handle separately: connect to a running server, explore tables, build SQL, and visualize the results.
Connect to an H2 server on port 9092 — start H2 in TCP server mode and it is an ordinary saved connection.
Browse tables and views, page through rows, and read the DDL behind every object.
Assemble JOINs, filters and grouping visually, or drop into the SQL editor with autocomplete.
Whether you debug a failing test, review what a migration created, prototype a schema, or learn SQL, VisuaLeaf gives you a clearer way to work with H2.
Open the database your tests run against, check what a migration created, and debug SQL against real rows.
Compare the schema H2 produced against the one in your production engine, and catch drift before it ships.
Write JOINs and aggregations against a local dataset and chart the results without a separate tool.
Learn SQL on a database that starts in a second, see foreign keys as ER diagrams, and read the SQL the builder writes.
VisuaLeaf started as a MongoDB workspace and grew into a multi-database visual environment. One app, one workflow, across the databases your team actually uses.
And VisuaLeaf does not leave you staring at a wall of SQL and grids. It visualizes everything — H2 schemas become interactive diagrams, queries become visual builders, and results become charts and dashboards.
VisuaLeaf is made by an independent software studio that ships often and listens to the developers who use it every day.
Download VisuaLeaf Community Edition and open the database your tests run against, draw ER diagrams from your foreign keys, build SQL visually, and chart results in one workspace.
Download Free Community Edition