pg-index-optimizer

Analyzes PostgreSQL schemas and query patterns to recommend optimized indexes with ready-to-run DDL. Use when: optimize postgres indexes, missing index recommendations, slow query postgres fix, redundant index detection, CREATE INDEX suggestions.

pg-index-optimizer analyzes PostgreSQL schemas and query patterns to recommend optimized indexes with ready-to-run DDL. Use when: optimize postgres indexes, missing index recommendations, slow query postgres fix, redundant index detection, CREATE INDEX suggestions.
See the source code for full details and usage instructions.

Installation

OpenClaw (recommended)

Copy the skill into your OpenClaw skills directory:

git clone https://github.com/NeoSkillFactory/pg-index-optimizer.git
cp -r pg-index-optimizer ~/.openclaw/skills/pg-index-optimizer

Standalone

git clone https://github.com/NeoSkillFactory/pg-index-optimizer.git
cd pg-index-optimizer
npm install

License

MIT © NeoSkillFactory