ClickLens

About

ClickLens is a single-binary web application for analyzing ClickHouse query performance. It connects to any ClickHouse instance and provides a rich debugging interface with flame graphs, thread breakdowns, query fingerprints, cluster ops monitoring (replication, DDL queue, mutations, merges), and a table optimizer that generates copy-ready DDL statements. Built because the built-in tools weren't enough for real-world query debugging.

Key Features

• Query analysis with time-series charts and thread breakdowns
• Flame graphs and interactive EXPLAIN from trace_log (CPU, Memory, Real)
• Query fingerprints with P50/P95 latency trends, plus side-by-side query comparison
• Cluster ops monitoring: replication, distributed DDL queue, mutations, and merges
• SQL editor with schema browser, parameterized and saved queries
• Table optimizer with copy-ready ALTER TABLE recommendations
• Users, roles, and grants management with permission-gated actions

Single Binary, Zero Config

The entire application — Go backend and React frontend — compiles into a single static binary. No database, no config files, no external dependencies. Connection parameters are sent per-request from the browser, keeping the backend completely stateless. Run it with Docker or download the binary directly.

Quick Start