Database Query Performance
SkillDatabases & dataDiagnose database latency with explain plans, index ownership, and query-shape review. Use when a query is slow, an index is missing, or scans and N+1 patterns appear.
Available today. Use it from your connected AI after setup.
No other account needed.
Connect ahel once, and every AI you use reads what you have installed.
Then ask your AI: use the Database Query Performance skill
What this skill tells your AI
The instructions your AI receives, as published by hoangnguyen0403/agent-skills-standard in skills/database/database-query-performance/SKILL.md and read by ahel’s review.
Priority: P0 (CRITICAL)
Slow query work starts with the query shape and evidence, not with random index creation.
Rules
- Capture the exact query, parameters, and access path.
- Run explain or equivalent plan inspection before adding indexes.
- Match indexes to filter, join, sort, and coverage needs.
- Fix N+1 at the query pattern or loading strategy, not by caching first.
Verify
- Explain plan was reviewed.
- Proposed index maps to a named query path.
- Write cost of the index is acceptable.
- Pagination or batch loading avoids deep scans or N+1 loops.
Anti-Patterns
- No blind indexes: every index needs a query owner.
- No cache-first latency fix: fix query shape before hiding it.
- No ORM opacity: inspect generated SQL when the ORM is involved.
References
Signals
- GitHub stars
- 565
- Forks
- 164
- Last commit
- Sep 2026
Advanced
- Catalog kind
- skill
- Gateway key
database-query-performance- Source
- github.com/hoangnguyen0403/agent-skills-standard