ClickHouse

Columnar analytics over the HTTP interface.

Ready

ClickHouse connects over its HTTP interface and browses databases, tables, views, and materialized views, with the schema-aware SQL editor and a visual EXPLAIN that shows which partitions and granules a query read.

Capabilities

Connections

Ready

Host, HTTP port (8123), database, and credentials, with optional TLS.

Schema browser

Ready

Databases, tables, views, materialized views, and enum types.

SQL editor and results

Ready

Schema-aware completion and the native result grid.

Create forms

Ready

Create databases, tables, views, and materialized views.

Visual EXPLAIN

Ready

EXPLAIN rendered as a graph, with the index and the granules each read kept.

In the app

ZQLZ grid of a ClickHouse table with Enum8, FixedString, Array, Map, Tuple, IPv4 and IPv6 columns beside the column list — ClickHouse's own types, from Enum8 and LowCardinality to Tuple, Map and IPv6, in a typed grid.

ZQLZ objects panel listing ClickHouse tables with engine, row count and size in bytes — Tables with their engine, row count and size on disk.

ZQLZ editor with a ClickHouse query reading the sub-columns of a JSON column — A June traffic report that reads a JSON column's sub-columns directly.

ZQLZ visual explain for a ClickHouse join showing the index scan with its surviving granules — A join's query plan as a graph, with the index and the granules it kept.

ZQLZ grid of a ClickHouse orders table beside its column list — A MergeTree table opens as a grid, with its column types alongside.

ZQLZ grid of a ClickHouse table named select with keyword, spaced, hyphenated and emoji column names — A table called select, with column names that need quoting.

Connecting

Host, HTTP port (8123), database, username, and password, with optional HTTPS.

← All databases

ClickHouse

Columnar analytics over the HTTP interface.

Download ZQLZ View roadmap

Ready

Capabilities

Connections

Ready

Host, HTTP port (8123), database, and credentials, with optional TLS.

Schema browser

Ready

Databases, tables, views, materialized views, and enum types.

SQL editor and results

Ready

Schema-aware completion and the native result grid.

Create forms

Ready

Create databases, tables, views, and materialized views.

Visual EXPLAIN

Ready

EXPLAIN rendered as a graph, with the index and the granules each read kept.

In the app

Connecting

Host, HTTP port (8123), database, username, and password, with optional HTTPS.

← All databases