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 initiation is very easy.
- Select Clickhouse driver:
- The only required connection parameter is host name.
- You can configure SSH tunnel to access your server. In that case set database host name to
localhostwhile real Clickhouse server host will be specified as SSH server.
- Test connection:
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).
Clickhouse doesn't support referential integrity so you won't see foreign keys. ER diagrams are also doesn't make much sense.