Pricing
CH-UI’s core is open source (Apache-2.0) and free to self-host: one binary, SQLite state, your infrastructure. A flat Pro license ($1,199/year per instance) unlocks all BSL Pro features: Governance, Cluster Health, Query Insights, Cost Center, the operations workflows (performance regressions and investigations, fleet overview, schema comparison, incident timeline, weekly reports), scheduled query jobs, Alerts, telemetry traces, metrics, service map and monitors, pipeline sampling, redaction and routing, Ask AI and Brain agentic tools, GitHub sync, audit forwarding, and SSO/OIDC. It is activated offline with a key, no call-home, with priority support included.
Open Source
Free Apache-2.0, forever
The core, on your own box. One binary, state in a local SQLite file, no external services. Unlimited users.
- SQL editor with query history, query parameters, result sort & filter, jump-to-error
- Saved queries, dashboards with shareable public links
- Pipelines & dbt-style models, with cron schedules for models and pipelines
- Ingest: OTLP logs and traces, JSON events, Elasticsearch bulk, Splunk HEC
- Pipeline transforms: parse, map fields, filter, with live preview
- Brain AI chat (bring your own key); Ask AI and agentic tools are Pro
- MCP server for Claude, ChatGPT, Cursor and VS Code
- OpenTelemetry logs: search, facets, live tail
- Admin panel: users, roles, multiple connections
- Tunnel connector, no inbound ports
Pro
$1,199 per instance, per year
Every Pro feature on your own hardware. Flat, never per seat. The license arrives by email and activates offline, with no call-home.
- Everything in Open Source
- Governance: catalog, guardrails, incidents, audit
- Cluster Health: per-node replication, merges, parts, Keeper, backups
- Query Insights: query_log analytics (latency, slow queries, failures, hot tables)
- Cost Center: showback and chargeback by team
- Performance: regression scans and before/after investigations
- Fleet overview, incident timeline and weekly reports
- Schema comparison across environments
- Telemetry: traces, metrics, service map, monitors
- Pipeline sampling, redaction and routing to up to 8 tables
- Scheduled query jobs and parameterized saved-query runs
- Alerts: channels, rules & delivery
- Ask AI (text-to-SQL) and Brain agentic tools
- GitHub sync for models
- SSO / OIDC with per-person roles
- Audit forwarding to your SIEM (webhook, file, stdout)
- MCP Pro tools and command palette Pro search
- Priority support
Try Pro free for 30 days
No card, no sales call. A trial license lands in your inbox and unlocks everything.
Enterprise
Multiple instances, volume pricing, invoice billing, security review, custom terms.
Lost your license, or need to change billing? Self-serve at /license.
The Pro license
Section titled “The Pro license”The license is flat per instance: your whole team and all your ClickHouse users are covered, no seats. Activation is a signed file you upload on the Instance page; verification is local, so air-gapped deployments work. See Plans & Licensing for details.
To buy: go to /pricing and click Buy Pro license. Checkout is handled by Stripe (annual subscription), and your license.json arrives by email right after payment. Not sure yet? Start a free 30-day trial. It’s fully self-serve: enter your email and a trial license lands in your inbox instantly. Full Pro, no card and no sales contact needed.
Existing customers: re-send your license or manage your subscription self-serve: enter your purchase email and we’ll email you your license or a Stripe billing-portal link.
AI (Brain)
Section titled “AI (Brain)”CH-UI Brain is an AI copilot that understands your schema and writes ClickHouse-idiomatic SQL. Bring your own key: plug in your own Anthropic / OpenAI / OpenAI-compatible / Ollama provider on any tier. Your key, your cost, unmetered. Brain chat, skills and artifacts are in the free core; Ask AI (text-to-SQL in the editor) and the agentic tools (tool-calling) are Pro.
AI clients (MCP)
Section titled “AI clients (MCP)”The MCP server that lets Claude, ChatGPT, Cursor and other AI clients query your ClickHouse through CH-UI is part of the free core, with OAuth sign-in, scoped keys, write and lifecycle action permissions, and the full audit trail. Pro adds tools on top: alerts, schedules, reports, cluster health, Query Insights and Cost Center, telemetry traces and metrics, and running scheduled jobs and reports now.
Do you charge per user? No. The Pro license is flat per instance. Workspace access uses your ClickHouse’s own users, so neither your team nor your end-users are billed as seats.
What does the Pro license include? Governance with alerts, Cluster Health, Query Insights, Cost Center, performance regressions and investigations with the fleet overview, schema comparison, the incident timeline, weekly operations reports, scheduled query jobs with the parameterized saved-query Run API, telemetry traces, metrics, service map and monitors, pipeline sampling, redaction and routing, Ask AI and Brain agentic tools, GitHub sync, SSO/OIDC, audit forwarding to your SIEM, the MCP Pro tools, and command palette Pro search, plus priority support. Everything else is free in the open-source core, including query parameters in the editor, model schedules, ingest, the parse, map and filter transforms, sink table layouts, and multiple connections. See the full table in Plans & Licensing.
Does the license phone home? No, it’s a signed file verified locally against a key embedded in the binary. Air-gapped environments work.
Is there a free trial of Pro? Yes, start a free 30-day trial self-serve: your trial license is emailed to you instantly, no card and no sales contact needed. Activate it on your instance’s Instance page, License section. And the open-source core is free forever, so you can evaluate everything outside the Pro modules indefinitely.
How do I cancel or update billing? The license is an annual subscription via Stripe. Use Manage subscription to get a billing-portal link by email. Cancel anytime and Pro keeps working until the end of the paid year.
Questions or Enterprise needs: me@caioricciuti.com.
