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 update`), OS service install (`ch-ui service install`)
Pro edition adds dashboards, scheduled jobs, AI assistant (BYO provider), governance (lineage, access matrix, policies), and alerting.
Core is Apache 2.0. Pro uses a signed license model (Ed25519).
Stack: Go 1.24, Svelte 5, SQLite (embedded state), Chi router, WebSocket tunnels.
GitHub: https://github.com/caioricciuti/ch-ui Install: `curl -fsSL https://ch-ui.com/install.sh | sh`
Happy to answer questions about the architecture, the tunnel model, or the open-core licensing approach.