Agent Skills
› NeverSight/learn-skills.dev
› sql-optimization-patterns
sql-optimization-patterns
GitHub用于SQL查询优化、索引策略设计及EXPLAIN分析，旨在提升数据库性能、消除慢查询并降低负载。适用于调试慢查询、设计高性能Schema及解决N+1问题等场景。
Trigger Scenarios
调试运行缓慢的SQL查询
设计高性能数据库模式
优化应用响应时间
分析EXPLAIN查询计划
实施高效索引
解决N+1查询问题
Install
npx skills add NeverSight/learn-skills.dev --skill sql-optimization-patterns -g -y
SKILL.md
Frontmatter
{
"name": "sql-optimization-patterns",
"risk": "unknown",
"source": "community",
"description": "Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database..."
}
SQL Optimization Patterns
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
Use this skill when
- Debugging slow-running queries
- Designing performant database schemas
- Optimizing application response times
- Reducing database load and costs
- Improving scalability for growing datasets
- Analyzing EXPLAIN query plans
- Implementing efficient indexes
- Resolving N+1 query problems
Do not use this skill when
- The task is unrelated to sql optimization patterns
- You need a different domain or tool outside this scope
Instructions
- Clarify goals, constraints, and required inputs.
- Apply relevant best practices and validate outcomes.
- Provide actionable steps and verification.
- If detailed examples are required, open
resources/implementation-playbook.md.
Resources
resources/implementation-playbook.mdfor detailed patterns and examples.
Version History
- e0220ca Current 2026-07-05 21:46
