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.

Files1

View on GitHub

SKILL.md

GitHub

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.

Related in other

limits-colimits

Context management for Claude Code. Hooks maintain state via ledgers and handoffs. MCP execution without context polluti...

by parcadei
3,392

ddttom-allaboutv2-claude-skills-block-collection-and-party

The Block Collection and Block Party are repositories for existing AEM blocks, build tools, code snippets, integration p...

by mattnigh
20

nodnarbnitram-claude-code-extensions-claude-skills-esphome-confi

This skill should be used when the user asks to "create an esphome config", "set up an esp32 device", "configure esphome...

by mattnigh
20