Skip to content
Development
Skill

/database-query-performance

Diagnose 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.

@hoangnguyen0403hoangnguyen0403@hoangnguyen0403
From plugin
agent-skills-standard
538200 skills1 MCP
Install
$ npx -y skills add hoangnguyen0403/agent-skills-standard --skill database-query-performance --agent claude-code

How it fires

How this skill gets triggered: by you, by Claude, or both.

  • Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.Auto-invocation is when the right skill fires by itself at the right moment, driven by a FLOW.md router and a hook, instead of you invoking it by name. It is the difference between a skill being installed and a skill actually getting used.Read the full definition →
  • You can call itInvoke it directly when you want it.
  • Slash command/database-query-performance

Context preview

The summary Claude sees to decide when to auto-load this skill.

Diagnose 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.

SKILL.md

database-query-performance.SKILL.md
name: database-query-performance
description: Diagnose 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.
metadata:
  triggers:
    files:
    - '**/*.sql'
    - '**/*.entity.ts'
    - 'prisma/schema.prisma'
    keywords:
    - slow query
    - explain
    - index
    - scan
    - n+1

Database Query Performance

**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

  • [Framework Map](../references/framework-map.md)
  • [Index Strategies](references/index-strategies.md)
Read it on GitHub ↗
Ships withagent-skills-standard

The portable SDLC standards layer for AI coding agents. Sync once, then work in your own runtime.

Get the whole plugin
Stats
TypeScriptJavaScriptNext.jsAngularGo
+7 tags
JavaKotlinPHPMCPiOSAndroidFlutter
539
Stars
158
Forks
Active
Maintenance
TypeScript
Language
Apache-2.0
License
26d ago
Last commit
6mo ago
Created

Repo: hoangnguyen0403/agent-skills-standard

In this plugin
200 skills1 MCP
See everything inside

Other skills on agent-skills-standard.

See all 200 skills in agent-skills-standard