mongodb-lens

Overview

MongoDB Lens is a comprehensive Model Context Protocol server that provides extensive access to MongoDB databases through natural language commands. It implements the MCP protocol with a rich set of tools and resources, allowing users to perform database operations, aggregations, schema analysis, and performance optimizations using conversational interfaces. The server supports various MongoDB features including transactions, geospatial queries, time series collections, and GridFS operations.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• find-documents

  Run queries with filters, projections, and sorting

  Try:Find all users from New YorkTry:Get the latest 10 orders sorted by date
• aggregate-data

  Execute aggregation pipelines

  Try:Calculate average price per product categoryTry:Get monthly sales totals
• insert-document

  Insert one or more documents into collections

  Try:Add a new user with email and profileTry:Insert multiple product records
• update-document

  Update documents matching specified criteria

  Try:Mark all orders from last month as completedTry:Update user profile by email
• create-database

  Create a new database with option to switch to it

  Try:Create an analytics databaseTry:Make a new database for logging
• create-collection

  Create new collections with custom options

  Try:Make a users collection with unique indexTry:Create a time series collection for metrics
• analyze-schema

  Automatically infer collection schemas

  Try:Analyze the schema of the orders collectionTry:Show me the structure of the products table
• list-databases

  View all accessible databases

  Try:Show me all databasesTry:What databases are available?
• list-collections

  Explore collections in the current database

  Try:What collections are in the current database?Try:Show me all available collections
• explain-query

  Analyze query execution plans

  Try:Explain this query: select * from users where status='active'Try:Show execution plan for finding expensive orders
• export-data

  Export query results in JSON or CSV format

  Try:Export all users to CSVTry:Get the last 100 orders as JSON
• create-index

  Create new indexes for performance optimization

  Try:Create an index on the email fieldTry:Add a compound index on name and date

Comparable tools

Installation

npm install -g mongodb-lens

docker pull furey/mongodb-lens

{
  "mcpServers": {
    "mongodb-lens": {
      "command": "npx",
      "args": ["-y", "@furey/mongodb-lens"]
    }
  }
}

FAQ

How do I authenticate with MongoDB?

You can configure authentication in the connection string or using environment variables. The server supports username/password, certificate-based, and LDAP authentication methods.

Does it support MongoDB Atlas?

Yes, MongoDB Lens can connect to MongoDB Atlas by providing the Atlas connection string in the configuration.

Compare mongodb-lens with