CH-UI - Data is better when we see it!
Self-hosted ClickHouse workspace with SQL, AI copilot & ops
What it does
CH-UI is a self-hosted ClickHouse workspace shipped as a single binary. It combines a multi-tab SQL editor, schema explorer, AI copilot (Brain), governance suite, query scheduling, alerting, and admin controls. Core is free and open source (Apache-2.0). Pro modules adds governance, alert routing and schedule queries for pipelines. Deploy with one curl command or Docker — connect to any ClickHouse instance over HTTP or via secure WebSocket tunnels.
Does a similar job
all alternatives →- CUCH-UI – A Modern Web Interface for ClickHouse Databases2025 · github.com · ▲6
CH-UI is an open-source web interface for managing and interacting with ClickHouse databases. Key features include an advanced SQL editor with IntelliSense, real-time data visualization, and comprehensive monitoring capabilities. Built with TypeScript and featuring IndexedDB-based caching, it's designed to handle large datasets efficiently. Available as a Docker image for quick deployment.
- CLClickHouse-local – a small tool for serverless data analytics2023 · clickhouse.com · ▲289
Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…
- CUCH-UI v2 – ClickHouse workspace in a single binary (Go and Svelte)Feb 2026 · ch-ui.com · ▲9
Hi HN, I've been building CH-UI, an open-source ClickHouse workspace. Today I'm releasing v2, which is a complete rewrite from scratch. v1 was a React SPA served via Docker. v2 is a single Go binary with an embedded Svelte frontend — download, run, open browser. No Docker, no Node, no runtime dependencies. What it does: - Multi-tab SQL editor with autocomplete - Database/table explorer with data preview - Saved queries - Tunnel architecture: run `ch-ui server` on one machine and `ch-ui connect` next to your ClickHouse — secure WebSocket tunnel, no VPN needed - Self-update (`ch-ui…
More dev tools this month
the category →
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 2d ago · opentrailpaper.com
Open-source GTM skills for technical founders
Dev tools · 30d ago · gtmcofounder.com
