VisuaLeaf is one visual workspace for Amazon RDS for PostgreSQL: reach a private instance through an SSH tunnel or a public one over SSL, browse schemas and tables, expand JSONB in a tree, review the privileges rds_superuser actually gives you, auto-draw ER diagrams from your foreign keys, and chart the results.
Amazon operates the server, patches it, backs it up and keeps it inside a VPC, and in exchange the shell, the log file and the superuser are gone. VisuaLeaf gives you a workspace over what remains: schemas, JSONB, privileges, live activity and the relationships between your tables.
A private instance is not reachable from your laptop at all, so every session starts with a bastion host and a tunnel before a single query runs.
The master user is a delegated role, so some grants, extensions and system settings simply refuse — and nothing tells you which until one does.
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, and no console page turns them into a diagram of your schema.
Tunnel in, browse schemas and JSONB, review privileges, map foreign keys into a diagram, and chart results — all in one workspace.
Tunnelled connections, 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 — the same Postgres behaviour the managed instance is running.
Save the bastion host with the connection instead of running a tunnel in another terminal window. VisuaLeaf opens the forward itself, so a private RDS instance in a VPC is one saved connection away rather than a two-step ritual every morning.
VisuaLeaf connects the steps RDS users usually handle separately: reach the instance, explore schemas and JSONB, build SQL, and visualize the results.
Reach the endpoint on port 5432 over SSL, or tunnel through a bastion host to an instance with no public address.
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 against a managed instance, administer one without superuser, analyse data, or learn SQL, VisuaLeaf gives you a clearer way to work with Amazon RDS for PostgreSQL.
Model data with JSONB, arrays and custom types, and debug the SQL your app runs against real rows.
Compare schemas across environments, review roles and privileges, and watch live activity from one workspace.
Write CTEs and window functions, query JSONB, and chart the results without a separate BI pipeline.
Learn Postgres visually on a managed instance, 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 — RDS 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 tunnel into a private instance, explore JSONB, review privileges, draw ER diagrams from your foreign keys, and chart results in one visual workspace.
Download Free Community Edition