mongodb-indexing-optimization

What problem does it solve?

This Skill helps you diagnose and fix slow MongoDB queries by designing the right indexes and validating query plans so the database stops scanning too many documents.

Core Features & Use Cases

• Index design with ESR rule: Build single-field and compound indexes with correct field order for equality, sort, and range patterns.
• Explain-plan driven performance analysis: Interpret executionStats to confirm whether the query uses IXSCAN or falls back to COLLSCAN.
• Optimization troubleshooting: Apply targeted recovery steps for common issues like unused indexes, excessive indexes, and poor query shapes.

Quick Start

Ask for an index recommendation by providing the query pattern, collection_info (schema and cardinality hints), and your explain_output, and request the resulting index definition plus the expected performance impact.