How to Connect ClickHouse to DataGrip in PostgreSQL

What driver do I need?

Install the official ClickHouse JDBC driver (com.clickhouse:clickhouse-jdbc) via DataGrip’s “Drivers” tab. This enables SSL, compression, and all ClickHouse-specific settings.

How do I add a ClickHouse data source?

Open File → Data Sources, click +, choose ClickHouse, and paste the JDBC URL. DataGrip auto-downloads the driver if missing.

What JDBC URL should I use?

Use the pattern jdbc:clickhouse://HOST:PORT/DATABASE?user=USER&password=PWD.Replace placeholders with your server details.

Example URL

jdbc:clickhouse://analytics.acme.com:8123/ecommerce?user=reporting&password=S3cr3t

Which advanced parameters matter?

Set ssl=true for encrypted traffic and compress=true for faster transfers. Toggle socket_timeout or session_id when running long analytical jobs.

Can I use SSH tunneling?

Yes. In the SSH/SSL tab select “Use SSH Tunnel”, fill bastion host, port, and key. DataGrip forwards traffic securely to ClickHouse.

How do I test the connection?

Click Test Connection.A green check confirms authentication, driver compatibility, and network reachability.

How do I run my first query?

After saving, double-click the new data source, open a new SQL console, and run a query such as SELECT count() FROM Orders.

Why are my tables missing?

Refresh the schema tree or grant SHOW DATABASES and SELECT privileges to your user.

How do I switch databases?

Either change the database in the JDBC URL or run USE other_db in the console.

Best practices for production

Store credentials in DataGrip’s password vault, enable SSL, and keep the driver updated.Limit result set size in Settings → Database to prevent memory spikes.

What common mistakes should I avoid?

Incorrect ports (8123 HTTP vs 9000 TCP) and mismatched drivers cause most failures. Confirm your ClickHouse server’s port and driver version.

Long-running query tips

Increase query_timeout in the JDBC URL or DataGrip’s “Query Execution” settings to avoid premature cancellations.

See it in action

Run the sample ecommerce query below to verify full CRUD access.

.