VisuaLeaf is one visual workspace for Amazon Aurora PostgreSQL: keep the writer and reader endpoints as separate saved connections, browse schemas and tables, expand JSONB in a tree, auto-draw ER diagrams from your foreign keys, and chart the results — on a cluster whose writer can move without warning.
Aurora separates compute from a shared storage layer and gives you a writer, a set of readers and endpoints that move during a failover. VisuaLeaf gives you a workspace over that: keep each endpoint saved, browse the same schema from either, and read JSONB, foreign keys and results as pictures.
Sending analytics at the writer is the classic Aurora mistake, and nothing in a plain SQL prompt reminds you which endpoint you are on.
The cluster endpoint follows the new writer, which is the feature — and it also means a long session can quietly land somewhere else.
A jsonb payload prints as a flat blob, so nested keys and arrays have to be unfolded by hand before you can see what a row actually holds.
Relationships live in constraint definitions across the catalogs, so the shape of the schema exists only in the head of whoever last worked on it.
Save both endpoints, browse schemas and JSONB, map foreign keys into a diagram, and chart results — all in one workspace.
Writer and reader endpoints, standard PostgreSQL SQL, JSONB, privileges, 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 triggers, constraints, partitions, and storage. Hit Show DDL to read the full CREATE TABLE statement any time.
Expand jsonb, json and array columns in a nested tree, filter with the ->, ->> and @> operators against GIN indexes, and edit nested values without hand-writing jsonb_set — Aurora is PostgreSQL-compatible, so this is the behaviour you already know.
Save the cluster endpoint and the reader endpoint as two connections and keep both open: run reporting queries against a replica while the writer stays free for the application, and compare what each one reports when you are chasing replica lag.
VisuaLeaf connects the steps Aurora users usually handle separately: reach either endpoint, explore schemas and JSONB, build SQL, and visualize the results.
Reach the writer or the reader endpoint on port 5432 over SSL, or tunnel through a bastion host into the VPC.
Browse schemas and the search_path, 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 on a cluster, route reads to replicas, analyse data, or learn SQL, VisuaLeaf gives you a clearer way to work with Amazon Aurora PostgreSQL.
Model data with JSONB, arrays and custom types, and debug the SQL your app runs against real rows.
Compare schemas across clusters, review roles and privileges, and keep reporting traffic off the writer.
Point analytics at a reader endpoint, write CTEs and window functions, and chart the results without a separate BI pipeline.
Learn Postgres visually on a managed cluster, 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 — Aurora PostgreSQL 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 save both cluster endpoints, explore JSONB, draw ER diagrams from your foreign keys, and chart your results in one visual workspace.
Download Free Community Edition