home/categories/sql-databases/kumaran-is-claude-code-onboarding-claude-skills-sql-optimization-patterns-skill-md
sql-databasesdatabases
sql-optimization-patterns
Transforms slow PostgreSQL queries into fast operations through systematic EXPLAIN ANALYZE, indexing strategies, N+1 elimination, cursor pagination, and materialized views. Use when diagnosing slow queries, optimizing database performance, or designing index strategies — always profile before optimizing.
maintainer
kumaran-is
Updated 3/16/2026
Stars
21
Forks
14
quick start
Installation and usage
Transforms slow PostgreSQL queries into fast operations through systematic EXPLAIN ANALYZE, indexing strategies, N+1 elimination, cursor pagination, and materialized views. Use when diagnosing slow queries, optimizing database performance, or designing index strategies — always profile before optimizing.
Installation
$ install --globalskills.sh
Usage
Once installed, you can use this skill by running the following command in your terminal:
skills use sql-optimization-patterns