Alanamultiskillagent
Back to skills

mongodb-query-optimizer

data

Diagnoses slow MongoDB queries and recommends indexes based on explain plans, existing collection indexes, and Atlas Performance Advisor output. Follows the ESR rule (Equality, Sort, Range) for compou

mongodbmongodb
|View all mongodb skills →

Setup & Installation

npx skills add https://github.com/mongodb/mongodb-query-optimizer --skill mongodb-query-optimizer
or paste the link and ask your coding assistant to install it
https://github.com/mongodb/mongodb-query-optimizer
View on GitHub

What This Skill Does

Diagnoses slow MongoDB queries and recommends indexes based on explain plans, existing collection indexes, and Atlas Performance Advisor output. Follows the ESR rule (Equality, Sort, Range) for compound index suggestions and prefers index coverage over query rewrites. It pulls real explain() stats and Performance Advisor data from your cluster instead of guessing from the query shape, so index suggestions match actual selectivity and workload.

When to use it

  • Working with mongodb query optimizer functionality
  • Implementing mongodb query optimizer features
  • Debugging mongodb query optimizer related issues

Similar Skills

atlas-stream-processing

Manages MongoDB Atlas Stream Processing pipelines through the MongoDB MCP Server. Covers workspace provisioning, connection setup for Kafka, Atlas clusters, S3, HTTPS, and Lambda, plus processor lifec

attach-db

Attaches a DuckDB database file to your current project session. It explores the schema, collects table names, column definitions, and row counts, then writes a shared state file so future queries res

azure-ai-anomalydetector-java

Azure AI Anomaly Detector SDK for Java lets you detect anomalies in time-series data using univariate or multivariate analysis. It supports batch detection, real-time streaming detection, and change p

azure-cosmos-db-py

Guides Python and FastAPI code toward production-ready Azure Cosmos DB NoSQL integrations. Covers client setup with dual authentication (DefaultAzureCredential for Azure, key-based for the local emula