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.
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.
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.
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.
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.
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.
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.
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.
Builds for Apple Silicon and Intel. Requires macOS 12 or later. Connects over HTTP(S).
Installer (.exe). Windows 10 or 11 (x64). Connects over HTTP(S).
AppImage. x64, glibc 2.35 or later. Connects over HTTP(S).
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.
Yes, from one codebase: macOS (Apple Silicon and Intel), Windows and Linux.
If the row changed since you loaded it, Tablyne refuses the write and tells you. Nothing is overwritten.
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.
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.