Download ClickHouse JDBC Driver

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

Connect ClickHouse in DbSchema Install the driver, open a connection, reverse engineer your schema, and sync changes visually.
ClickHouse guide Free Download

About the ClickHouse JDBC driver

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

The ClickHouse JDBC driver

ClickHouse is a high-performance columnar OLAP database developed by Yandex, optimized for real-time analytical queries over billions of rows. It is used by companies like Cloudflare, Uber, and eBay for log analytics, business intelligence, and event tracking.

The ClickHouse JDBC URL

  • Required File(s): clickhouse-jdbc-xxx.jar
  • Java Driver Class: com.clickhouse.jdbc.ClickHouseDriver
  • JDBC URL: jdbc:clickhouse://host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[database]?key1=value1&key2=value2]
  • Website: ClickHouse Java Driver on GitHub

The driver is built on top of the native ClickHouse Java Driver. For connecting to multiple hosts you can pass a URL like: jdbc:clickhouse://host1:8123,host2:8123/my_database?user=admin&password=secret&ssl=true

Downloading the ClickHouse JDBC Driver

Download ClickHouse JDBC Driver

The driver archive is a zip file. Unzip the downloaded archive to get the driver files. The driver source code can be found on the GitHub repository. Check the GitHub link for details on how to use the driver and configure SSL.

DbSchema and ClickHouse

DbSchema renders ClickHouse tables, MaterializedViews, and Distributed table engines in the schema diagram. Use the Visual Query Builder to compose analytical queries with GROUP BY, HAVING, and window functions against ClickHouse's columnar storage.

Test the driver with DbSchema

Connect ClickHouse, build your first ER diagram in minutes. No account required.

1
Download driver & DbSchema

Get the ClickHouse driver zip below and install DbSchema for Windows, macOS, or Linux.

2
Register the .jar

In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.

3
Design & document

Reverse engineer ClickHouse, edit the model visually, and publish schema documentation.

Free DbSchema Download

Use ClickHouse visually in DbSchema

After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.

ER diagrams

Reverse engineer ClickHouse into an interactive diagram and edit structures visually.

SQL & query builder

Run SQL with autocomplete or compose queries without writing every join by hand.

Schema documentation

Export HTML docs your team can browse without installing DbSchema.

Full ClickHouse guide

Connection tips, ports, SSL, and schema design workflows on the database landing page.

ClickHouse guide

Other drivers teams often configure alongside ClickHouse.

Browse all JDBC driver downloads

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

Browse all 100+ supported databases