kentoshimizu/sw-agent-skills/db-query-optimization
Claude Code and agent skill by kentoshimizu/sw-agent-skills
Trust tier 3
- community
Source check pending
Checking that the SKILL.md file is still in the repository.
Query optimization workflow for reducing latency and resource cost through plan-aware rewrites and access-path improvements. Use when hot-path query behavior is the bottleneck; do not use for conceptual schema redesign without workload evidence.
Install
npx vskill@latest install kentoshimizu/sw-agent-skills/db-query-optimizationSKILL.md
DB Query Optimization
Overview
Use this skill to improve query performance based on execution evidence, not intuition.
Scope Boundaries
- Hot-path latency or database CPU/IO usage is query-bound.
- Query plans are unstable across parameter distributions.
- Workload changes expose previously acceptable query anti-patterns.
Core Judgments
- Dominant bottleneck: scan cost, join explosion, sort spill, lock wait, network round trips.
- Rewrite scope: query shape, index changes, schema adjustment, or materialization.
- Plan stability and parameter-sensitivity risk.
- Correctness risk from aggressive rewrite or approximation.
Practitioner Heuristics
- Start from actual execution plans and runtime metrics.
- Optimize the highest-impact query families, not one-off outliers.
- Sargability and predicate selectivity usually dominate early wins.
- Keep optimization readable; opaque SQL hacks create long-term maintenance debt.
Workflow
- Identify high-impact queries by frequency and user/business impact.
- Capture plan/runtime evidence under representative parameters.
- Propose rewrites and access-path changes with expected effects.
- Compare candidates for latency gain versus complexity and risk.
- Roll selected change and monitor plan stability and resource usage.
- Record conditions that should trigger re-optimization.
Common Failure Modes
- Tuning for small dev datasets misleads production behavior.
- Index-only fixes mask poor query shape.
- Query changes improve p50 while degrading tail latency.
Failure Conditions
- Stop when no representative workload evidence is available.
- Stop when optimization changes correctness semantics.
- Escalate when required performance target is unattainable without model changes.
Security
- Security scanPassed, 95 of 100Pattern checks on the skill's files.
- Model reviewPassed
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingskills/db-query-optimization/SKILL.md
Popularity
- Repository stars
- 5
- 7-day trend score
- 9
Stars and forks are for the whole GitHub repository, not this skill alone. Refreshed 2 May 2026, 6 months ago.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/kentoshimizu/sw-agent-skills/db-query-optimization)