VisuaLeaf is one visual workspace for HSQLDB, the HyperSQL database that runs embedded in Java applications and test suites: connect to a running HyperSQL server, browse tables, auto-draw ER diagrams from your foreign keys, build SQL visually, and chart the results.
HyperSQL is small, standards-conscious and usually embedded, which makes it excellent to run against and awkward to inspect. VisuaLeaf gives it a proper client: open the running database, see the schema your code created, and query it like any other.
HyperSQL running in-process has no listener for anything else to attach to, so whatever your application just wrote stays sealed inside it.
It works, and it is a tree plus a text area — no diagram, no charts, no saved connections, and a look that has not changed in a very long time.
HyperSQL enforces real constraints, and nothing renders the schema they describe until a violation forces you to go looking.
The same application can run against data that vanishes at shutdown or data that persists, and the difference is one line of configuration.
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, standards-based SQL, foreign keys, and results, explored, queried, and visualized instead of typed into a Swing 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 application or test suite is using and page through the tables, columns, indexes and constraints it created. It is the fastest way to answer whether the schema your code describes is the schema that actually exists.
Auto-draw an interactive ER diagram from the real foreign keys and constraints in your HyperSQL database, then drill into columns, indexes, constraints and CREATE statements — a quick check that the model in your code matches the one in the database.
VisuaLeaf connects the steps HyperSQL users usually handle separately: connect to a running server, explore tables, build SQL, and visualize the results.
Connect to a HyperSQL server on port 9001 — run HSQLDB in 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 an application created, prototype a schema, or learn SQL, VisuaLeaf gives you a clearer way to work with HyperSQL.
Open the database your application runs against, check what it created, and debug SQL against real rows.
Compare the schema HyperSQL 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 standards-based SQL on a database that starts instantly, and read the SQL the query 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 — HyperSQL 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 application runs against, draw ER diagrams from your foreign keys, build SQL visually, and chart results in one workspace.
Download Free Community Edition