Open source · MIT

A real-time admin panel for ClickHouse

Auto-detects topology — single node, self-hosted cluster, or ClickHouse Cloud. Monitor queries, kill runaway loads, manage access, and wake idle services.

Try the live demo → View on GitHub

$ docker run -d -p 8080:80 -e CLICKHOUSE_HOST=your-host bun4uk/chadmin:latest

Live preview

Click around, no install needed

Embedded UI kit with mock data across all three topology modes. Kill a query, drop a user, switch warehouses, toggle the theme.

⬢chadmin.local

Open the demo in a new tab ↗

One UI, three modes

Auto-detects your ClickHouse

Set the env vars and Chadmin figures out the rest. Same dashboard, mode-aware SQL underneath.

CLICKHOUSE_MODE=single

Single node

One host, one connection. Lightweight, zero topology probing.

Direct queries against system.*
No cluster overhead
HTTP or HTTPS

CLICKHOUSE_MODE=cluster

Self-hosted cluster

Failover across hosts; per-replica memory and state in one view.

clusterAllReplicas() queries
Comma-separated host failover
Skips unavailable shards

CLICKHOUSE_MODE=cloud

ClickHouse Cloud

API-driven service discovery. Wake idle services on demand without polling them awake.

Control-plane state, not data-plane probes
Warehouse-aware grouping
One-click wake for idle/stopped

What you get

Operator-grade ClickHouse tooling

Built for the things you actually do at 3am when a query is eating the cluster.

Live query monitor

30-second polling with pause-on-hidden — your idle Cloud services stay idle.

One-click kill

Per-replica KILL QUERY with confirmation. No SQL editor needed.

Users & access

Browse system.users / grants / role_grants; drop accounts in a click.

Wake idle services

Cloud-aware: control plane for state, data-plane ping only when you ask.

Single Docker image

nginx + php-fpm + React, baked. Multi-arch: linux/amd64 and linux/arm64.

Dark & light themes

That ClickHouse-yellow accent, in both moods. Persists across reloads.

Quick start

Up in 30 seconds

Pick a registry, paste the run command, open http://localhost:8080.

# Self-hosted ClickHouse — single host or cluster
docker run -d --name chadmin -p 8080:80 \
  -e CLICKHOUSE_HOST=clickhouse.example.com \
  -e CLICKHOUSE_PORT=8123 \
  -e CLICKHOUSE_USERNAME=default \
  -e CLICKHOUSE_PASSWORD=secret \
  bun4uk/chadmin:latest

# Same image, GitHub Container Registry
docker run -d --name chadmin -p 8080:80 \
  -e CLICKHOUSE_HOST=clickhouse.example.com \
  -e CLICKHOUSE_PORT=8123 \
  -e CLICKHOUSE_USERNAME=default \
  -e CLICKHOUSE_PASSWORD=secret \
  ghcr.io/bun4uk/chadmin:latest

# Cloud mode auto-activates when API credentials are present
docker run -d --name chadmin -p 8080:80 \
  -e CLICKHOUSE_CLOUD_KEY_ID=xxxxxxxx \
  -e CLICKHOUSE_CLOUD_KEY_SECRET=yyyyyyyy \
  bun4uk/chadmin:latest

Full env-var reference is in .env.example. Available tags: latest, semver (M.m.p), M.m, M. Need help? Open an issue.