# Index Portfolio Optimizer

> Optimize the whole index portfolio by finding redundant, overlapping, unused, and high-write-cost indexes.

- Skill: `rweisssieker-xp/index-portfolio-optimizer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/index-portfolio-optimizer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/index-portfolio-optimizer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/index-portfolio-optimizer

---


# Index Portfolio Optimizer

Run:

```bash
node runtime/runTool.js index_portfolio_optimizer '{"indexes":[{"name":"ix_a","columns":["status"],"reads":100,"writes":50},{"name":"ix_ab","columns":["status","created_at"],"reads":200,"writes":60}]}'
```

Returns redundant indexes, drop candidates, create candidates, and action order.