skills.homes logoskills.homescapability registry
home/categories/sql-databases/ancoleman-ai-design-components-skills-optimizing-sql-skill-md
cd ..
sql-databasesdatabases

optimizing-sql

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server. Use when debugging slow queries, analyzing execution plans, or improving database performance.

View Sourcesql-databases
ancoleman
maintainer
ancoleman
Updated 12/9/2025
Stars
333
Forks
51
quick start

Installation and usage

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server. Use when debugging slow queries, analyzing execution plans, or improving database performance.

Installation
$ install --globalskills.sh
Usage

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

skills use optimizing-sql