How to Connect ClickHouse to DBeaver

How do I connect ClickHouse to DBeaver?

Connect ClickHouse to DBeaver by installing the ClickHouse JDBC driver, creating a new connection, and supplying the JDBC URL, credentials, and optional SSL parameters.

Welcome to the Galaxy, Guardian!

Oops! Something went wrong while submitting the form.

Description

How do I add a ClickHouse connection in DBeaver?

Open DBeaver, click Database ▸ New Database Connection, search for “ClickHouse,” and select the driver. If it’s missing, press Download to fetch the JDBC files automatically.

In the connection dialog, enter your host, port (8123 for HTTP, 9440 for HTTPS), and database name. Provide user and password credentials, then click Test Connection.

What JDBC URL should I use?

Use the canonical ClickHouse URL: jdbc:clickhouse://host:port/database. Add parameters such as ssl=true, sslmode=require, compress=lz4, or socket_timeout=300000 to harden security and improve performance.

How can I run my first query?

After the connection opens, press Ctrl+Enter to execute a query tab. Run SHOW TABLES to verify your ecommerce schema. Then try the sample query below to confirm joins and aggregates work.

Which performance settings matter most?

Enable Use HTTP Interface for large result sets, set Fetch Size to 10 000–50 000, and turn on compression (compress=lz4) in the JDBC URL. These tweaks reduce memory pressure and speed up data transfers.

How do I save credentials securely?

Navigate to DBeaver ▸ Preferences ▸ Database ▸ General and enable Keep Passwords encrypted in OS-specific keystore. This prevents plain-text storage of ClickHouse passwords.

Best practices for team sharing?

Create a Project in DBeaver, store your ClickHouse connection inside, and commit the .dbeaver-data-sources.xml file to version control without the password token. Teammates can import the connection and add their own secrets.

Why How to Connect ClickHouse to DBeaver is important

How to Connect ClickHouse to DBeaver Example Usage


-- Top 10 customers by lifetime spend
SELECT c.id, c.name, SUM(o.total_amount) AS lifetime_spend
FROM Customers c
JOIN Orders o ON o.customer_id = c.id
GROUP BY c.id, c.name
ORDER BY lifetime_spend DESC
LIMIT 10;

How to Connect ClickHouse to DBeaver Syntax


jdbc:clickhouse://<HOST>:<PORT>/<DATABASE>?user=<USER>&password=<PASSWORD>[&ssl=true][&sslmode=require][&compress=lz4][&socket_timeout=300000]

Example (ecommerce staging):
jdbc:clickhouse://ckh-stg.acme.com:9440/ecommerce?user=analytics&password=${env:CKH_PASS}&ssl=true&sslmode=require&compress=lz4&socket_timeout=300000

Common Mistakes

Forgetting to download the ClickHouse JDBC driver. Without the driver, DBeaver cannot create the connection. Fix: In the New Connection wizard, click “Download” when prompted.
Omitting required SSL parameters on secured clusters. The connection fails with TLS errors. Fix: append `ssl=true&sslmode=require` to the JDBC URL or uncheck the SSL option only on trusted networks.

Frequently Asked Questions (FAQs)

Can I use SSH tunneling with ClickHouse?

Yes. In the connection wizard, open the SSH tab, enable tunneling, and supply your bastion host credentials. DBeaver automatically routes traffic through the tunnel.

What port does ClickHouse use for JDBC?

By default, 8123 for HTTP and 9440 for HTTPS. Match the port to your cluster’s listener and any firewall rules.

How do I change fetch size?

Right-click the connection, choose Edit Connection ▸ Driver Properties, and set max_result_rows or adjust Fetch Size under Data Editor ▸ Result Sets.