VisuaLeaf is one visual workspace for Azure Database for PostgreSQL: connect to a Flexible Server over SSL, browse schemas and tables, expand JSONB in a tree, review the roles and privileges you actually have, auto-draw ER diagrams from your foreign keys, and chart the results.
Azure runs the instance, patches it and fails it over, and in exchange you give up superuser, the local socket and the log file. VisuaLeaf gives you a workspace over what is left: schemas, JSONB, foreign keys, roles and query activity, all visible from a desktop client.
SSL is required, firewall rules gate the client, and a private-access server is not reachable at all without a tunnel — so step one is rarely just a hostname.
The admin login is a delegated role rather than a Postgres superuser, so what you can grant, alter or install is bounded in ways a local instance never is.
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 portal blade turns them into a diagram of your schema.
Connect over SSL or a tunnel, browse schemas and JSONB, review roles, map foreign keys into a diagram, and chart results — all in one workspace.
Flexible Server connections, standard PostgreSQL SQL, JSONB, roles and 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 experience the managed service is built on.
List, create, alter and drop roles within what the service permits, grant and revoke table and schema privileges, and see where Row-Level Security applies. For live activity, read active connections and running queries from pg_stat_activity and per-table statistics without opening a portal blade.
VisuaLeaf connects the steps Azure Postgres users usually handle separately: connect over SSL, explore schemas and JSONB, build SQL, and visualize the results.
Connect to a Flexible Server on port 5432 over SSL, through PgBouncer on 6432, or via an SSH tunnel for private access.
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 Flexible Server, administer one without superuser, analyse data, or learn SQL, VisuaLeaf gives you a clearer way to work with Azure Database 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 server, 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 — Azure 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 connect over SSL, explore JSONB, review roles and privileges, draw ER diagrams from your foreign keys, and chart results in one visual workspace.
Download Free Community Edition