Distributed YugabyteDB Schemas, Visualized

DbSchema connects through the YugabyteDB smart JDBC driver and reverse-engineers the YSQL schema — tables, indexes, views, sequences, foreign keys, and partitioned tables — into a diagram of the relational model your distributed cluster serves.

Communicate geo-partitioned designs with a picture, not a wiki page
Author tablespace and SPLIT AT VALUES DDL in the SQL editor
Read EXPLAIN (DIST ON, ANALYZE) plans down to tablet operations
Follow foreign keys through the data, wherever the rows physically live

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema diagramming a distributed YugabyteDB YSQL schema

Trusted by teams at

Tables Across Three Regions,
Raft Underneath, Postgres on Top

YugabyteDB shards tables into tablets, replicates them by consensus, and pins partitions to regions for residency rules — while YSQL keeps presenting it all as PostgreSQL. Explaining that design to a teammate is where the trouble starts.

DbSchema draws the relational model the cluster serves, so a distributed design becomes something the whole team can point at.

Import, Change & Navigate
the YSQL Schema Safely

PostgreSQL-compatible tooling with distributed SQL details in reach.

Reverse engineer a YugabyteDB YSQL schema into an ER diagram

The Full Relational Model, Imported

Tables, indexes, views, sequences, foreign keys, and partitioned tables arrive from the YSQL catalog onto a navigable diagram — one connect, whole model.

Review generated DDL before it reaches the YugabyteDB cluster

Changes You Read Before the Cluster Does

Adjust the design on the model, then review the generated statements in full — deliberate change management for a database that spans regions.

Browse YugabyteDB table data and follow foreign keys

Rows Without Borders

Page, filter, and follow foreign-key links through table data — YSQL presents one logical view, however many tablets and regions hold the rows.

One Reference for a Schema
Deployed Around the World

A globally distributed schema is the hardest kind to document by hand — and the kind that most needs documenting. Generate interactive HTML5 documentation from the model and give every region's team the same current reference, viewable in a browser.

Explore the Documentation Tool

HTML5 documentation generated from a YugabyteDB YSQL schema

YugabyteDB Connection Checklist

YSQL listens on port 5433 — not PostgreSQL's 5432, the classic mistake when reusing a Postgres setup. Use the smart JDBC driver (jdbc-yugabytedb-*.jar from Maven Central or the GitHub releases, class com.yugabyte.Driver) with jdbc:yugabytedb://localhost:5433/yugabyte; the default database and superuser are both yugabyte.

For clusters, list several nodes and let the driver balance and route by topology: jdbc:yugabytedb://node1:5433,node2:5433,node3:5433/yugabyte?load-balance=true. Add ?sslmode=require where SSL is enforced; YugabyteDB Managed requires SSL and provides a CA certificate in the cluster settings for DbSchema's SSL panel. Full walkthrough on the YugabyteDB JDBC driver page.