← All skills

optimization-plan

80 / 100 · Low risk

Fine to try.

By chmonitor/chmonitor (GitHub) · data · 304 stars · scanned at commit 0414013

Build and present a ranked, recommend-only ClickHouse optimization plan from the findings the advisors already stored: unread tables, unused projections, detached parts, TTL rewrite and OPTIMIZE-on-unchanged-data merge cost, retention, schema suggestions. Load for optimization plan, what to optimize first, cleanup plan, rank savings, or prioritize storage work.

Works with any agent that supports SKILL.md skills.

What this skill can do

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'optimization-plan' ] || [ -L ~/.agents/skills/'optimization-plan' ]; then echo 'A skill folder named optimization-plan already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/chmonitor/chmonitor' "$d" && git -C "$d" checkout --quiet '04140135acfbd2adb525c7173459b584f9f3bb86' -- '.agents/skills/optimization-plan' && mkdir -p ~/.agents/skills && cp -R "$d"/'.agents/skills/optimization-plan' ~/.agents/skills/'optimization-plan' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'optimization-plan' ~/.claude/skills/'optimization-plan' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for chmonitor/chmonitor shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/chmonitor/chmonitor.svg)](https://zalavijaysinh.github.io/skilltrust/repos/chmonitor/chmonitor/)

Score history