Data is better when we see it!

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

Read DocumentationView on GitHub
CH-UI Logo

Quick bootstrap

# Install CH-UI (Linux / macOS)
curl -fsSL https://ch-ui.com/install.sh | sh

# Start CH-UI (server mode by default)
ch-ui

# Check status
ch-ui server status

# Optional: connect remote ClickHouse host
ch-ui connect --url wss://your-ch-ui-domain/connect --key cht_your_token

# Docker quick start (official image)
docker run --rm -p 3488:3488 -v ch-ui-data:/app/data -e CLICKHOUSE_URL=http://host.docker.internal:8123 ghcr.io/caioricciuti/ch-ui:latest

# If login fails:
# https://ch-ui.com/docs/cant-login

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

Pro

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

Governance

Pro

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

Alerts

Pro

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

Tunnel Connector

Secure remote ClickHouse access through outbound WebSocket connectors.

Admin Controls

Pro

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

Production CLI

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

Dual License Model

Core remains Apache-2.0 and free. Pro modules unlock governance, Brain, alerts, and admin features.

What CH-UI includes

Product areas built for ClickHouse operators and analytics teams.

SQL Workspace

SQL Workspace

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

Dashboards

Dashboards

Pro

Build panels from saved queries, arrange layouts, and share system overviews across your team.

Brain Copilot

Brain Copilot

Pro

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

Governance Suite

Governance Suite

Pro

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

Schedules

Schedules

Pro

Schedule SQL queries with cron expressions, track execution history, and monitor results.

Admin Operations

Admin Operations

Pro

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
HTTPS

CH-UI Server

  • :3488 API + UI
  • Tunnel gateway
  • Scheduler + syncers
WSS

Connector Host

  • ch-ui connect
  • Outbound only

SQLite

  • Sessions, queries
  • Governance, chats, audit

ClickHouse

  • Your data
  • HTTP :8123

Try Pro free for 3 months

Enter your email to redeem a complimentary 3-month Pro license.

Get started

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

Open DocsProduction Deployment