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
更新于 3/16/2026
星标
21
分支
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.
安装
$ install --globalskills.sh
使用
安装后，您可以通过在终端运行以下命令来使用此技能：
skills use sql-optimization-patterns