要点
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
SKILL.md
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'
);