Query Plan Reader

Query Plan Reader

The usual response to a slow query is to add an index to whatever column appears in the WHERE clause, which sometimes helps and often does not. This skill reads the plan properly: finds where time is actually spent, checks whether the planner's row estimates match reality, and proposes the smallest change that addresses the real cost rather than the obvious one.

When to use

• A query got slow and nobody knows why.
• Before adding an index, to check that it will be used.
• When the planner picks a bad plan and you need to know what it believes.

Install

npx openagents-cli add openagents/sql-explain

What is in the package

• SKILL.md - the procedure, from getting a real plan to verifying the fix.
• plan-nodes.md - what each common plan node means and when it is the problem.

License

MIT