Download Greenplum JDBC Driver

Download the Greenplum JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Greenplum JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Greenplum. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Greenplum driver uses its own syntax — see the connection details below.

The Greenplum JDBC driver

Greenplum is an open-source massively parallel processing (MPP) data warehouse based on PostgreSQL, designed for high-performance analytics on large datasets. It distributes data and query processing across multiple segments, enabling parallel execution of complex analytical queries. Greenplum is used in enterprise data warehousing, machine learning pipelines, and large-scale ETL workloads.

The Greenplum JDBC URL

• Required File(s): postgresql-xxx.jar
• Java Driver Class: org.postgresql.Driver
• JDBC URL: jdbc:postgresql://{HOST}:5432/{DB}
• Website: Greenplum Database

Greenplum is a PostgreSQL-based MPP database. Connect to the Greenplum Master node on port 5432 using the standard PostgreSQL JDBC driver. Greenplum extensions and distribution keys are visible through standard PostgreSQL metadata queries.

DbSchema and Greenplum

DbSchema connects to Greenplum using the standard PostgreSQL JDBC driver, rendering the MPP schema including distribution policies, partition tables, and external tables in the visual schema designer, and enabling analytical SQL query authoring against the Greenplum cluster.