skills.homes logoskills.homescapability registry
home/categories/sql-databases/isdaniel-pgtuner-mcp-skills-pg-index-optimization-skill-md
cd ..
sql-databasesdatabases

pg-index-optimization

Performs comprehensive PostgreSQL index optimization including unused index cleanup, duplicate detection, missing index recommendations, and hypothetical index testing with HypoPG. Provides actionable CREATE/DROP INDEX statements with estimated impact.

查看源碼sql-databases
isdaniel
maintainer
isdaniel
更新於 3/26/2026
星標
21
分支
4
quick start

Installation and usage

Performs comprehensive PostgreSQL index optimization including unused index cleanup, duplicate detection, missing index recommendations, and hypothetical index testing with HypoPG. Provides actionable CREATE/DROP INDEX statements with estimated impact.

安裝
$ install --globalskills.sh
使用

安裝後，您可以通過在終端運行以下命令來使用此技能：

skills use pg-index-optimization