Agent skill
query-optimization
Select only the columns you need—avoid SELECT * Use when optimizing code performance. Performance category skill.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/query-optimization
Metadata
Additional technical details for this skill
- category
- Performance
- priority
- medium
- is built in
- YES
- session guardian id
- builtin_query_optimization
SKILL.md
Query Optimization
Select only the columns you need—avoid SELECT *. Use appropriate indexes for your query patterns. Batch related queries or use JOINs instead of N+1 queries. Use EXPLAIN to understand query execution plans. Consider pagination for large result sets. Avoid complex calculations in WHERE clauses that prevent index usage. Use query parameterization for both security and performance.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?