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 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
localhostwhile the real Clickhouse server host will be specified as an SSH server.
- Test connection:
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).
Clickhouse does not support referential integrity so you will not see foreign keys. ER diagrams are also does not make much sense.