ClickHouse · supported engine

A ClickHouse GUI for large analytical datasets.

HTTP-driver analytics with SQL execution, table browsing, schema introspection, batch inserts, and primary-key-aware row editing.

Included with Mongrel Try free for 7 days

HTTP driver · TLS

Billions of rows, zero drama

The plan Mongrel builds for your query.

Click any node below to walk the operators, parts, and granules in the plan. Same Visual EXPLAIN you get inside the workbench.

// ReadFromMergeTree · events

Scans 96 parts and 12,480 granules. The primary key (event_date, user_id) only prunes by date - tenant_id can't skip granules. A projection keyed by tenant_id would.

-- events · prod-analytics-1
SELECT
  toDate(event_time) AS day,
  uniqExact(user_id) AS dau,
  countIf(event = 'purchase') AS purchases
FROM events
WHERE event_time >= '2026-06-01'
  AND tenant_id = 42
GROUP BY day
ORDER BY purchases DESC
LIMIT 20;

-- 3.8s · 20 rows returned
-- Prune by tenant: add a projection

ALTER TABLE events
  ADD PROJECTION by_tenant
  (SELECT * ORDER BY (tenant_id, event_time));

ClickHouse surface

What Mongrel ships for ClickHouse.

SQL editor & execution

Run ClickHouse SQL with result paging, server-side query cancellation, and a configurable command timeout.

Visual EXPLAIN

See the query plan as an interactive operator tree - from ReadFromMergeTree at the storage layer up through aggregation and sort.

Table browsing

Browse tables with engine, ORDER BY key, partition, and row counts. Page through rows with point-and-click filters and sorts.

Schema introspection

Inspect engines, primary/sorting/partition keys, and data-skipping indexes. Full CREATE TABLE DDL one click away.

Batch inserts

Add rows through the grid one at a time or in batched bulk inserts, straight into MergeTree tables.

PK-aware row editing

Edit rows in place with primary-key-aware updates. Mutations run as synchronous ALTER TABLE ... UPDATE/DELETE behind write-safety gates, with bulk previews.

AI query help

Describe the query you need in English - the assistant drafts ClickHouse SQL from your live schema for you to review and accept.

TLS & SSH connections

Connect over HTTP or HTTPS with TLS, or reach servers behind a bastion through a host-brokered SSH tunnel.

Import & export

Import CSV or JSON row data into tables, and export the current result page to JSON or CSV.

Connect ClickHouse in 30 seconds.

7-day trial. macOS, Windows, Linux. No credit card.

Download Mongrel