Clickhouse - rbellamy/dbeaver GitHub Wiki

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 standard Clickhouse JDBC driver to communicate with Clickhouse servers. Driver is downloaded automatically once you establish connection with database server.

Connection setup

Connection initiation is very easy.

  1. Select Clickhouse driver:

  1. The only required connection parameter is host name.

  1. You can configure SSH tunnel to access your server. In that case set database host name to localhost while real Clickhouse server host will be specified as SSH server.

  1. Test connection:

Schema/data browser

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

DBeaver supports native Clickhouse table DDLs:

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

Limitations

Clickhouse doesn't support referential integrity so you won't see foreign keys. ER diagrams are also doesn't make much sense.