CH-UI v2.0.0

The ClickHouse control plane for teams.

Querying, governance, AI copilot, scheduling, and operations in one self-hosted binary.

Read DocumentationView on GitHub

Quick bootstrap

# Start CH-UI server
./ch-ui server --port 3488

# Check status
./ch-ui server status

# Optional: connect remote ClickHouse host
./ch-ui connect --url wss://cloud.ch-ui.com/connect --key cht_your_token

Built for real operations

CH-UI combines data workbench and platform controls so teams can ship and govern from one place.

SQL Workspace

Multi-tab editor, explorer, completions, saved queries, and schema actions.

Brain Copilot

Provider-managed AI chat with artifacts, SQL generation, and chat persistence.

Governance

Access matrix, incidents, policies, lineage, and sync-backed metadata cache.

Alerts

SMTP/Resend/Brevo channels, rules, routing, escalation, and event logs.

Tunnel Connector

Secure remote ClickHouse access through outbound WebSocket connectors.

Admin Controls

Role overrides, ClickHouse user lifecycle, provider settings, and audit logs.

Production CLI

Server lifecycle commands with PID-safe start/stop/status/restart behavior.

License-Gated Pro

Core remains Apache-2.0 while Pro modules unlock governance, Brain, and alerts.

What CH-UI v2.0.0 includes

Product areas built for ClickHouse operators and analytics teams.

SQL Workspace

Multi-tab query editing, schema explorer, completions, and safe schema operations via sheets.

Governance Suite

Dashboard metrics, access matrix, incidents, policies, lineage, and sync controls.

Brain Copilot

Multi-chat AI with persisted context, SQL artifacts, provider/model controls, and run-in-chat actions.

Admin Operations

ClickHouse user lifecycle, provider management, alert channels/rules, and audit views.

Deployment architecture

Run CH-UI centrally, connect one or many ClickHouse environments.

Browser

  • SQL workspace
  • Governance
  • Brain UI

CH-UI Server

  • :3488 API + UI
  • Tunnel gateway (/connect)
  • Scheduler + syncers

Connector Host

  • ch-ui connect
  • ClickHouse HTTP :8123
  • Outbound only

State Store

Embedded SQLite stores sessions, saved queries, governance cache, Brain chats/artifacts, alerts, and audit logs.

Topology

Run CH-UI on VM2 and one or more connectors on ClickHouse hosts (VM1..N) for secure remote operations.

Start with v2.0.0

Installation, deployment, API, and operator runbooks are all in the docs.

Open DocsProduction Deployment