What problem does it solve?
Query performance, sort costs, and uniqueness guarantees in MongoDB often depend on correct index shape; this skill helps create, inspect, drop, and explain indexes so agents and developers can tune read latency and enforce constraints with confidence.
Core Features & Use Cases
- Create single-field and compound indexes, including unique and TTL indexes, to match common filter and sort patterns.
- List and drop obsolete indexes to reduce write amplification and storage overhead in high-write collections.
- Explain query plans using execution statistics and optional hints so the agent can verify whether an index is used and iterate on index design.
Quick Start
Provide a MongoDB URI and an INDEX_INPUT_JSON payload describing database, collection, and action then run the manage-indexes script to create, list, drop, or explain indexes.