mongodb-query-and-index-optimize

What problem does it solve?

MongoDB performance issues caused by missing indexes, poorly chosen compound keys, and inefficient aggregation patterns are common bottlenecks in production systems.

Core Features & Use Cases

The skill codifies 46 rules across 5 categories (Index Essentials, Specialized Indexes, Query Patterns, Aggregation Optimization, Performance Diagnostics) to guide index design, query construction, and pipeline optimization; it integrates with Atlas Performance Advisor, $indexStats, explain(), and Query Settings to prioritize changes based on real workloads; and it provides verification paths, examples, and measurable guidance for production-grade deployments.

Quick Start

Start by auditing representative queries with explain(), identify missing indexes or slow stages, implement targeted changes, and validate improvements with controlled rollout and monitoring.