ClickHouse

A ClickHouse client that belongs on a Mac.

Connect over ClickHouse's HTTP interface, or to ClickHouse Cloud — where you can sign in through your browser instead of a database password.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

ClickHouse

What ClickHouse gets.

The kinds of object that exist on an engine are the kinds the app shows. This is ClickHouse's row of the features table, and what stands behind it.

EngineEditable gridDesignersUsers & RolesDiagram
ClickHouse and ClickHouse Cloud✓✓tables✓✓

Sign in with your browser

For ClickHouse Cloud, choose Cloud SSO or Cloud SSO (Read-Only) and click Sign In with Browser; no database password is needed.

Guide: ClickHouse in the docs

No transactions, and it says so

ClickHouse has no transactions, so grid changes apply statement by statement. Keys are fixed when a table is created, and its columns have no collation: what the engine cannot do is stated, not hidden.

Guide: the table designer

Accounts and grants

Grants at global, database and table level. Read the SQL preview, then create or save; Edit as SQL hands you the script in a query tab instead.

Guide: users and roles

clickhouse-client in a tab

A console tab runs clickhouse-client in a real terminal. A browser sign-in has no console, and neither has a tunnelled connection: the client speaks ClickHouse's native protocol, which a tunnel set up for the HTTP port does not carry.

Guide: console tabs
Connect

Connect to ClickHouse.

Click Add Connection under the sidebar and pick the ClickHouse tile. Paste a connection string — the field reads clickhouse:// addresses — and the fields fill themselves in, or type the host, port, database, user and password. Click Test Connection, then Add.

Default port
8123, the HTTP interface; ClickHouse Cloud uses 8443
SSL
Disabled, Required, Verify Certificate
Sign-in
Password, Cloud SSO or Cloud SSO (Read-Only). With SSO, click Sign In with Browser; no database password is needed.
Console
clickhouse-client — brew install --cask clickhouse. A browser sign-in has no console.
Notes
ClickHouse has no transactions, so grid changes apply statement by statement. Keys are fixed when a table is created, and there are no foreign keys.

Guide: ClickHouse in the docs Guide: your first connection

Hosted services built on ClickHouse get a tile of their own with the port and SSL mode they expect: ClickHouse Cloud

ServicePortSSL
ClickHouse Cloud8443Verify Certificate

Guide: hosted services

Every engine

One app for the rest of your databases, too.

Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient