MongoDB MCP Server for LLMS

1# 🗄️ MongoDB MCP Server for LLMS
2 
3[![Node.js 18+](https://img.shields.io/badge/node-18%2B-blue.svg)](https://nodejs.org/en/)
4[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)
5[![smithery badge](https://smithery.ai/badge/mongo-mcp)](https://smithery.ai/server/mongo-mcp)
6 
7A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.
8 
9## ✨ Features
10 
11- 🔍 Collection schema inspection
12- 📊 Document querying and filtering
13- 📈 Index management
14- 📝 Document operations (insert, update, delete)
15 
16## Demo Video
17 
18 
19https://github.com/user-attachments/assets/2389bf23-a10d-49f9-bca9-2b39a1ebe654
20 
21 
22 
23 
24## 🚀 Quick Start
25 
26To get started, find your mongodb connection url and add this configuration to your Claude Desktop config file:
27 
28**MacOS**: `~/Library/Application\ Support/Claude/claude_desktop_config.json`  
29**Windows**: `%APPDATA%/Claude/claude_desktop_config.json`
30 
31```json
32{
33  "mcpServers": {
34    "mongodb": {
35      "command": "npx",
36      "args": [
37        "mongo-mcp",
38        "mongodb://<username>:<password>@<host>:<port>/<database>?authSource=admin"
39      ]
40    }
41  }
42}
43```
44 
45### Installing via Smithery
46 
47To install MongoDB MCP Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mongo-mcp):
48 
49```bash
50npx -y @smithery/cli install mongo-mcp --client claude
51```
52 
53### Prerequisites
54 
55- Node.js 18+
56- npx
57- Docker and Docker Compose (for local sandbox testing only)
58- MCP Client (Claude Desktop App for example)
59 
60### Test Sandbox Setup
61 
62If you don't have a mongo db server to connect to and want to create a sample sandbox, follow these steps
63 
641. Start MongoDB using Docker Compose:
65 
66```bash
67docker-compose up -d
68```
69 
702. Seed the database with test data:
71 
72```bash
73npm run seed
74```
75 
76### Configure Claude Desktop
77 
78Add this configuration to your Claude Desktop config file:
79 
80**MacOS**: `~/Library/Application\ Support/Claude/claude_desktop_config.json`  
81**Windows**: `%APPDATA%/Claude/claude_desktop_config.json`
82 
83#### Local Development Mode:
84 
85```json
86{
87  "mcpServers": {
88    "mongodb": {
89      "command": "node",
90      "args": [
91        "dist/index.js",
92        "mongodb://root:example@localhost:27017/test?authSource=admin"
93      ]
94    }
95  }
96}
97```
98 
99### Test Sandbox Data Structure
100 
101The seed script creates three collections with sample data:
102 
103#### Users
104 
105- Personal info (name, email, age)
106- Nested address with coordinates
107- Arrays of interests
108- Membership dates
109 
110#### Products
111 
112- Product details (name, SKU, category)
113- Nested specifications
114- Price and inventory info
115- Tags and ratings
116 
117#### Orders
118 
119- Order details with items
120- User references
121- Shipping and payment info
122- Status tracking
123 
124## 🎯 Example Prompts
125 
126Try these prompts with Claude to explore the functionality:
127 
128### Basic Operations
129 
130```plaintext
131"What collections are available in the database?"
132"Show me the schema for the users collection"
133"Find all users in San Francisco"
134```
135 
136### Advanced Queries
137 
138```plaintext
139"Find all electronics products that are in stock and cost less than $1000"
140"Show me all orders from the user john@example.com"
141"List the products with ratings above 4.5"
142```
143 
144### Index Management
145 
146```plaintext
147"What indexes exist on the users collection?"
148"Create an index on the products collection for the 'category' field"
149"List all indexes across all collections"
150```
151 
152### Document Operations
153 
154```plaintext
155"Insert a new product with name 'Gaming Laptop' in the products collection"
156"Update the status of order with ID X to 'shipped'"
157"Find and delete all products that are out of stock"
158```
159 
160## 📝 Available Tools
161 
162The server provides these tools for database interaction:
163 
164### Query Tools
165 
166- `find`: Query documents with filtering and projection
167- `listCollections`: List available collections
168- `insertOne`: Insert a single document
169- `updateOne`: Update a single document
170- `deleteOne`: Delete a single document
171 
172### Index Tools
173 
174- `createIndex`: Create a new index
175- `dropIndex`: Remove an index
176- `indexes`: List indexes for a collection
177 
178## 📜 License
179 
180This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.
181