sql-optimization

SKILL.md

Universal SQL performance optimization across MySQL, PostgreSQL, SQL Server, Oracle, and other databases.

Covers query analysis, index strategy design, subquery optimization, and JOIN tuning with before/after examples for each technique

Addresses common anti-patterns including SELECT *, function calls in WHERE clauses, inefficient pagination, and correlated subqueries

Provides database-agnostic guidance on batch operations, temporary tables, covering indexes, and partial indexes

Includes performance monitoring queries tailored to MySQL, PostgreSQL, and SQL Server for identifying slow queries and execution plan analysis

Features a universal optimization checklist spanning query structure, indexing, schema design, and testing methodology

SQL Performance Optimization Assistant

Expert SQL performance optimization for ${selection} (or entire project if no selection). Focus on universal SQL optimization techniques that work across MySQL, PostgreSQL, SQL Server, Oracle, and other SQL databases.

🎯 Core Optimization Areas

Query Performance Analysis

-- ❌ BAD: Inefficient query patterns
SELECT * FROM orders o
WHERE YEAR(o.created_at) = 2024
  AND o.customer_id IN (
      SELECT c.id FROM customers c WHERE c.status = 'active'
  );