VisuaLeaf is one visual workspace for Citus, the extension that turns PostgreSQL into a sharded cluster: browse distributed and reference tables as ordinary tables, build SQL against the coordinator, auto-draw ER diagrams from your foreign keys, and chart the results.
Citus keeps the coordinator speaking ordinary PostgreSQL while your data is split into shards across worker nodes. VisuaLeaf gives you a workspace over that: browse tables without minding where the shards live, and see the schema, the relationships and the results as pictures rather than catalog rows.
A distributed table, a reference table and a plain local table all look identical in a table list, and they behave nothing alike.
Whether a join stays on one node or crosses the cluster depends on a column choice made once at CREATE time and never shown again.
The coordinator hides placement, which is the point — and it also means the physical layout is only ever a metadata query away rather than in front of you.
Co-location is expressed through keys and constraints, so the relationships that make a sharded schema work are the ones nothing draws.
Browse distributed and reference tables, build SQL, map foreign keys into a diagram, and chart results — all in one workspace.
Distributed tables, reference tables, standard PostgreSQL SQL, JSONB, and foreign keys, explored, queried, and visualized instead of parsed from text.
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.
Citus is PostgreSQL, so jsonb, json and array columns open as a nested tree. Inspect keys and arrays inline, filter with the ->, ->> and @> operators against GIN indexes, and edit nested values without hand-writing jsonb_set.
Auto-draw an interactive ER diagram from your real foreign keys and constraints across schemas, then drill into columns, indexes, constraints and CREATE statements. On a sharded schema this is the fastest way to see which tables are meant to travel together.
VisuaLeaf connects the steps Citus users usually handle separately: connect to the coordinator, explore distributed tables, build SQL, and visualize the results.
Point at the coordinator on port 5432 over SSL or an SSH tunnel, with the citus database or your own.
Browse schemas, distributed and reference tables and views, and expand JSONB and array columns in a tree.
Assemble JOINs, CTEs, and window functions visually, or drop into the SQL editor with autocomplete.
Whether you build multi-tenant applications, scale a Postgres workload out, analyse data across shards, or learn SQL, VisuaLeaf gives you a clearer way to work with Citus.
Model tenant tables and their keys, and debug the SQL your app runs against real distributed rows.
Review schemas across environments, manage indexes and constraints, and keep a sharded schema consistent.
Write JOINs and window functions across distributed tables, and chart the results without a separate BI pipeline.
Learn distributed Postgres visually, 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 — Citus 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 distributed tables, build SQL against the coordinator, draw ER diagrams from your foreign keys, and chart your results in one visual workspace.
Download Free Community Edition