Agent skill · practicalswan
mongodb-query-optimizer
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.
What it needs
About 7k tokens when loaded.
What this skill does
MongoDB Query Optimizer When this skill is invoked Invoke only when the user wants: Query/index optimization or performance help Why a query is slow or how to speed it up Slow queries on their cluster and/or how to optimize them Do not invoke for routine query authoring unless the user has requested help with optimization, slow queries, or indexing. High Level Workflow General Performance Help If the user wants to examine slow queries, or is looking for general performance suggestions (not regarding any particular query): Use MongoDB MCP server atlas-get-performance-advisor tool to fetch slow query logs and performance advisor output Make suggestions based on this information If Atlas MCP Server for Atlas is not configured or you don’t have enough information to run atlas-get-performance-advisor against the correct cluster, tell the user that general performance analysis requires Atlas MCP Server configuration with API credentials, and suggest they configure it or ask about a specific query instead. Help with a Specific Query If the user is asking about a particular query: Use collection-indexes, explain, and find MCP tools to get existing indexes on the collection, explain() output for the query, and a sample document from the collection Use atlas-get-performance-advisor MCP tool to fetch slow query logs and performance advisor output Then make an optimization suggestion based on collected information and MongoDB best practices and examples from reference files. Prefer creating an index that fully covers the query if possible. If you cannot use MongoDB MCP Server then still try to make a suggestion. MCP: available tools How to invoke. Call the MongoDB MCP server with the exact tool name as toolName and a single arguments object as arguments. Do not pass the tool name as an option, query param, or nested key; pass it as the MCP tool name and the parameters as the arguments object. Full MCP Server tool reference: MongoDB MCP Server Tools. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills practicalswan/mongodb-query-optimizer