CH-UI
Open-source single-binary ClickHouse workspace: SQL editor, dashboards, pipelines and an AI copilot, self-hosted
0About CH-UI
CH-UI is an open-source control plane for ClickHouse that ships as a single binary with its state in a local SQLite file and no external services to operate. Install is a curl of one release artifact, chmod, and run; the server comes up on port 3488 and everything — SQL editor, dashboards, pipelines, query analytics, cluster monitoring, governance and an AI copilot — lives inside that one process. The workbench itself is a multi-tab SQL editor with streaming results, sort and filter applied to the result set, automatic query history, and error messages that jump the cursor to the failing token rather than reporting a line number. Around that sit dashboards with shareable public links, dbt-style models and ingestion pipelines from Kafka, S3, webhooks and databases, an OpenTelemetry log explorer, and a tunnel connector so you never have to open an inbound port to your cluster. The AI copilot, called Brain, is bring-your-own-key on the open-source core. The commercial split is honest and easy to reason about: the Apache-2.0 core is free forever with unlimited users, and Pro is a BSL license key that unlocks Governance, Cluster Health, Query Insights, Schedules, Alerts, GitHub sync and SSO on the exact same binary running on your own hardware. Nothing is hosted by the vendor, so data never leaves your infrastructure.
Does ChatGPT recommend your AI tool?
If you're building in Data & Analytics, run a free AI-visibility scan on your own product — we ask ChatGPT across 5 prompt angles and score how often you get named. ~30 seconds, no signup, no card.
Key Features
CH-UI Pros & Cons
✅ Pros
- +Flat per-instance Pro license instead of per-seat billing
- +Runs entirely on your hardware — no data leaves your infrastructure
- +Apache-2.0 core is genuinely usable, not a crippled demo
⚠️ Cons
- −ClickHouse-specific; useless if your warehouse is anything else
- −$1,199/year is a real commitment for a small team wanting only SSO
- −AI copilot requires your own model key on the free tier
Tags
Is CH-UI your tool?
This is the page buyers and AI assistants read when they look up CH-UI. Claim your listing for $19 one-time — no subscription, nothing to cancel — and take a capped slot in your category: each one sells a fixed number, and yours ranks above every free tool in it, with a Featured badge. Prefer it ongoing? Monthly is one click away on the next page.
Complete Your Data & Analytics Stack
Other data & analytics tools in our catalog:
Consensus
Try FreeAI search across 200M research papers
Source real evidence behind your analysis
Gamma
Try FreeAI presentation builder
Turn ideas into polished decks instantly
1Password
Try FreeSecrets and credential manager
Keep API keys and .env secrets out of your repo
💰 Affiliate disclosure: We may earn a commission if you sign up through these links at no extra cost to you.
Stay updated on Data & Analytics tools — join our weekly newsletter
One concise email with fresh launches, trending picks, and featured standouts.
Alternatives to CH-UI
View all CH-UI alternatives →More Data & Analytics tools
Verify Email
Email verification API with disposable, relay and catch-all detection, plus an MCP server
TrafficClaw
AI copilot for Google Analytics and Search Console—plain-English answers, insights, and SEO actions.
Earnings Feed
Real-time SEC filing feed with insider-cluster and restatement signals, watchlists and an API on every tier
Channel3
API for agentic commerce — 100M+ products with real-time pricing that AI agents can search and buy from
Chart Library
Auditable historical-analog API and MCP server giving trading agents base rates, not forecasts
Chartcastr
Cross-tool AI analyst that watches your SaaS stack and posts the story to Slack on a schedule
Agent connectivity: not yet verified