Skip to content

Clickhouse

Yandex Clickhouse

ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.

DBeaver uses a standard Clickhouse JDBC driver to communicate with Clickhouse servers. The driver is downloaded automatically once you establish a connection with the database server.

Connection setup

Connection initiation is very easy.

  • Select Clickhouse driver:

  • The only required connection parameter is the host name.

  • You can a configure SSH tunnel to access your server. In this case, set the database host name to localhost while the real Clickhouse server host will be specified as an SSH server.

  • Test connection:

Schema/data browser

You can browse/edit, analyse data in Clickhouse tables:

DBeaver supports native Clickhouse table DDLs:

Clickhouse extension supports most standard DBeaver features (SQL editor, data view/edit, data transfer, mock data generation, etc).

Limitations

Clickhouse does not support referential integrity so you will not see foreign keys. ER diagrams are also does not make much sense.