A ClickHouse GUI that checks the cost before it reads

Tablyne connects to ClickHouse over HTTP or HTTPS, including ClickHouse Cloud. It estimates the cost of heavy reads before they run, edits a row only when ClickHouse can identify it, and reviews mutations that apply to every matching row.

Download the free trial Read the docs →

ClickHouse Cloud, TLS and SSH

Connect over HTTPS with your own CA, a client certificate or an SSH tunnel. Cloud and production connections require HTTPS, and plain HTTP off this computer needs an explicit confirmation.

Cost checks before heavy reads

Sorting outside the sort key, reading with FINAL and opening some views show estimated parts and rows first. Dictionaries and external tables ask before they are read.

Row edits that prove the row

On MergeTree tables with block number and offset columns, an UPDATE carries the row identity and the values you read. If the row changed, nothing is written. ReplacingMergeTree tables edit by version.

Change by filter, reviewed

Prepare a lightweight delete, ALTER DELETE or ALTER UPDATE for every row a filter matches. The review shows the SQL, an estimate and the warnings, and you follow the mutation in its own tab.

Console with EXPLAIN and live progress

Typed parameters, per-run settings, EXPLAIN as plan, estimate, pipeline, actions or syntax tree, and rows read, bytes and memory while the query runs. Cancel sends KILL QUERY.

Activity, sizes and Parquet

See running queries, history, query insights and merges, and the disk size and compression per table and column. Export to Parquet, written by the server, or import Parquet straight to a table.

ClickHouse on macOS, Windows and Linux

macOS

Builds for Apple Silicon and Intel. Requires macOS 12 or later. Connects over HTTP(S).

Windows

Installer (.exe). Windows 10 or 11 (x64). Connects over HTTP(S).

Linux

AppImage. x64, glibc 2.35 or later. Connects over HTTP(S).

FAQ

Is Tablyne's ClickHouse GUI free? +

Free for 14 days: the trial has every feature, ClickHouse included, with no card. Then Pro is a one-time purchase of $99, commercial use included.

Does it run on Mac, Windows and Linux? +

Yes, from one codebase: macOS (Apple Silicon and Intel), Windows and Linux.

How does Tablyne avoid overwriting changes in ClickHouse? +

If the row changed since you loaded it, Tablyne refuses the write and tells you. Nothing is overwritten.

Does it use the TCP port 9000? +

No. Tablyne connects over the HTTP or HTTPS interface, for example port 8123 or 8443. If you paste a URL with port 9000 or 9440, it asks you to choose an HTTP(S) endpoint.

Why can't the grid edit some tables? +

ClickHouse has no unique row key, so Tablyne edits only when it can identify the row. A table without a UUID, with a projection or on your own replicated cluster is read-only in the grid, and the reason is shown. Use Change by filter instead.

Docs for ClickHouse