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
No comments yet. Sign in to start the discussion.
Threaded comments with markdown support coming soon.