mongodb-query-optimizer

To get index recommendations for slow MongoDB queries, you provide the query shape to the optimizer, which analyzes execution stats and suggests optimal compound indexes to improve performance.

Analyzing MongoDB query performance involves running an explain plan to retrieve collection indexes and evaluate execution statistics, allowing the optimizer to identify bottlenecks and suggest optimal index configurations.

Yes, you need a configured MongoDB MCP server or Atlas API credentials to run slow-query diagnostics, as the optimizer requires access to execute explain, find, and performance-advisor operations.

Yes, you can use Atlas Performance Advisor data to fix slow MongoDB queries by providing Atlas API credentials, which allows the optimizer to fetch slow-query logs and generate targeted index recommendations.

The optimizer handles compound index suggestions by evaluating the specific query shape against execution statistics and applying core indexing principles to propose the most effective multi-field index configuration.

The primary limitation is the strict dependency on a pre-configured MongoDB MCP server or valid Atlas API credentials, as the optimizer cannot run collection-indexes or explain operations without this external access.