VisuaLeaf is one visual workspace for IBM Db2: browse schemas and tables without memorising catalog view names, auto-draw ER diagrams from your foreign keys, build SQL visually, edit rows inline, and chart the results — on macOS and Linux as readily as on Windows.
Db2 records everything about your schema — columns, keys, constraints, indexes, tablespaces — and it records it in system catalog views that only help if you already know which one to query. VisuaLeaf gives you a workspace over them.
Finding which tables reference a column means knowing the right catalog view and joining it correctly, before you have learned anything at all.
Relationships are recorded faithfully and rendered nowhere, so the shape of a long-lived enterprise schema exists mostly in institutional memory.
Teams working on macOS and Linux end up on different tools from everyone else, which is how conventions and scripts quietly diverge.
The tables that matter are wide as well as long, and a text client makes you choose between seeing all the columns and seeing any of the rows.
Browse schemas and tables, map foreign keys into a diagram, build SQL, edit rows, and chart results — all in one workspace.
Schemas, foreign keys, indexes and constraints, and results, explored, queried, and visualized instead of looked up in catalog views.
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, constraints, and storage. Hit Show DDL to read the full CREATE TABLE statement any time.
Page through a large table without waiting for a full result set, filter and sort from the grid, and edit values in place with the generated UPDATE shown before it runs — so nothing reaches the database that you have not read first.
Auto-draw an interactive ER diagram from the real foreign keys and constraints recorded in the Db2 catalog, spanning multiple schemas and views, then drill into columns, indexes, constraints and CREATE statements.
VisuaLeaf connects the steps Db2 users usually handle separately: connect from any OS, explore schemas, build SQL, and visualize the results.
Reach a local, Docker, self-hosted or hosted Db2 on port 50000 over SSL or an SSH tunnel.
Browse schemas, 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 build against an enterprise database, review a long-lived schema, analyse data, or learn SQL, VisuaLeaf gives you a clearer way to work with IBM Db2.
Model tables and indexes on any operating system, and debug the SQL your app runs against real rows.
Compare schemas across environments and manage indexes and constraints without writing catalog queries.
Write JOINs and aggregations and chart the results without a separate BI pipeline.
Learn Db2 SQL visually, see foreign keys as ER diagrams, 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 — Db2 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 browse schemas from any operating system, draw ER diagrams from your foreign keys, build SQL visually, and chart results in one workspace.
Download Free Community Edition