SQL query optimization patterns including EXPLAIN plan analysis, index strategies, query rewriting, and N+1 query prevention. Use when optimizing slow database queries, analyzing query performance, designing indexes, or debugging database bottlenecks. Works with PostgreSQL, MySQL, SQLite, and other SQL databases. Typical improvements: 10x-1000x query speedup.
Add this skill
npx mdskills install applied-artificial-intelligence/sql-optimizationComprehensive reference guide with excellent EXPLAIN analysis, index strategies, and concrete optimization patterns across databases
npx mdskills install applied-artificial-intelligence/sql-optimization
npx mdskills install applied-artificial-intelligence/sql-optimization