The open-source ClickHouse control planeYour ClickHouse, one workspace
SQL editor, dashboards, pipelines, cluster monitoring, governance, and an AI copilot. One binary on your infrastructure — open source at the core.
Ranked among the top ClickHouse GUIs in 2026 by 1bench.
Get running in seconds
$ 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:3488That's the entire install — one binary, state in a local SQLite file, no other services.
Pro adds Governance, Cluster Health, Query Insights, Schedules, Alerts, GitHub sync, and SSO on the same binary. See pricing →
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.
Learn more →Query Insights
ProLive query_log analytics: latency percentiles, slow & memory-heavy query patterns, failures, hot tables — with cross-filtering by user, table, or query text.
Learn more →Cluster Health
ProPer-node replication delay, merges, mutations, parts pressure, Keeper and backups — live drill-downs and history charts across every replica.
Learn more →Brain Copilot
AI chat that knows your schema — SQL generation, artifacts, dashboards and pipelines from natural language. Bring your own key (OpenAI, Ollama, compatible).
Learn more →Governance & Alerts
ProCatalog, lineage, query guardrails, incidents, access matrix, audit logs — plus alert channels and rules with email delivery.
Learn more →Telemetry
Search the OpenTelemetry logs already in your ClickHouse. With Pro: trace waterfalls, a metrics explorer, a service map, and monitors that raise alerts.
Learn more →MCP Server
Connect Claude, ChatGPT, Cursor or VS Code to ClickHouse through CH-UI. OAuth sign-in, read-only by default, every call audited.
Learn more →Cost Center
ProShowback and chargeback from real CPU time and storage, attributed to teams, exportable as CSV.
Learn more →Pipelines
Visual pipeline builder to ingest data from Kafka, webhooks, databases, and S3 into ClickHouse.
Learn more →Models
dbt-style SQL models with ref() DAGs, scheduled runs, and GitHub sync to keep transformations in version control.
Learn more →Tunnel Connector
Secure remote ClickHouse access through outbound WebSocket connectors — no inbound ports, works behind NAT and load balancers.
Learn more →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.
Learn more →What CH-UI includes
Product areas built for ClickHouse operators and analytics teams.
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
ProLatency percentiles, slow & memory-heavy query patterns, failures, users, and hot tables — straight from system.query_log, with cross-filtering.
Cluster Health
ProPer-node replication delay, merges, mutations, parts pressure, Keeper, and backups — live drill-downs with history charts.
Dashboards
Build panels from saved queries, arrange layouts, and share system overviews across your team.
Brain Copilot
Multi-chat AI with persisted context, SQL artifacts, provider/model controls, and run-in-chat actions.
Governance Suite
ProDashboard metrics, access matrix, incidents, policies, lineage, and sync controls.
Schedules
ProSchedule SQL queries with cron expressions, track execution history, and monitor results.
Admin Operations
ClickHouse user lifecycle, provider management, and tunnel controls.
Deployment architecture
Self-host the full stack on your infrastructure — run lightweight connectors next to ClickHouse with outbound-only traffic.
Browser
- SQL workspace
- Governance
- Brain UI
CH-UI Server
- :3488 API + UI
- Tunnel gateway
- Scheduler + syncers
Connector Host
- ch-ui connect
- Outbound only
SQLite
- Sessions, queries
- Governance, chats, audit
ClickHouse
- Your data
- HTTP :8123
Browser
- SQL workspace
- Governance
- Brain UI
CH-UI Server
- :3488 API + UI
- Tunnel gateway
- Scheduler + syncers
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, telemetry logs, and the MCP server. A Pro license ($1,199/year per instance) unlocks Query Insights, Cluster Health, Cost Center, Governance, Schedules, telemetry traces and metrics, 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.
Frequently Asked Questions
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 — 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, dashboards with shareable links, pipelines, models, telemetry logs, Brain (bring your own AI key), the MCP server for AI clients, 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, Governance with alerts, Schedules, telemetry traces, metrics and monitors, query parameters, Brain agentic tools with Ask AI, GitHub sync for models, SSO/OIDC, 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 — 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.
Ready to start?
Self-host in one command — the docs cover installation, deployment, API, and operations.