Open Skills Logo
Open Skills

sql-optimization-patterns

掌握SQL查询优化、索引策略和EXPLAIN分析，显著提升数据库性能并消除慢查询。适用于调试慢查询、设计数据库架构或优化应用性能的场景。

查看详情
name:sql-optimization-patternsdescription: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 schemas, or optimizing application performance.

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.md for detailed patterns and examples.

      • sql-optimization-patterns - Agent Skills