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

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

  1. Identify high-impact queries by frequency and user/business impact.
  2. Capture plan/runtime evidence under representative parameters.
  3. Propose rewrites and access-path changes with expected effects.
  4. Compare candidates for latency gain versus complexity and risk.
  5. Roll selected change and monitor plan stability and resource usage.
  6. 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

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
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/kentoshimizu/sw-agent-skills/db-query-optimization/badge)](https://verified-skill.com/skills/kentoshimizu/sw-agent-skills/db-query-optimization)

Something wrong with this skill or its page? Tell us.