clickhouse-monitor

chmonitor Dashboard

A modern dashboard (TanStack Start, as of v0.3) that provides real-time insights into ClickHouse clusters through system tables. Every page is pre-rendered at build time with client-side data fetching for optimal performance and CDN caching.

Upgrading from v0.2? v0.3 rebuilds the app on TanStack Start. ClickHouse connection vars are unchanged; browser vars move from NEXT_PUBLIC_* to VITE_* (old names still work as a fallback). See Upgrading to v0.3 below or the full Migrate to v0.3 guide.

Live: dash.chmonitor.dev | chmonitor.dev | Screenshots

Features:

• Query Monitoring: Running queries, query history, resources (memory, parts read, file_open), expensive queries, slow queries, failed queries, query profiler
• Cluster Overview: Memory/CPU usage, distributed queue, global settings, MergeTree settings, metrics, asynchronous metrics
• Data Explorer: Interactive database tree browser with fast tab switching and column-level details, projections, dictionaries
• Table Analytics: Size, row count, compression, part sizes with column-level granularity, detached parts, readonly tables, view refreshes
• Visualization: 30+ metric charts for queries, resources, merges, performance, and system health
• Merge & Replication: Merge operations, merge performance, replication queue, replicas
• Security & Access: Users, roles, security settings
• Developer Tools: Zookeeper explorer, query EXPLAIN, query kill, distributed DDL queue, mutations
• Multi-Host Support: Monitor multiple ClickHouse instances from a single dashboard
• AI Agent: Built-in AI chat for natural language queries against your ClickHouse cluster
• MCP Server: Model Context Protocol endpoint for AI tool integration (Claude, Cursor, etc.)
• Rust CLI: Standalone terminal and TUI monitoring tool

Quick start

One container, pointed at any reachable ClickHouse (OSS, Altinity, or ClickHouse Cloud):

docker run -d --name chmonitor -p 3000:3000 \
  -e CLICKHOUSE_HOST=https://clickhouse.example.com:8443 \
  -e CLICKHOUSE_USER=default \
  -e CLICKHOUSE_PASSWORD=change-me \
  ghcr.io/duyet/chmonitor:latest

Open http://localhost:3000. Pin a release tag instead of latest for production.

Just want to look first? The live demo is at dash.chmonitor.dev — no setup required. Other targets (Cloudflare Workers, one-click Railway/Render/Fly, Kubernetes) are under Deployment.

Deployment

chmonitor is self-hosted — run it next to your ClickHouse with the same CLICKHOUSE_* connection vars on any of these targets:

• Docker — one docker run; the fastest path to a live dashboard.
• Cloudflare Workers — global edge deploy (how the demo at dash.chmonitor.dev runs).
• One-click templates — Railway, Render, Fly.io.
• Kubernetes (Helm) — for clusters.

Prefer to look before you install? Try the live demo above — no setup required.

Cloudflare Workers

This project supports deployment to Cloudflare Workers with static site generation and API routes.

Prerequisites:

• Node.js 18+ and Bun
• Cloudflare Workers account
• Wrangler CLI: npm install -g wrangler

Setup:

1. Clone and install dependencies:

git clone https://github.com/duyet/clickhouse-monitoring.git
cd clickhouse-monitoring
bun install

2. Configure environment variables in .env.local:

CLICKHOUSE_HOST=https://your-clickhouse-host.com
CLICKHOUSE_USER=default
CLICKHOUSE_PASSWORD=yourpassword
CLICKHOUSE_TZ=UTC

Optional API-key protection for /api/v1/* routes: