explain_query

Analyze and understand MongoDB query execution plans with detailed insights into index usage, documents examined, and execution stages to optimize slow queries.

Instructions

Get the execution plan for a query.

Helps understand:

How MongoDB will execute the query
Which indexes will be used
Number of documents examined
Execution stages and timing

Use this to optimize slow queries.

Input Schema

Name	Required	Description
`collection`	Yes	Collection name
`database`	No	Database name (optional if default database is configured)
`filter`	Yes	MongoDB query filter to explain
`projection`	No	MongoDB projection (optional)
`sort`	No	MongoDB sort specification (optional)

Input Schema (JSON Schema)

{
  "properties": {
    "collection": {
      "description": "Collection name",
      "type": "string"
    },
    "database": {
      "description": "Database name (optional if default database is configured)",
      "type": "string"
    },
    "filter": {
      "description": "MongoDB query filter to explain",
      "type": "object"
    },
    "projection": {
      "description": "MongoDB projection (optional)",
      "type": "object"
    },
    "sort": {
      "description": "MongoDB sort specification (optional)",
      "type": "object"
    }
  },
  "required": [
    "collection",
    "filter"
  ],
  "type": "object"
}

MongoDB MCP Server

explain_query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MongoDB MCP Server

Related Tools