home/categories/sql-databases/applied-artificial-intelligence-claude-code-toolkit-skills-general-dev-sql-optimization-skill-md
sql-databasesdatabases

sql-optimization

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.

applied-artificial-intelligence
maintainer
applied-artificial-intelligence
Updated 11/1/2025
Stars
56
Forks
14
quick start

Installation and usage

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.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use sql-optimization