DATABASES / MongoDB
MongoDB query optimizer
Official MongoDB skill that limits itself to slow-query and index work and names the MCP tools it expects for explain, indexes, and Atlas Performance Advisor.
“Help with MongoDB query optimization and indexing. Use only when the user asks for optimization or performance: "How do I optimize this query?", "How do I index this?", "Why is this query slow?", "Can you fix my slow queries?", "What are the slow queries on my cluster?", etc. Do not invoke for general MongoDB query writing unless user asks for performance or index help. Prefer indexing as optimization strategy. Use MongoDB MCP when available.”
01 / THE REASONING
Why this made the selection.
- The catalogue's MongoDB performance advisor is a GitHub Copilot agent, not this official skill.
- The skill names collection-indexes, explain, find, and atlas-get-performance-advisor instead of a generic index tip.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- skills/mongodb-query-optimizer/SKILL.md
- README.md
- LICENSE
Our findings
- The skill says not to invoke it for routine query authoring unless the user asked about optimization, slow queries, or indexing.
- For one query it names collection-indexes, explain, and find, and it says to start explain in queryPlanner mode and look for COLLSCAN.
- Without Atlas API credentials it says general performance analysis requires Atlas MCP configuration, or the user should ask about a specific query instead.
Not established by this review
- The skill was not executed.
- No MongoDB MCP tool was called.
- No index was created.
- Not executed: it was not installed or run.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Add a skill to your workflow.
DOCUMENTED COMMAND
npx skills add mongodb/agent-skillsRun in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.
- The README says that command installs the skills and does not by itself configure an MCP server.
- MCP setup is a different command, npx "mongodb-mcp-server@latest" setup, which this review did not run.
Before you start
- A skills-compatible agent
- MongoDB MCP with a working connection string for explain tools
- Atlas API credentials for Performance Advisor
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
https://github.com/mongodb/agent-skills/blob/c370a63b27075008a92134686b24af3817edeb00/skills/mongodb-query-optimizer/SKILL.md
Supports: invocation limits and tool names
- Apache-2.0 LICENSE ↗Checked
https://github.com/mongodb/agent-skills/blob/c370a63b27075008a92134686b24af3817edeb00/LICENSE
Supports: Apache-2.0
- README ↗Checked
https://github.com/mongodb/agent-skills/blob/c370a63b27075008a92134686b24af3817edeb00/README.md
Supports: install line and host list
https://raw.githubusercontent.com/mongodb/agent-skills/c370a63b27075008a92134686b24af3817edeb00/skills/mongodb-query-optimizer/SKILL.md
Supports: upstreamDescription, limitations, review.notTested, review.reviewedAt