clickhouse-monitor
Specialized assistance for the chmonitor dashboard - a real-time monitoring dashboard for ClickHouse clusters
Safety scan
A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.
Check it deeper on your machine
It has changed since its scan on 11 Nov 2026. Its scripts were only partly scanned.
As a Claude Code plugin, install it and then ask Claude Code:
/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/chmonitor/chmonitor with scanskillsafety
Or from a terminal, clone it and run it:
git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/chmonitor/chmonitor'
It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.
Badge for your README
Markdown
[](/listings/duyet--clickhouse-monitoring)HTML
<a href="/listings/duyet--clickhouse-monitoring"><img src="/api/listings/duyet--clickhouse-monitoring/badge.svg" alt="findsafeskills safety rating" /></a>Install
Install instructions from the README
As written by the repo's author. findsafeskills has not verified these steps.
These steps run a script from the network that findsafeskills does not scan.
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:0.3.9
Open **http://localhost:3000**. Pin a version tag in production; use `:latest` only if you want the rolling tip. Image tags carry no `v` prefix. The release `v0.3.9` publishes `0.3.9`, plus `0.3` and `latest`.
[release]: https://github.com/chmonitor/chmonitor/releases/tag/v0.3.9
Want a look first? **[dash.chmonitor.dev](https://dash.chmonitor.dev/overview?host=0)** — no setup.
Install the CLI:
curl -sSf https://chmonitor.dev/install.sh | bash chm doctor
---
What was scanned
The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.
.claude-plugin/plugin.json · Manifest · 20 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.
- {
- "name": "clickhouse-monitor",
- "version": "1.0.0",
- "description": "Specialized assistance for the chmonitor dashboard - a real-time monitoring dashboard for ClickHouse clusters",
- "author": "duyet",
- "license": "MIT",
- "keywords": [
- "clickhouse",
- "monitoring",
- "dashboard",
- "database",
- "observability"
- ],
- "homepage": "https://github.com/chmonitor/chmonitor",
- "repository": {
- "type": "git",
- "url": "https://github.com/chmonitor/chmonitor.git"
- },
- "skills": ["."]
- }
README.md · README · 210 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.
- <p align="center">
- <picture>
- <source media="(prefers-color-scheme: dark)" srcset=".github/logo.png">
- <img src=".github/logo.png" alt="chmonitor" width="120" height="120">
- </picture>
- </p>
- <h1 align="center">chmonitor</h1>
- <p align="center"><strong>The operational advisor for ClickHouse</strong></p>
- [](https://github.com/chmonitor/chmonitor/actions/workflows/ci.yml)
- [](https://github.com/chmonitor/chmonitor/stargazers)
- [](https://github.com/chmonitor/chmonitor/releases)
- [](https://github.com/chmonitor/chmonitor/pkgs/container/chmonitor)
- [](LICENSE)
- <p align="center">
- <a href="https://dash.chmonitor.dev/overview?host=0"><strong>Live demo</strong></a>
- · <a href="https://chmonitor.dev/">Website</a>
- · <a href="https://docs.chmonitor.dev">Docs</a>
- · <a href="https://docs.chmonitor.dev/guide/getting-started">Getting started</a>
- · <a href="#quick-start">Quick start</a>
- </p>
- <p align="center">
- <img alt="chmonitor v0.3 launch film" src=".github/videos/launch-v0-3.gif">
- </p>
- <p align="center">
- <a href="https://chmonitor.dev/watch/v0-3"><strong>Watch the v0.3 launch film</strong></a>
- </p>
- **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](https://dash.chmonitor.dev/overview?host=0).
- <!-- x-release-please-start-version -->
- Current release: **[v0.3.11][release]**.
- Upgrading from v0.2? See [Migrate to v0.3](https://docs.chmonitor.dev/reference/migrating/v0-3).
- ---
- ## What it does
- | You need | chmonitor |
- |---|---|
- | See the cluster | Overview, topology, health checks, 30+ charts |
- | Catch expensive work | Running, slow, failed, and historical queries |
- | Understand data | Explorer, table size, parts, compression, TTLs |
- | Keep replicas healthy | Merges, mutations, replication queue, Keeper |
- | Get a second opinion | AI advisor: projections, skip indexes, PREWHERE, MVs |
- | Ask in English | Built-in AI agent + [MCP](https://docs.chmonitor.dev/reference/mcp-clients) for Claude / Cursor |
- | Work from a terminal | [`chm` CLI](https://chmonitor.dev/cli) — live TUI and `chm doctor` |
- Works with **multiple ClickHouse hosts** from one dashboard (`?host=0`).
- More detail: [docs](https://docs.chmonitor.dev) · [AI agent](https://docs.chmonitor.dev/guide/ai-agent) · [editions](https://docs.chmonitor.dev/operate/advanced/editions)
- ---
- ## Quick start
- One container, pointed at any reachable ClickHouse (OSS, Altinity, or ClickHouse Cloud):
- ```bash
- 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:0.3.11
- ```
- Open **http://localhost:3000**. Pin a version tag in production; use `:latest` only if you want the rolling tip.
- Image tags carry no `v` prefix. The release `v0.3.11` publishes
- `0.3.11`, plus `0.3` and `latest`.
- [release]: https://github.com/chmonitor/chmonitor/releases/tag/v0.3.11
- <!-- x-release-please-end -->
- Want a look first? **[dash.chmonitor.dev](https://dash.chmonitor.dev/overview?host=0)** — no setup.
- Install the CLI:
- ```bash
- curl -sSf https://chmonitor.dev/install.sh | bash
- chm doctor
- ```
- ---
- ## Deploy
- Same `CLICKHOUSE_HOST` / `CLICKHOUSE_USER` / `CLICKHOUSE_PASSWORD` everywhere.
- | Target | Guide |
- |---|---|
- | Docker | [docs/operate/deploy/docker](https://docs.chmonitor.dev/operate/deploy/docker) |
- | Kubernetes (Helm) | [docs/operate/deploy/k8s](https://docs.chmonitor.dev/operate/deploy/k8s) |
- | Cloudflare Workers | [docs/operate/deploy](https://docs.chmonitor.dev/operate/deploy) |
- | Railway / Render / Fly | [One-click](https://docs.chmonitor.dev/operate/deploy/one-click) |
- | Local development | [Getting started](https://docs.chmonitor.dev/guide/getting-started/local) |
- Release artifacts (Docker image, Node standalone, Workers archive) are on the
- [GitHub Releases](https://github.com/chmonitor/chmonitor/releases) page.
- ---
- ## Editions
- chmonitor is **GPL-3.0**: self-host every feature, unlimited hosts, no payment, no
- key. A commercial license is optional and buys paper, not features — an invoice
- and named vendor, priority email support for the paid term, and an opt-in listing.
- Same binary either way.
- | License | Hosts | Yearly | Lifetime |
- |---|---|---|---|
- | Personal Self Hosted | Unlimited | Free | Free |
- | Team | 3 | $499 | $1,349 |
- | Unlimited | Unlimited | $999 | $2,999 |
- You do not get extra dashboard features versus the free build today. A **host**
- is one monitored connection; replicas in the same shard are not counted.
- Details: [Editions](https://docs.chmonitor.dev/operate/advanced/editions) ·
- [Commercial license](https://docs.chmonitor.dev/operate/advanced/commercial-license) ·
- [Buy](https://chmonitor.dev/license).
- ---
- ## Sponsors
- Self-hosting is free under GPL-3.0. Sponsorship is not a license — it buys no
- features, no support window, and no key. It funds the free build, and it earns a
- listing.
- | Tier | One-off | You get |
- |---|---|---|
- | Supporter | $19 | Your name on the sponsors page |
- | Backer | $59 | Your name and a link to your site on the sponsors page |
- | Hero | $99 | Your logo and link under the homepage hero, plus the sponsors page |
- | Partner | $199 | A larger hero slot, plus a short line about you on the sponsors page |
- Want to support the free build? **[Start sponsoring](https://chmonitor.dev/license#sponsor)** —
- from $19 one-off, or $99 to put your logo under the homepage hero.
- The wall: [chmonitor.dev/sponsors](https://chmonitor.dev/sponsors). A commercial
- license is a separate thing — see [Editions](#editions).
- ---
- ## Screenshots
- <picture>
- <source media="(prefers-color-scheme: dark)" srcset=".github/screenshots/overview-with-charts-dark-with-bg.jpeg">
- <img alt="Overview charts: query count, duration, and data written over time" src=".github/screenshots/overview-with-charts-dark-with-bg.jpeg">
- </picture>
- <picture>
- <source media="(prefers-color-scheme: dark)" srcset=".github/screenshots/cluster-topology-dark.png">
- <img alt="Cluster topology: nodes, shards, replicas, and Keeper quorum" src=".github/screenshots/cluster-topology-light.png">
- </picture>
- <picture>
- <source media="(prefers-color-scheme: dark)" srcset=".github/screenshots/cluster-insights-dark.png">
- <img alt="Cluster insights: findings, record-breaking queries, storage stats" src=".github/screenshots/cluster-insights-light.png">
- </picture>
- <picture>
- <source media="(prefers-color-scheme: dark)" srcset=".github/screenshots/ai-agent-dark.png">
- <img alt="AI agent: ask about schema, storage, queries, and health" src=".github/screenshots/ai-agent-light.png">
- </picture>
- <picture>
- <source media="(prefers-color-scheme: dark)" srcset=".github/screenshots/sql-console-dark.png">
- <img alt="SQL console: read-only SQL with history and EXPLAIN" src=".github/screenshots/sql-console-light.png">
- </picture>
- ---
- ## Docs
- - [Getting started](https://docs.chmonitor.dev/guide/getting-started) — ClickHouse user, system tables, first run
- - [Deploy](https://docs.chmonitor.dev/operate/deploy) — Docker, Kubernetes, Workers, one-click
- - [AI agent](https://docs.chmonitor.dev/guide/ai-agent) — tools, skills, env
- - [MCP clients](https://docs.chmonitor.dev/reference/mcp-clients) — Claude, Cursor, and other clients
- - [Editions](https://docs.chmonitor.dev/operate/advanced/editions) — what a license does and does not unlock
- - [Commercial license](https://docs.chmonitor.dev/operate/advanced/commercial-license) — SKUs, prices, `CHM_LICENSE_KEY`
- - [Sponsors](https://chmonitor.dev/sponsors) — the sponsor wall and the ladder
- - [Environment variables](https://docs.chmonitor.dev/reference/environment-variables)
- - [Connection errors](https://docs.chmonitor.dev/guide/guides/connection-errors)
- - [Migrate to v0.3](https://docs.chmonitor.dev/reference/migrating/v0-3)
- - Source in this repo: [`docs/content/`](docs/content/) · live site: [docs.chmonitor.dev](https://docs.chmonitor.dev)
- ---
- ## Contribute
- Issues and pull requests are welcome. Agent instructions live in [`AGENTS.md`](AGENTS.md)
- (`CLAUDE.md` includes that file).
- ## License
- [GPL-3.0](LICENSE)
- ---
- 
.agents/skills/media-use/scripts/lib/probe.mjs · Bundled script · 39 lines · 1 finding marked
- import { execFileSync } from "node:child_process";
- import { extname } from "node:path";
- const IMAGE_EXT = new Set([".jpg", ".jpeg", ".png", ".gif", ".webp", ".svg", ".ico"]);
- export function probe(filePath) {
- const ext = extname(filePath).toLowerCase();
- if (ext === ".svg") return { width: null, height: null, duration: null, codec: "svg" };
- try {
- // execFileSync (no shell) so a hostile filename like `"; rm -rf ~; ".png`
- Note: Quoted as data in code: Runs `rm -rf` against a root or home-directory path
- Line 11 on GitHub
- // can't break out of the quoting — filePath is passed as a literal argv entry.
- const raw = execFileSync(
- "ffprobe",
- ["-v", "quiet", "-print_format", "json", "-show_format", "-show_streams", filePath],
- { encoding: "utf8", timeout: 5000 },
- );
- const info = JSON.parse(raw);
- const stream = info.streams?.[0];
- const format = info.format;
- const isImage = IMAGE_EXT.has(ext);
- const duration = isImage
- ? null
- : parseFloat(format?.duration) || parseFloat(stream?.duration) || null;
- const width = parseInt(stream?.width, 10) || null;
- const height = parseInt(stream?.height, 10) || null;
- const codec = stream?.codec_name || null;
- return {
- duration: duration != null ? Math.round(duration * 10) / 10 : null,
- width,
- height,
- codec,
- };
- } catch {
- return { duration: null, width: null, height: null, codec: null };
- }
- }
Version history
v1.0.010/27/2026
Ratings and comments
Sign in to rate this skill.
Sign inFree to use. If it’s helped, pass it on.