ClickHouse Query Analyzer

About

ClickHouse Query Analyzer 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, 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 built from trace_log (CPU, Memory, Real)
• Query fingerprints with P50/P95 latency trends
• SQL editor with schema browser and parameterized queries
• Table optimizer with copy-ready ALTER TABLE recommendations
• Cluster-aware with automatic clusterAllReplicas support

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