> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect DBeaver to ClickHouse

> DBeaver is a multi-platform database tool.

Partner Integration

DBeaver is available in multiple offerings. In this guide [DBeaver Community](https://dbeaver.io/) is used. See the various offerings and capabilities [here](https://dbeaver.com/edition/).  DBeaver connects to ClickHouse using JDBC.

> [!NOTE]
>
> Please use DBeaver version 23.1.0 or above for improved support of `Nullable` columns in ClickHouse.

**1. Gather your ClickHouse details**

DBeaver uses JDBC over HTTP(S) to connect to ClickHouse; you need:

* endpoint
* port number
* username
* password

**2. Download DBeaver**

DBeaver is available at [https://dbeaver.io/download/](https://dbeaver.io/download/)

**3. Add a database**

* Either use the **Database > New Database Connection** menu or the **New Database Connection** icon in the **Database Navigator** to bring up the **Connect to a database** dialog:

![Add a new database](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-add-database.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=66cf7445664304b309592c6e808cded5)

* Select **Analytical** and then **ClickHouse**:

* Build the JDBC URL. On the **Main** tab set the Host, Port, Username, Password, and Database:

![Set the hostname, port, user, password, and database name](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-host-port.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=69ba29eb527c58140845e185075f6bd7)

* By default the **SSL > Use SSL** property will be unset, if you're connecting to ClickHouse Cloud or a server that requires SSL on the HTTP port, then set **SSL > Use SSL** on:

![Enable SSL if required](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-use-ssl.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=80dd13dba8d3a3ed9dede65ecb0489ff)

* Test the connection:

![Test the connection](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-test-connection.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=63efcee0171ba315e285ed14c4fb6cb0)

If DBeaver detects that you don't have the ClickHouse driver installed it will offer to download them for you:

![Download the ClickHouse driver](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-download-driver.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=561b6bc883fdc6c9af620316da225341)

* After downloading the driver **Test** the connection again:

![Test the connection](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-test-connection.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=63efcee0171ba315e285ed14c4fb6cb0)

**4. Query ClickHouse**

Open a query editor and run a query.

* Right click on your connection and choose **SQL Editor > Open SQL Script** to open a query editor:

![Open the SQL editor](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-sql-editor.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=a813da97697a1993f5d19d030cb782d1)

* An example query against `system.query_log`:

![A sample query](https://mintcdn.com/private-7c7dfe99/6s0zAeps_NYZmK2e/images/integrations/sql-clients/dbeaver-query-log-select.webp?fit=max\&auto=format\&n=6s0zAeps_NYZmK2e\&q=85\&s=9e2ec664de9a6abca2e7efd2f008aaeb)

## Next steps

See the [DBeaver wiki](https://github.com/dbeaver/dbeaver/wiki) to learn about the capabilities of DBeaver, and the [ClickHouse documentation](https://clickhouse.com/docs/index.md) to learn about the capabilities of ClickHouse.
