Why Tablyne for ClickHouse
A ClickHouse GUI for macOS, Windows and Linux that reads with cost gates and edits rows only where the table can prove which row it is.
Tablyne treats a ClickHouse table the way ClickHouse really works. Tables have no transactions, no unique row key and mutations that finish later. Tablyne does not hide that. It shows it, and it only lets the grid write where a write can be made safe.
Tablyne connects over HTTP or HTTPS, which includes ClickHouse Cloud, TLS with your own CA, client certificates and SSH tunnels. The sidebar lists databases, tables, views, materialized views and dictionaries, with ORDER BY and PARTITION BY in the tooltips.
Reads come with guard rails. Sorting by a column outside the sort key, reading with FINAL, or opening a view can scan a lot of data. Tablyne shows an estimate of parts and rows first and asks you to confirm. Objects that read from outside the server, such as Kafka, URL or S3 tables and dictionaries, also ask before they are read.
Editing a row is possible when the table can identify it. For MergeTree tables with block number and offset columns, the UPDATE carries the row’s identity and the values you read in its WHERE clause. If the row changed, nothing is written. For tables that cannot do this, Tablyne offers “Change by filter”, a reviewed mutation that says it applies to every matching row.
The console adds live progress, query IDs, several kinds of EXPLAIN, per-run query settings, and an Activity view with running queries, history, query insights and merges.