CH-UI - Data is better when we see it! – Self-hosted ClickHouse workspace with SQL, AI copilot & ops

Summary: CH-UI is a self-hosted ClickHouse workspace delivered as a single binary, integrating a multi-tab SQL editor, schema explorer, AI copilot, governance, query scheduling, alerting, and admin controls. It supports deployment via curl or Docker and connects to any ClickHouse instance over HTTP or secure WebSocket tunnels. The core is free and open source under Apache-2.0, with optional pro modules for enhanced governance and alert routing.

What it does

CH-UI provides a unified interface for querying, managing, and governing ClickHouse data, combining SQL editing, AI assistance, scheduling, and administrative features in one tool.

Who it's for

It is designed for data engineers and developers who need an integrated workspace to query and manage ClickHouse databases.

Why it matters

It reduces the need to switch between multiple tools by consolidating ClickHouse operations into a single self-hosted application.