Query performance review

Skill jukrap/ai-agent-playbook/skills/database/query-performance-review

Reusable AI agent skills, project templates, and guardrails for safer software maintenance and delivery.

Install

npx -y skills add jukrap/ai-agent-playbook --skill query-performance-review

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Use when reviewing slow SQL, reporting queries, dashboard queries, API list/detail queries, exports, aggregates, joins, sort/pagination, full scans, N+1 patterns, or index choices.

SKILL.md

1.2 KB, as published. Nobody here has run it

Query Performance Review

Use this as the primary database skill for SQL/query performance and rendered consumer checks.

Workflow

Identify the query, caller, consumer, representative parameters, expected row count, timeout budget, and correctness requirements.
Gather available evidence: explain plan, indexes, filters, joins, sort/pagination, aggregates, N+1 behavior, cache behavior, and rendered output.
Propose the smallest safe change: query rewrite, index, pagination, pre-aggregation, projection reduction, batching, or consumer-level change.
Verify with explain/estimate, before/after query results, application behavior, report/export/dashboard output, and project-defined performance checks.

Reference

Read references/query-plan-and-index-checks.md for plan, index, cardinality, and query-shape checks.