What is Mongodb Mcp Server

mongodb-mcp-server is a Model Context Protocol server that provides read-only access to MongoDB databases, allowing large language models (LLMs) to inspect collection schemas and execute aggregation pipelines.

Use cases

Use cases for mongodb-mcp-server include data analysis, generating statistics from collections, and inspecting collection schemas for better understanding of data structures in MongoDB databases.

How to use

To use mongodb-mcp-server, configure it in the ‘mcpServers’ section of your ‘claude_desktop_config.json’ file. Specify the command to run the server and provide the MongoDB connection URI. Example usage includes executing aggregation pipelines and retrieving execution plans for those pipelines.

Key features

Key features include the ability to execute MongoDB aggregation pipelines, retrieve execution plans, and access inferred JSON schema information for collections. The server ensures safety with automatic document limits and read-only operations.

Where to use

undefined

📢 COMMUNITY SERVER NOTICE
This is a community-maintained MCP Server.
👉 For the official MongoDB MCP Server, visit mongodb-js/mongodb-mcp-server

MongoDB MCP Server

A Model Context Protocol server that provides read-only access to MongoDB databases. This server enables LLMs to inspect collection schemas and execute aggregation pipelines.

Components

Tools

• aggregate

  • Execute MongoDB aggregation pipelines against the connected database
  • Input:
    • collection (string): The collection to query
    • pipeline (array): MongoDB aggregation pipeline stages
    • options (object): Optional aggregation settings
      • allowDiskUse (boolean): Allow operations that require disk usage
      • maxTimeMS (number): Maximum execution time in milliseconds
      • comment (string): Comment to identify the operation
  • Default limit of 1000 documents if no limit stage is specified
  • Default timeout of 30 seconds

• explain

  • Get execution plans for aggregation pipelines
  • Input:
    • collection (string): The collection to analyze
    • pipeline (array): MongoDB aggregation pipeline stages
    • verbosity (string): Detail level of the explanation
      • Options: “queryPlanner”, “executionStats”, “allPlansExecution”
      • Default: “queryPlanner”

Resources

The server provides schema information for each collection in the database:

• Collection Schemas (mongodb://<host>/<collection>/schema)
  • Inferred JSON schema information for each collection
  • Includes field names and data types
  • Schema is derived from sampling collection documents

Usage with Claude Desktop

To use this server with the Claude Desktop app, add the following configuration to the “mcpServers” section of your claude_desktop_config.json:

Replace mydb with your database name and adjust the connection string as needed.

Example Usage

Basic Aggregation

{
  "collection": "users",
  "pipeline": [
    { "$match": { "age": { "$gt": 21 } } },
    { "$group": {
      "_id": "$city",
      "avgAge": { "$avg": "$age" },
      "count": { "$sum": 1 }
    }},
    { "$sort": { "count": -1 } },
    { "$limit": 10 }
  ],
  "options": {
    "allowDiskUse": true,
    "maxTimeMS": 60000,
    "comment": "City-wise user statistics"
  }
}

Query Explanation

{
  "collection": "users",
  "pipeline": [
    { "$match": { "age": { "$gt": 21 } } },
    { "$sort": { "age": 1 } }
  ],
  "verbosity": "executionStats"
}

Safety Features

• Automatic limit of 1000 documents if no limit is specified in the pipeline
• Default timeout of 30 seconds for all operations
• Read-only operations only
• Safe schema inference from collection samples

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.