ch-ui.com is built with Astro, hosted on Cloudflare. It measures traffic with Cloudflare Web Analytics and Umami.
| Technology | Version | First seen |
|---|---|---|
| JavaScript Frameworks & Libraries1 | ||
| – | 7 Nov 2026 | |
| CDN & Hosting1 | ||
| – | 7 Nov 2026 | |
| Analytics & Tag Management2 | ||
| – | 7 Nov 2026 | |
| Fonts & Icon Fonts1 | ||
| – | 7 Nov 2026 | |
Registration from the registry's RDAP record, the certificate the site serves, and its rank in public traffic lists.
The crew hasn’t read this site’s colors yet. We read a palette when we capture a site’s screenshot, busiest sites first. Meanwhile, browse palettes from other sites.
mail.caioricciuti.comsid.ns.cloudflare.comharleigh.ns.cloudflare.comssl.comsectigo.comcomodoca.comcomodoca.comssl.commailto:me@caioricciuti.comdigicert.com; cansignhttpexchanges=yespki.goog; cansignhttpexchanges=yesgoogle-site-verification=AhgbS2oxPQh05jqHymOBDC-Xr8HwXLfUGbW6m2WdcBAv=spf1 mx ~allv=DMARC1; p=quarantine; rua=mailto:dmarc@ch-ui.com; adkim=r; aspf=r# CH-UI: https://ch-ui.com # All crawlers welcome, AI crawlers included. User-agent: * Allow: / User-agent: GPTBot Allow: / User-agent: ClaudeBot Allow: / User-agent: PerplexityBot Allow: / Sitemap: https://ch-ui.com/sitemap-index.xml
# CH-UI > CH-UI is the open-source control plane for ClickHouse: SQL editor, dashboards, pipelines, ingest of logs, traces and events, query analytics, cluster monitoring, governance, and an AI copilot, self-hosted as a single binary. The core is Apache-2.0; Pro features unlock with a flat $1,199/year per-instance license activated offline. ## Start here - [Introduction](https://ch-ui.com/docs/): CH-UI: the ClickHouse control plane for teams. SQL, dashboards, governance, and an AI copilot in one workspace. - [Installation](https://ch-ui.com/docs/installation/): Install and run CH-UI on your own infrastructure - [Deployment](https://ch-ui.com/docs/deployment/): Production deployment for CH-UI: server, connectors, TLS, and hardening - [Configuration](https://ch-ui.com/docs/configuration/): Server and connector configuration for CH-UI - [Upgrade](https://ch-ui.com/docs/upgrade/): How to update CH-UI to the latest version ## Guides - [Run your first query](https://ch-ui.com/docs/guides/first-query/): Sign in, pick a connection, find a table in the explorer, run SQL and save the query for later - [Build your first dashboard](https://ch-ui.com/docs/guides/first-dashboard/): Create a dashboard, add a panel from a saved query, arrange the layout and share a link - [Ship logs](https://ch-ui.com/docs/guides/ship-logs/): Send OpenTelemetry logs straight to CH-UI in one step, then search them in Telemetry - [Invite a teammate](https://ch-ui.com/docs/guides/invite-teammate/): Give someone access to CH-UI with a ClickHouse user or SSO, and set their role - [Connect Claude Code](https://ch-ui.com/docs/guides/connect-claude-code/): Add CH-UI as an MCP server in Claude Code and sign in as yourself, so Claude can browse your schema and run read-only queries ## Workspace - [Direct vs Tunnel Connections](https://ch-ui.com/docs/connections/): The two ways CH-UI reaches ClickHouse, when to use each, and how to set them up - [Connections & Tunnel](https://ch-ui.com/docs/ingestion/): Connect remote ClickHouse instances to CH-UI - [SQL Workspace](https://ch-ui.com/docs/querying/): Multi-tab SQL editor with streaming results, result filtering & sorting, automatic query history, error navigation, data upload, and saved queries - [Data Lineage](https://ch-ui.com/docs/lineage/): See which tables feed which materialized views, views and dictionaries, and where they write, read from ClickHouse system tables with your own account. - [Dashboards](https://ch-ui.com/docs/dashboards/): Build and share ClickHouse dashboards with SQL-powered panels - [Models (SQL Transformations)](https://ch-ui.com/docs/models/): SQL models that build ClickHouse views, tables, incremental tables and materialized views, reference each other with $ref(), carry data tests, and run in dependency order by hand or in named, scheduled model groups - [Pipelines](https://ch-ui.com/docs/pipelines/): Visual data pipeline builder for ingesting data into ClickHouse - [Ingest](https://ch-ui.com/docs/ingest/): Send OpenTelemetry logs and traces, JSON events, Elasticsearch bulk requests or Splunk HEC events straight to CH-UI. It spools them on disk and writes them to ClickHouse - [Schedules](https://ch-ui.com/docs/schedules/): Cron-based scheduled query execution with auto-alerts - [Scheduled Reports](https://ch-ui.com/docs/reports/): Send a saved query result or a dashboard summary on a cron to email, Slack, Teams or a webhook, through your existing alert channels. - [GitHub Sync](https://ch-ui.com/docs/github/): Keep CH-UI models in sync with a GitHub repository, with Git as the source of truth for your SQL models ## AI - [Brain (AI Assistant)](https://ch-ui.com/docs/brain/): Schema-aware AI copilot for ClickHouse: bring your own model (Anthropic, OpenAI or local), with custom skills, approvals, usage tracking and query result artifacts. - [MCP Server](https://ch-ui.com/docs/mcp/): Connect Claude, ChatGPT, Cursor, VS Code and other AI clients to your ClickHouse through CH-UI's embedded Model Context Protocol server, with OAuth sign-in, scoped keys, server-side guardrails and a full audit trail ## Operate - [Telemetry](https://ch-ui.com/docs/telemetry/): Search OpenTelemetry logs, traces and metrics stored in ClickHouse, with a service map and monitors that raise alerts. Nothing copied, every screen is SQL against your tables - [Cluster Health](https://ch-ui.com/docs/cluster-health/): Operations & database monitoring for ClickHouse: replication, Keeper, merges, mutations, parts pressure, and long queries fanned out across every node - [Query Insights](https://ch-ui.com/docs/query-insights/): Visual analytics over system.query_log: latency percentiles, slow and memory-heavy query patterns, failures, users, and hot tables, with dashboard-wide cross-filtering - [Cost Center](https://ch-ui.com/docs/cost-center/): Showback and chargeback for ClickHouse: compute and storage spend per team, user, query pattern, and table, priced from system.query_log and system.parts with your own unit rates - [Performance](https://ch-ui.com/docs/performance/): Find query regressions in system.query_log, save an investigation with a baseline, and prove whether a change helped. Includes the Fleet overview. - [Incident Timeline](https://ch-ui.com/docs/incident-timeline/): One chronological view of query failures, latency, merges and mutations, cluster pressure, governance incidents and deployment annotations for a time window. - [Operations Reports](https://ch-ui.com/docs/operations-reports/): Weekly operations reports with regressions, failures, CPU-heavy workloads, storage and resolved investigations, saved in CH-UI and optionally emailed. - [Schema Compare](https://ch-ui.com/docs/schema-compare/): Compare table and column metadata between two ClickHouse connections or databases and download a commented SQL review plan. - [ClickHouse Clusters & Load Balancers](https://ch-ui.com/docs/clusters/): Sticky routing with X-CH-UI-Session for multi-node ClickHouse deployments behind chproxy, HAProxy, or Kubernetes - [Monitoring & SIEM](https://ch-ui.com/docs/monitoring/): Health checks, Prometheus metrics, and forwarding CH-UI audit events to your SIEM ## Govern and secure - [Governance](https://ch-ui.com/docs/governance/): Metadata harvesting, access matrix, query audit, policies, incidents, alerts, and audit log - [Access Control Editor](https://ch-ui.com/docs/rbac/): Edit ClickHouse roles, grants, row policies, quotas and settings profiles with a reviewed, audited change set - [Alerts](https://ch-ui.com/docs/alerts/): Alerting for governance, scheduled jobs, cluster health checks and SQL threshold alerts: SMTP and webhook (generic JSON, Slack, Teams) channels, rules with severity thresholds and cooldowns, delivery retries, and an event history - [Audit Log](https://ch-ui.com/docs/audit-log/): The CH-UI audit log: who did what, when, across sign-ins, connections, roles, and license events. - [Authentication & Roles](https://ch-ui.com/docs/authentication/): Login model, session cookies, and admin authorization - [Single Sign-On (SSO)](https://ch-ui.com/docs/sso/): OpenID Connect SSO for CH-UI: Okta, Microsoft Entra ID, Google Workspace, Keycloak, Auth0 - [Background Accounts](https://ch-ui.com/docs/background-accounts/): Choose which ClickHouse account each unattended job uses, per connection - [Security](https://ch-ui.com/docs/security/): CH-UI security posture: TLS, authentication, RBAC, audit, encryption, and vulnerability disclosure - [Admin Guide](https://ch-ui.com/docs/admin/): Users, ClickHouse user management, Brain providers, and operational controls ## Reference - [CLI Reference](https://ch-ui.com/docs/cli/): Complete command reference for the CH-UI binary - [API Reference](https://ch-ui.com/docs/api/): CH-UI REST API reference - [Compatibility & Support Matrix](https://ch-ui.com/docs/compatibility/): Supported ClickHouse versions, browsers, platforms, and sizing guidance for CH-UI - [Can't Login?](https://ch-ui.com/docs/cant-login/): Fast recovery steps when CH-UI sign-in fails - [Troubleshooting](https://ch-ui.com/docs/troubleshooting/): Common issues and how to resolve them - [Development](https://ch-ui.com/docs/development/): Build CH-UI from source - [Changelog](https://ch-ui.com/docs/changelog/): Every CH-UI release: what changed, what was fixed, and what to check before upgrading. ## Plans - [Pricing](https://ch-ui.com/docs/pricing/): Self-host CH-UI free (Apache-2.0) or unlock Pro with a flat $1,199/year license. Governance, Cluster Health, Query Insights, Cost Center, performance investigations, scheduled queries, Alerts, telemetry traces and metrics, Ask AI, GitHub sync, SSO. - [Plans & Licensing](https://ch-ui.com/docs/license/): How CH-UI is licensed: open-source core (Apache-2.0) and the Pro License for self-hosted deployments.
| – |
| 7 Nov 2026 |