duyet/clickhouse-monitoring

Open-source operational advisor for ClickHouse — real-time monitoring plus AI-driven index/partition/materialized-view recommendations.

290

stars

3,866

commits

TypeScript

primary language

Sep 9, 2026

updated

chmonitor.dev
ai-agent
chmonitor
clickhouse
cloudflare-workers
database-monitoring
duyet
mcp
monitoring
observability
open-source
self-hosted
tanstack-start

README

chmonitor

chmonitor

The operational advisor for ClickHouse

Build and Test GitHub stars Latest release Docker image License

Live demo · Website · Docs · Getting started · Quick start

Watch the chmonitor v0.3 launch film

Watch the v0.3 launch film · 36 seconds · MP4

chmonitor is a dashboard and advisor for ClickHouse. It reads system.* tables and shows what the cluster is doing — queries, merges, replication, storage, health — then recommends what to change next.

It does not apply DDL for you. Recommendations stay recommendations.

Runs the same way on Docker, Kubernetes, bare metal, or ClickHouse Cloud. Self-host it free (GPL-3.0), or use the hosted demo.

Current release: v0.3.0. Upgrading from v0.2? See Migrate to v0.3.


What it does

You needchmonitor
See the clusterOverview, topology, health checks, 30+ charts
Catch expensive workRunning, slow, failed, and historical queries
Understand dataExplorer, table size, parts, compression, TTLs
Keep replicas healthyMerges, mutations, replication queue, Keeper
Get a second opinionAI advisor: projections, skip indexes, PREWHERE, MVs
Ask in EnglishBuilt-in AI agent + MCP for Claude / Cursor
Work from a terminalchm CLI — live TUI and chm doctor

Works with multiple ClickHouse hosts from one dashboard (?host=0).

More detail: docs · AI agent · editions


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/chmonitor/chmonitor:v0.3.0

Open http://localhost:3000. Pin a version tag in production; use :latest only if you want the rolling tip.

Want a look first? dash.chmonitor.dev — no setup.

Install the CLI:

curl -sSf https://chmonitor.dev/install.sh | bash
chm doctor

Deploy

Same CLICKHOUSE_HOST / CLICKHOUSE_USER / CLICKHOUSE_PASSWORD everywhere.

TargetGuide
Dockerdocs/operate/deploy/docker
Kubernetes (Helm)docs/operate/deploy/k8s
Cloudflare Workersdocs/operate/deploy
Railway / Render / FlyOne-click
Local developmentGetting started

Release artifacts (Docker image, Node standalone, Workers archive) are on the GitHub Releases page.


Editions

One codebase. Community is free forever (GPL-3.0). An optional license unlocks enterprise gates — same binary.

CommunityEnterprise
CostFree, GPL-3.0Priced by host count
Where it runsYour infraSame
ClickHouse hostsUnlimitedPersonal · Team 3 · Unlimited
AI advisor, agent, MCPIncludedSame, plus enterprise gates

Details: Editions.


Screenshots

Overview charts: query count, duration, and data written over time Cluster topology: nodes, shards, replicas, and Keeper quorum Cluster insights: findings, record-breaking queries, storage stats AI agent: ask about schema, storage, queries, and health SQL console: read-only SQL with history and EXPLAIN

Docs


Contribute

Issues and pull requests are welcome. Agent instructions live in AGENTS.md (CLAUDE.md includes that file).

License

GPL-3.0


Repo activity

Contributors

duyet

3,160 commits

renovate[bot]

307 commits

claude

218 commits

duyetbot

104 commits

duyet/clickhouse-monitoring

Open-source operational advisor for ClickHouse — real-time monitoring plus AI-driven index/partition/materialized-view recommendations.

290

stars

3,866

commits

TypeScript

primary language

Sep 9, 2026

updated

chmonitor.dev
ai-agent
chmonitor
clickhouse
cloudflare-workers
database-monitoring
duyet
mcp
monitoring
observability
open-source
self-hosted
tanstack-start

README

chmonitor

chmonitor

The operational advisor for ClickHouse

Build and Test GitHub stars Latest release Docker image License

Live demo · Website · Docs · Getting started · Quick start

Watch the chmonitor v0.3 launch film

Watch the v0.3 launch film · 36 seconds · MP4

chmonitor is a dashboard and advisor for ClickHouse. It reads system.* tables and shows what the cluster is doing — queries, merges, replication, storage, health — then recommends what to change next.

It does not apply DDL for you. Recommendations stay recommendations.

Runs the same way on Docker, Kubernetes, bare metal, or ClickHouse Cloud. Self-host it free (GPL-3.0), or use the hosted demo.

Current release: v0.3.0. Upgrading from v0.2? See Migrate to v0.3.


What it does

You needchmonitor
See the clusterOverview, topology, health checks, 30+ charts
Catch expensive workRunning, slow, failed, and historical queries
Understand dataExplorer, table size, parts, compression, TTLs
Keep replicas healthyMerges, mutations, replication queue, Keeper
Get a second opinionAI advisor: projections, skip indexes, PREWHERE, MVs
Ask in EnglishBuilt-in AI agent + MCP for Claude / Cursor
Work from a terminalchm CLI — live TUI and chm doctor

Works with multiple ClickHouse hosts from one dashboard (?host=0).

More detail: docs · AI agent · editions


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/chmonitor/chmonitor:v0.3.0

Open http://localhost:3000. Pin a version tag in production; use :latest only if you want the rolling tip.

Want a look first? dash.chmonitor.dev — no setup.

Install the CLI:

curl -sSf https://chmonitor.dev/install.sh | bash
chm doctor

Deploy

Same CLICKHOUSE_HOST / CLICKHOUSE_USER / CLICKHOUSE_PASSWORD everywhere.

TargetGuide
Dockerdocs/operate/deploy/docker
Kubernetes (Helm)docs/operate/deploy/k8s
Cloudflare Workersdocs/operate/deploy
Railway / Render / FlyOne-click
Local developmentGetting started

Release artifacts (Docker image, Node standalone, Workers archive) are on the GitHub Releases page.


Editions

One codebase. Community is free forever (GPL-3.0). An optional license unlocks enterprise gates — same binary.

CommunityEnterprise
CostFree, GPL-3.0Priced by host count
Where it runsYour infraSame
ClickHouse hostsUnlimitedPersonal · Team 3 · Unlimited
AI advisor, agent, MCPIncludedSame, plus enterprise gates

Details: Editions.


Screenshots

Overview charts: query count, duration, and data written over time Cluster topology: nodes, shards, replicas, and Keeper quorum Cluster insights: findings, record-breaking queries, storage stats AI agent: ask about schema, storage, queries, and health SQL console: read-only SQL with history and EXPLAIN

Docs


Contribute

Issues and pull requests are welcome. Agent instructions live in AGENTS.md (CLAUDE.md includes that file).

License

GPL-3.0


Repo activity

Contributors

duyet

3,160 commits

renovate[bot]

307 commits

claude

218 commits

duyetbot

104 commits

Languages

TypeScript

78.6%

HTML

8.8%

JavaScript

7.5%

Rust

2.0%

Astro

1.9%