Download Yellowbrick JDBC Driver

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

About the Yellowbrick JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Yellowbrick. 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 Yellowbrick driver uses its own syntax — see the connection details below.

The Yellowbrick JDBC driver

Yellowbrick is a hybrid cloud data warehouse built for demanding analytical workloads, combining an in-memory columnar engine with NVMe flash storage for extreme query performance. It uses a massively parallel processing (MPP) architecture and is compatible with PostgreSQL tooling, making migrations straightforward. Yellowbrick is optimized for large-scale analytics across on-premises and cloud deployments.

The Yellowbrick JDBC URL

• Required File(s): yellowbrick-jdbc-xxx.jar
• Java Driver Class: com.yellowbrick.jdbc.Driver
• JDBC URL: jdbc:yellowbrick://{HOST}:{PORT}/{DB}
• Website: Yellowbrick

Yellowbrick uses a PostgreSQL-compatible wire protocol on port 5432. The Yellowbrick JDBC driver provides optimized connectivity for the Yellowbrick MPP engine. SSL can be enabled via connection properties.

DbSchema and Yellowbrick

DbSchema connects to Yellowbrick using the Yellowbrick JDBC driver, visualizing MPP analytical schemas including distribution keys and columnar storage configurations, and enabling complex analytical SQL authoring for large-scale data warehousing workloads.