sql-optimization-patterns

Data, Backend & API

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.

Documentation

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.

Compétences similaires

Explorez d'autres agents de la catégorie Data, Backend & API

Voir tout le catalogue

vector-index-tuning

Optimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.

VOIR LA FICHE

tavily-web

Web search, content extraction, crawling, and research capabilities using Tavily API

VOIR LA FICHE

wiki-researcher

Conducts multi-turn iterative deep research on specific topics within a codebase with zero tolerance for shallow analysis. Use when the user wants an in-depth investigation, needs to understand how something works across multiple files, or asks for comprehensive analysis of a specific system or pattern.

VOIR LA FICHE
Utiliser l'Agent sql-optimization-patterns - Outil & Compétence IA | Skills Catalogue | Skills Catalogue