# Index Risk Review

> Review SQL Server missing-index and plan-warning evidence through AX-specific risk, write overhead, existing index overlap, and rollback guidance.

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

---


# Index Risk Review

Use this skill for missing-index candidates, plan missing-index warnings, and high-read AX table findings.

## Workflow

1. Run `scripts/manage_index_governance.py`.
2. Check table family risk using `rules/index_risk_rules.yml`.
3. Validate AX key patterns: `Partition`, `DataAreaId`, `RecId`, status/date fields.
4. Produce candidate-review output, not direct `CREATE INDEX` instructions.

## Related Scripts

- `manage_index_governance.py`
- `generate_validation_scripts.py`
- `simulate_change_risk.py`