Introduction

CH-UI is the control plane for ClickHouse. SQL editing, dashboards, pipelines, governance, scheduling, and an AI copilot — for your whole team, in one workspace.

Stop stitching together a SQL client, a BI tool, a lineage tracker, and a pile of cron jobs. CH-UI is all of it, connected to your cluster in minutes.

Get started in minutes

• CH-UI Cloud — managed at console.ch-ui.com. Sign in with email, create an org, connect your ClickHouse with a one-line connector. No infrastructure to run, no upgrades to babysit. See pricing →
• Self-hosted — the open-source core (Apache-2.0) on your own box. Self-hosting guide →

Why teams choose CH-UI

• One workspace, not five tools — query, visualize, transform, schedule, and govern in the same place.
• AI that actually helps — Brain understands your schema and writes ClickHouse-idiomatic SQL. Managed for you, or bring your own model.
• Governance built in — column-level lineage, an access matrix, policies, incidents, and a query audit trail.
• Secure by design — a lightweight connector exposes ClickHouse over an outbound-only WebSocket tunnel; your cluster never needs a public port.
• Real team collaboration — organizations, member roles, isolated per-org workspaces, and self-serve billing (Cloud).
• Fast to value — cloud sign-up or a single self-host binary; you're querying in minutes.

What you get

• SQL editor & explorer — autocomplete, result views, schema browser, saved queries.
• Dashboards — drag-and-drop panels (charts, stats, tables) with shareable public links.
• Pipelines — visual ingestion from Kafka, webhooks, databases, and S3.
• Models — versioned SQL transformations with DAG execution and scheduling.
• Schedules — recurring queries with run history and alerting.
• Governance — metadata sync, lineage, access matrix, policies, incidents, query log.
• Brain (AI copilot) — schema-aware chat with skill packs and living artifacts (re-runnable charts, reports, queries), managed or BYO provider.
• Alerts — email notifications (delivered for you on Cloud) for governance events.

See Pricing for what's included on each plan.

Quick start — Cloud

1. Go to console.ch-ui.com and sign in (magic link — no password).
2. Create an organization.
3. Add a connection and run the connector next to your ClickHouse (one command, copy-paste).
4. Open your workspace at your-org.ch-ui.com.

See the Console guide for full details.

Quick start — Self-hosted

# Download the binary (macOS Apple Silicon example)
curl -L -o ch-ui https://github.com/caioricciuti/ch-ui/releases/latest/download/ch-ui-darwin-arm64
chmod +x ch-ui && sudo install -m 755 ch-ui /usr/local/bin/ch-ui

# Run (no external database needed)
ch-ui
# UI on http://localhost:3488

Self-hosted CH-UI stores its state in a local SQLite database (ch-ui.db) — no external database to run. The installation guide covers configuration. If first-run login fails, see Can't login?.

Architecture

CH-UI runs in two pieces:

1. ch-ui server — UI, API, scheduler, governance syncers, and the tunnel gateway.
2. ch-ui connect — a lightweight connector that exposes a ClickHouse instance over a secure, outbound-only WebSocket.

This lets CH-UI live on one host and ClickHouse on another, with only outbound traffic from the ClickHouse side — no inbound ports to open.

Next steps