Download CrateDB JDBC Driver

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

About the CrateDB JDBC driver

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

The CrateDB JDBC driver

CrateDB is a distributed SQL database designed for machine data and IoT analytics at scale. It combines the familiarity of SQL with the scalability of a NoSQL document store, supporting dynamic schemas and time-series data natively. CrateDB's shared-nothing architecture allows horizontal scaling without manual sharding.

The CrateDB JDBC URL

• Required File(s): crate-jdbc-xxx.jar
• Java Driver Class: io.crate.client.jdbc.CrateDriver
• JDBC URL: jdbc:crate://{HOST}:{PORT}/
• Website: CrateDB

CrateDB uses a PostgreSQL-compatible wire protocol on port 5432 by default. The CrateDB JDBC driver provides direct connectivity with full SQL support. SSL can be enabled by appending ?ssl=true to the URL for encrypted connections to secured clusters.

DbSchema and CrateDB

DbSchema connects to CrateDB using the native CrateDB JDBC driver, visualizing distributed table schemas including sharding configurations, and enabling SQL authoring for IoT and machine-data analytics workloads through the integrated editor.