VisuaLeaf is one visual workspace for Apache Derby, the pure-Java database that ships inside applications and test harnesses: connect to a Derby Network Server, browse tables, auto-draw ER diagrams from your foreign keys, build SQL visually, and chart the results.
Apache Derby is small enough to ship inside an application, which is its virtue and the reason nobody ever looks at what it holds. VisuaLeaf gives it a proper client: connect to the Network Server, read the schema your code created, and query it like any other database.
A Derby database opened by an application in embedded mode cannot be opened by anything else at the same time, so inspecting it means stopping the app.
The bundled tool runs statements and prints results, which leaves the schema, the relationships and the shape of your data entirely to your imagination.
Derby enforces real constraints and renders them nowhere, so the schema your migrations built stays an abstraction until something breaks.
Even a small dataset is easier to understand as a chart, and a command-line tool has no way to offer you one.
Connect to a Network Server, browse tables, map foreign keys into a diagram, build SQL, and chart results — all in one workspace.
Network Server connections, standard SQL, foreign keys, and results, explored, queried, and visualized instead of printed by a command prompt.
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 harness 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 Derby 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 Derby users usually handle separately: connect to a Network Server, explore tables, build SQL, and visualize the results.
Connect to a Derby Network Server on port 1527 — start Derby in network 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, maintain a legacy system, or learn SQL, VisuaLeaf gives you a clearer way to work with Apache Derby.
Open the database your application runs against, check what it created, and debug SQL against real rows.
Compare the schema Derby 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 needs no installation, 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 — Derby 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