Clickhouse's hidden built-in dashboards | bx2@blog

Clickhouse ships with several built-in web tools that most people don&rsquo;t know about. No installation, no setup - just hit the right endpoint on port 8123.<br>#Accessing the dashboards<br>If your Clickhouse server isn&rsquo;t directly accessible, create an SSH tunnel:<br>ssh -L 8123:127.0.0.1:8123 your-clickhouse-server

Now localhost:8123 points to your server.<br>#The dashboards<br>#/dashboard - Operations overview<br>http://localhost:8123/dashboard<br>Real-time insight into server internals. Shows queries, memory usage, merges, replication lag - basically a live view of system.* tables in a nice UI. This is your first stop when something feels slow.<br>#/merges - Merge history<br>http://localhost:8123/merges<br>Visualizes the history of merge processes. Useful when you&rsquo;re debugging high part counts or wondering why your table isn&rsquo;t consolidating. Shows merge duration, parts involved, and throughput.<br>#/play - SQL playground<br>http://localhost:8123/play<br>Run queries directly in the browser without needing a SQL client. Syntax highlighting, query history, result formatting. Handy for quick checks when you don&rsquo;t want to fire up DataGrip or the CLI.<br>#Other endpoints<br>/binary - Visualizes the Clickhouse binary structure. More of a curiosity than a tool.<br>/replicas_status - Simple HTTP health check. Returns OK if replicas are healthy. Good for load balancer health checks.<br>#Why this matters<br>When you&rsquo;re SSHed into a server at 2 AM debugging a production issue, having a built-in dashboard beats writing ad-hoc queries against system tables. Bookmark these.

References<br>https://clickhouse.com/docs/interfaces/h [...]