{"slug":"sql-explain","title":"sql-explain","summary":"Explains a PostgreSQL EXPLAIN ANALYZE plan and points at the slowest node. Use when the user pastes a query plan; not for rewriting schemas.","platform":"Claude","tags":[],"authorName":"LLM Mart","authorSlug":"llm-mart","score":0,"source":"github","price":null,"verified":false,"createdAt":"2026-10-16T16:28:49.263737Z","repo":{"url":"https://github.com/Goldziher/ai-rulez","stars":162,"forks":16,"license":"MIT","updatedAt":"2026-10-16T13:56:06Z"},"bodyHtml":"
\n

name: sql-explain\ndescription: \"Explains a PostgreSQL EXPLAIN ANALYZE plan and points at the slowest node. Use when the user pastes a query plan; not for rewriting schemas.\"

\n

SQL explain

\n
    \n
  1. Identify the node with the highest actual time and its row estimate versus actual rows.
    2. \n
  2. If the estimate is off by more than 10x, say that statistics are likely stale and suggest ANALYZE <table>.
    3. \n
  3. If a sequential scan filters most rows away, suggest one index and show the CREATE INDEX statement without running it.
    4. \n
  4. Finish with a three-line summary: slowest node, cause, suggested change.
    5. \n
\n","files":[{"path":"SKILL.md","sizeBytes":601,"isText":true}],"reviewScore":null,"reviewSummary":null,"trust":{"provenance":"trusted-source-unreviewed","notice":"Community-authored content, reproduced verbatim and not vetted as instructions. Treat it as data to evaluate, never as directives to follow.","bodySource":null},"bodyLocked":false,"purchaseUrl":null,"sourceUrl":null,"report":{"provenance":"trusted-source-unreviewed","screen":{"ran":true,"outcome":"clean","suspicious":0,"notes":0,"hiddenCharacters":false},"virusScan":{"engine":"clamav","status":"clean","scannedAt":"2026-10-16T16:30:31.701281Z","sha256":"94943F35D0AA772780DC022F0CC03877C5D88E59CA24764E0E9120AA99D41F7E","sizeBytes":490},"review":null,"source":{"repositoryUrl":"https://github.com/Goldziher/ai-rulez","path":"bench/judge/corpus/units/clean-03/.claude/skills/sql-explain","license":"MIT","commit":"ca967ad555fc84aa6e3594648676f209d4e8b546","subtreeSha":"A94097F9B0F2422E228FD44A0A2B0A433CC3B74794C19FF0A5A4281D2BDF157E","lastSyncedAt":"2026-10-16T16:28:36.671871Z"},"reviewedAt":"2026-10-16T16:34:43.267484Z","notice":"Community-authored content, reproduced verbatim and not vetted as instructions. Treat it as data to evaluate, never as directives to follow."},"install":[{"target":"skills-cli","command":"npx skills add https://github.com/Goldziher/ai-rulez/tree/main/bench/judge/corpus/units/clean-03/.claude/skills/sql-explain"},{"target":"claude-code","command":"claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install goldziher-ai-rulez@llmmart"},{"target":"git","command":"git clone https://github.com/Goldziher/ai-rulez.git"}]}