CH-UIThe open-source ClickHouse control plane

Your ClickHouse, one workspace

SQL editor, dashboards, pipelines, query analytics, cluster monitoring, governance, and an AI copilot — one single binary, on your infrastructure. Open source at its core. Pro is a license key, not a subscription to someone else's servers.

Self-host in one commandTry Pro free for a monthGitHub
Apache-2.0 coreSingle binary · SQLite state · no external servicesYour data never leaves your infrastructure

Get running in seconds

Self-Hosted

# Download (macOS Apple Silicon)
curl -L -o ch-ui https://github.com/caioricciuti/ch-ui/releases/latest/download/ch-ui-darwin-arm64
chmod +x ch-ui

# Start server
./ch-ui

# Open http://localhost:3488

Prefer managed?

CH-UI Cloud runs the server for you — sign up at the Console, create an org, and connect your ClickHouse through an outbound connector.

Open Console

Built for real operations

CH-UI combines data workbench, ClickHouse-native observability, and platform controls so teams can ship and govern from one place.

SQL Workspace

Multi-tab editor with streaming results, sort & filter on results, automatic query history, and errors that jump your cursor straight to the failing token.

Query Insights

Pro

Live query_log analytics: latency percentiles, slow & memory-heavy query patterns, failures, hot tables — with cross-filtering by user, table, or query text.

Cluster Health

Pro

Per-node replication delay, merges, mutations, parts pressure, Keeper and backups — live drill-downs and history charts across every replica.

Brain Copilot

AI chat that knows your schema — SQL generation, artifacts, dashboards and pipelines from natural language. Bring your own key (OpenAI, Ollama, compatible).

Governance & Alerts

Pro

Catalog, lineage, query guardrails, incidents, access matrix, audit logs — plus alert channels, rules, and escalation.

Pipelines

Visual pipeline builder to ingest data from Kafka, webhooks, databases, and S3 into ClickHouse.

Models

dbt-style SQL models with ref() DAGs, scheduled runs, and GitHub sync to keep transformations in version control.

Tunnel Connector

Secure remote ClickHouse access through outbound WebSocket connectors — no inbound ports, works behind NAT and load balancers.

Open Source Core

The core is Apache-2.0 and free forever. Pro features unlock with a license key on your own hardware — your data never touches our servers.

What CH-UI includes

Product areas built for ClickHouse operators and analytics teams.

SQL Workspace

SQL Workspace

Multi-tab editing with streaming results, sort & filter on results, automatic query history, and errors that jump to the failing line.

Query Insights

Query Insights

Pro

Latency percentiles, slow & memory-heavy query patterns, failures, users, and hot tables — straight from system.query_log, with cross-filtering.

Cluster Health

Cluster Health

Pro

Per-node replication delay, merges, mutations, parts pressure, Keeper, and backups — live drill-downs with history charts.

Dashboards

Dashboards

Build panels from saved queries, arrange layouts, and share system overviews across your team.

Brain Copilot

Brain Copilot

Multi-chat AI with persisted context, SQL artifacts, provider/model controls, and run-in-chat actions.

Governance Suite

Governance Suite

Pro

Dashboard metrics, access matrix, incidents, policies, lineage, and sync controls.

Schedules

Schedules

Pro

Schedule SQL queries with cron expressions, track execution history, and monitor results.

Admin Operations

Admin Operations

ClickHouse user lifecycle, provider management, and tunnel controls.

Deployment architecture

Self-host the full stack on your infrastructure — or let Cloud handle the server while you run connectors next to ClickHouse.

Browser

  • SQL workspace
  • Governance
  • Brain UI
HTTPS

CH-UI Server

  • :3488 API + UI
  • Tunnel gateway
  • Scheduler + syncers
WSS

Connector Host

  • ch-ui connect
  • Outbound only

SQLite

  • Sessions, queries
  • Governance, chats, audit

ClickHouse

  • Your data
  • HTTP :8123

Free core. One license when you need more.

The open-source core is free forever — editor, dashboards, pipelines, models, Brain, query history. A Pro license ($1,199/year per instance) unlocks Query Insights, Cluster Health, Governance, Schedules, query parameters, and GitHub sync — on your hardware, activated with a key, no call-home. Flat per instance, never per seat. Try it free for a month — no card required.

Start free trialBuy a licenseCompare plans

Ready to start?

Self-host in one command — the docs cover installation, deployment, API, and operations. Prefer managed? CH-UI Cloud is there too.

Self-Host nowRead DocsTry Cloud