Yellowbrick Distribution Keys, Mapped Visually

DbSchema connects to Yellowbrick's MPP warehouse over its PostgreSQL-compatible protocol and reverse-engineers tables, views, distribution keys, and sort keys into a diagram — the data-placement decisions of the cluster, made visible.

See which column drives each table's placement across nodes
Route queries to WLM pools with hint comments from the editor
Browse very large tables fast — filters lean on zone maps
Cover on-premises and cloud instances from one tool

available for

ISO-27001 certified

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

Free Download

DbSchema visualizing a Yellowbrick MPP warehouse schema

Trusted by teams at

It Speaks PostgreSQL
It Performs by Data Placement

Yellowbrick's front end feels like PostgreSQL, but query speed is decided lower down: how rows distribute across nodes, how sort order aligns with zone maps, whether a join forces redistribution. Those decisions hide in DDL — one DISTRIBUTE ON clause at a time.

DbSchema surfaces them: keys and structures on a diagram, so skew and misplaced joins are things you notice rather than discover.

Inspect, Tune & Browse
an MPP Warehouse Comfortably

PostgreSQL habits welcome; the appliance-scale details come along.

Reverse engineer Yellowbrick tables with distribution and sort keys

Placement Keys on the Diagram

Reverse engineering captures tables and views with their distribution and sort keys, so the column driving each table's spread across nodes is part of the picture.

Author analytical SQL with WLM hints against Yellowbrick

Analytical SQL with WLM Manners

Author joins, aggregations, and CTEs; tag interactive work with hints like /* ybworkload:adhoc */; and read EXPLAIN plans to find redistribution steps before they hurt.

Browse large Yellowbrick tables with pushdown filtering

Billions of Rows, Browsable

Column filters push down to the warehouse, where zone maps skip non-matching segments — so checking a loaded table by date or ID range stays quick.

Warehouse Documentation
for Governance and Handoffs

Export the warehouse model as interactive HTML5 documentation — diagrams, definitions, and comments in a self-contained package. Compliance reviewers and downstream data consumers read it in a browser, with no cluster credentials involved.

Explore the Documentation Tool

HTML5 documentation generated from a Yellowbrick warehouse schema

Yellowbrick Connection Particulars

Yellowbrick listens on port 5432 — PostgreSQL's port, but the standard PostgreSQL driver is not interchangeable here. Get the dedicated driver (yellowbrick-jdbc-*.jar, class com.yellowbrick.jdbc.Driver) from the Yellowbrick support portal, giving the URL jdbc:yellowbrick://yellowbrick-host:5432/mydb.

Add ?sslmode=require to enforce SSL — Yellowbrick Cloud requires it and manages credentials through its console; for on-premises deployments, the client must reach port 5432 on the manager node through the firewall. Details on the Yellowbrick JDBC driver page.