Claude
Cursor
Skill
sql-explain
Explains a PostgreSQL EXPLAIN ANALYZE plan and points at the slowest node. Use when the user pastes a query plan; not for rewriting schemas.
Virus-scanned
Reviewed automatically before listing.
Download
goldziher-ai-rulez-bench_judge_corpus_units_clean-03_.claude_skills_sql-explain-ca967ad.zip · 0 KB
Install
skills CLI
npx skills add https://github.com/Goldziher/ai-rulez/tree/main/bench/judge/corpus/units/clean-03/.claude/skills/sql-explain
Claude Code
claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install goldziher-ai-rulez@llmmart
Git
git clone https://github.com/Goldziher/ai-rulez.git
The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole goldziher/ai-rulez collection as a plugin from our marketplace. Git is the plain clone.
Skill manifest
SQL explain
- Identify the node with the highest actual time and its row estimate versus actual rows.
- If the estimate is off by more than 10x, say that statistics are likely stale and suggest
ANALYZE <table>. - If a sequential scan filters most rows away, suggest one index and show the
CREATE INDEXstatement without running it. - Finish with a three-line summary: slowest node, cause, suggested change.
Files (ai-rulez)
-
SKILL.md 601 B
--- name: sql-explain description: "Explains a PostgreSQL EXPLAIN ANALYZE plan and points at the slowest node. Use when the user pastes a query plan; not for rewriting schemas." --- # SQL explain 1. Identify the node with the highest actual time and its row estimate versus actual rows. 2. If the estimate is off by more than 10x, say that statistics are likely stale and suggest `ANALYZE <table>`. 3. If a sequential scan filters most rows away, suggest one index and show the `CREATE INDEX` statement without running it. 4. Finish with a three-line summary: slowest node, cause, suggested change.
Comments (0)
Sign in to join the conversation.
Reviews (0)
No reviews yet.
No comments yet.