Your ClickHouse.One workspace.
SQL editor, dashboards, pipelines, cluster monitoring, governance and an AI copilot. One binary on your infrastructure, and your data never leaves it.
- Apache-2.0 core
- Single binary, SQLite state
- No call-home
$ curl -L -o ch-ui \ https://github.com/caioricciuti/ch-ui/releases/latest/download/ch-ui-linux-amd64$ chmod +x ch-ui && ./ch-uiServer listening on http://localhost:3488$ curl -L -o ch-ui \ https://github.com/caioricciuti/ch-ui/releases/latest/download/ch-ui-linux-arm64$ chmod +x ch-ui && ./ch-uiServer listening on http://localhost:3488$ curl -L -o ch-ui \ https://github.com/caioricciuti/ch-ui/releases/latest/download/ch-ui-darwin-arm64$ chmod +x ch-ui && ./ch-uiServer listening on http://localhost:3488$ docker run -d --name ch-ui -p 3488:3488 \ -v ch-ui-data:/app/data \ ghcr.io/caioricciuti/ch-ui:latestOpen http://localhost:3488That is the entire install: one binary, state in a local SQLite file, no other services.
Multi-tab editing with streaming results, sort and filter on results, automatic query history, and errors that jump to the failing line.Read the docs
Build panels from saved queries, arrange layouts, and share system overviews across your team.Read the docs
Multi-chat AI with persisted context, SQL artifacts, provider and model controls, and run-in-chat actions.Read the docs
Latency percentiles, slow and memory-heavy query patterns, failures, users and hot tables, straight from system.query_log.Read the docs
Per-node replication delay, merges, mutations, parts pressure, Keeper and backups: live drill-downs with history charts.Read the docs
Dashboard metrics, access matrix, incidents, policies and sync controls.Read the docs
Schedule SQL queries with cron expressions, track execution history, and monitor results.Read the docs
ClickHouse user lifecycle, provider management, and tunnel controls.Read the docs
Ranked among the top ClickHouse GUIs in 2026 by 1bench.
What's inside
One workspace, not five tools.
A data workbench, ClickHouse-native observability and platform controls, so a team can ship and govern from one place.
- SQL workspace
- Multi-tab editor with streaming results, sort and filter on results, automatic query history, and errors that jump your cursor to the failing token.
- Query InsightsPro
- Live query_log analytics: latency percentiles, slow and memory-heavy query patterns, failures and hot tables, cross-filtered by user, table or query text.
- Cluster HealthPro
- Per-node replication delay, merges, mutations, parts pressure, Keeper and backups, with live drill-downs and history charts across every replica.
- Brain
- AI chat that knows your schema, with skills and artifacts. Bring your own key. With Pro: Ask AI in the editor and agentic tools that build dashboards and pipelines.
- Governance and alertsPro
- Catalog, query guardrails, incidents, access matrix and audit logs, plus alert channels and rules with email delivery.
- Telemetry
- Search the OpenTelemetry logs already in your ClickHouse. With Pro: trace waterfalls, a metrics explorer, a service map, and monitors that raise alerts.
- MCP server
- Connect Claude, ChatGPT, Cursor or VS Code to ClickHouse through CH-UI. OAuth sign-in, read-only by default, every call audited.
- Cost CenterPro
- Showback and chargeback from real CPU time and storage, attributed to teams, exportable as CSV.
- Pipelines
- A visual builder to ingest data from Kafka, webhooks, databases and S3 into ClickHouse.
- Models
- dbt-style SQL models with ref() DAGs and cron-scheduled runs. With Pro: GitHub sync to keep transformations in version control.
- Tunnel connector
- Reach a remote ClickHouse 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.
Architecture
Your infrastructure, outbound only.
The server runs where you put it. A lightweight connector sits next to ClickHouse and dials out, so the cluster never needs a public port.
Pricing
Free core. One license when you need more.
Open Source Free, Apache-2.0
Editor, dashboards, pipelines, models, Brain chat, query history, telemetry logs and the MCP server. Unlimited users, forever.
Pro $1,199 per instance, per year
Query Insights, Cluster Health, Cost Center, Governance, Alerts, SSO, scheduled query jobs, traces and metrics, Ask AI, audit forwarding and GitHub sync. Flat, never per seat, activated with a key, no call-home.
Enterprise Custom
Multiple instances, volume pricing, invoice billing, security review and custom terms.
Questions
Asked often.
What is CH-UI?
CH-UI is the open-source control plane for ClickHouse: SQL editor, dashboards, pipelines, dbt-style models, governance, cluster monitoring, and the Brain AI copilot in one workspace. It ships as a single self-hosted binary that stores its state in a local SQLite database, with no external services to operate.
Is CH-UI really free?
Yes. The core is open source under Apache-2.0 and free forever, with unlimited users: SQL editor with query history and query parameters, saved queries, dashboards with shareable links, pipelines, models with cron schedules, telemetry logs, Brain AI chat (bring your own AI key), the MCP server for AI clients, the admin panel with multiple connections, and the tunnel connector. Only the Pro modules require a paid license.
What does Pro add?
A Pro license ($1,199/year per instance, flat, never per seat) unlocks Query Insights, Cluster Health, Cost Center, Performance, Governance, Alerts, scheduled query jobs, fleet overview, schema comparison, weekly reports, telemetry traces, metrics, service map and monitors, Ask AI and Brain agentic tools, GitHub sync for models, SSO/OIDC, audit forwarding to your SIEM, and priority support. You can try everything free for 30 days, no card required.
Where does my data live?
On your infrastructure. CH-UI is self-hosted, keeps its state in a local SQLite file, and the connector reaches ClickHouse over an outbound-only WebSocket tunnel, so your cluster never needs a public port. The Pro license is verified locally with no call-home, so air-gapped deployments work.
What do I need to run it?
One binary (or Docker) and a ClickHouse instance to connect to. No external database. Download the release, run ch-ui, and the UI is on localhost:3488. If ClickHouse lives on another host, run the lightweight ch-ui connect connector next to it with outbound-only traffic.
How is CH-UI licensed?
The core is Apache-2.0, free for commercial use. Pro modules are source-available under the Business Source License 1.1 and unlock with a signed license file: a flat annual subscription via Stripe, one license per running instance, activated offline in Settings → License.
Point it at your cluster.
One command to self-host. The docs cover installation, deployment, the API and operations.