skills.homes logoskills.homescapability registry
home/categories/sql-databases/diegosouzapw-awesome-omni-skill-skills-development-data-sql-optimization-majiayu000-skill-md
cd ..
sql-databasesdatabases

data-sql-optimization

Production-grade SQL optimization for OLTP systems: EXPLAIN/plan analysis, balanced indexing, schema and query design, migrations, backup/recovery, HA, security, and safe performance tuning across PostgreSQL, MySQL, SQL Server, Oracle, SQLite.

View Sourcesql-databases
diegosouzapw
maintainer
diegosouzapw
Updated 2/28/2026
Stars
17
Forks
5
quick start

Installation and usage

Production-grade SQL optimization for OLTP systems: EXPLAIN/plan analysis, balanced indexing, schema and query design, migrations, backup/recovery, HA, security, and safe performance tuning across PostgreSQL, MySQL, SQL Server, Oracle, SQLite.

Installation
$ install --globalskills.sh
Usage

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

skills use data-sql-optimization