CH-UI v2 – ClickHouse workspace in a single binary (Go and Svelte)
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…
What it does
In the maker’s words, at launch
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.
Does the same 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.
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
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
