DbSchema for Greenplum Distribution-Aware Schema Design

Build a clearer workflow for Greenplum: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.

DbSchema is built for relational modeling, migration planning, and SQL-first collaboration. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Greenplum Features Download Greenplum JDBC Driver · All drivers

What happens after you download?

Get to your first Greenplum schema diagram in minutes. No account, no credit card.

Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

Connect to Greenplum or open a sample

Reverse engineer an existing Greenplum database or open a sample model to explore tables, relationships, and indexes.

Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

Visualizing Greenplum's Distributed Table Design

Greenplum is a massively parallel analytical database built on PostgreSQL, with distribution keys and partition policies that govern how data is spread across segment hosts. These design choices are critical to query performance but remain invisible in standard database management tools. DbSchema connects to the Greenplum master node via the PostgreSQL JDBC driver, reads distribution and partition metadata from the system catalog, and renders the full schema as a visual ER diagram. Data engineers can review distribution key assignments, spot missing partition definitions, and understand table dependencies without querying catalog tables directly.

Download DbSchema Free See Greenplum Features

Design Greenplum Schemas with Distribution Awareness

DbSchema's diagram editor supports Greenplum's PostgreSQL-compatible SQL dialect and lets you create tables, set distribution clauses, and manage partitions through the visual editor. DbSchema generates the corresponding Greenplum DDL, including DISTRIBUTED BY and PARTITION BY clauses, ready for execution against the master node.

Designing a Greenplum distributed table schema in the DbSchema visual editor

Run Analytical SQL Against the Greenplum Cluster

DbSchema's SQL editor connects to the Greenplum master and dispatches queries for parallel execution across segment hosts. The editor includes syntax support for Greenplum's PostgreSQL dialect, result tabulation, and query history — making it a practical desktop client for analytical workloads without needing psql or another client tool.

Running analytical SQL on a Greenplum cluster in the DbSchema SQL editor

Generate Schema Documentation for Data Engineers

DbSchema exports Greenplum schemas as browsable HTML documentation with embedded ER diagrams and table definitions, including distribution metadata. Data engineering teams use this to maintain a persistent reference for schema design decisions and to onboard new engineers to the warehouse structure.

Auto-generated Greenplum schema documentation showing distribution metadata

How to Connect DbSchema to the Greenplum Master

DbSchema reaches a Greenplum cluster the same way any PostgreSQL-compatible client does, aimed at the master rather than a segment:

Download and install DbSchema — no account or credit card needed.
Create a new connection and select Greenplum; DbSchema downloads the PostgreSQL JDBC driver automatically since Greenplum shares PostgreSQL's wire protocol.
Point the connection at master_host — the Greenplum master segment host, not a segment host — on port 5432, the same default PostgreSQL uses. The resulting JDBC URL is jdbc:postgresql://master_host:5432/dbname.
Connect: DbSchema reflects the full schema, including distribution keys and partition metadata read from the Greenplum catalog views, and builds the ER diagram.

Issuing DDL and DML against the master lets Greenplum handle distributing the work across segment hosts automatically, so there is no need to connect to individual segments for schema management.

What Greenplum Data Engineers Gain from DbSchema

Visualize distribution keys, partition policies, and FK relationships in a single diagram
Write and execute Greenplum SQL from a desktop client with PostgreSQL syntax support
Document the distributed warehouse schema for data engineering teams
Design schema changes in a visual editor and preview DDL before deploying to production
Compare Greenplum schemas between environments to identify configuration drift

Want the distribution strategy on a diagram instead of buried in catalog views? Download DbSchema for free and connect to your Greenplum master in minutes.

Teams working with Greenplum often use these engines too. Explore dedicated guides and JDBC setup for each.