HN Showcase
Back to browse
CH-UI v2 – ClickHouse workspace in a single binary (Go and Svelte)

CH-UI v2 – ClickHouse workspace in a single binary (Go and Svelte)

by caioricciuti·Feb 20, 2026·9 points·0 comments
Visit ProjectView on HN

AI Analysis

●●●BangerShip ItSlick

Single binary with zero runtime dependencies beats Docker-based competitors; tunnel architecture solves remote CH access elegantly.

Strengths
  • •Complete v2 rewrite from React SPA to embedded binary is a UX leap: download, run, no Docker/Node—real developer ergonomics
  • •WebSocket tunnel + Ed25519-signed Pro license model shows product maturity and thoughtful licensing (OSS core, paid governance)
  • •Tunnel architecture (ch-ui connect on remote host, secure outbound-only WSS) solves a genuine ops friction point vs VPN or exposed ClickHouse
Weaknesses
  • •ClickHouse workspace category already has competitors (DataGrip, QueryPie, dedicated CH UIs); Pro features (dashboards, lineage) are table stakes in this space
  • •'AI copilot' and 'governance' are buzzwords without evidence of novel implementation or superiority over established tools
Target Audience

ClickHouse operators, analytics engineers, and data teams needing local workspace + remote ClickHouse governance

Similar To

DataGrip · QueryPie · DBeaver

Post Description

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 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.

Similar Projects