MCP MongoDB Server
An MCP (Model Context Protocol) server that provides tools to interact with MongoDB databases, specifically designed to query user collections.
Features
- Query Users: Search and filter users with MongoDB queries
- Get User by ID: Retrieve specific users by their ID
- Count Users: Get total count of users with optional filtering
- Flexible Filtering: Support for MongoDB query operators
- Sorting and Projection: Advanced query capabilities
Prerequisites
- Node.js 18+
- MongoDB instance (local or cloud)
- TypeScript knowledge
Installation
-
Install dependencies:
npm install -
Set up environment variables:
cp .env.example .envEdit
.envwith your MongoDB connection details:MONGODB_URI=mongodb://localhost:27017 MONGODB_DB_NAME=your_database_name -
Build the project:
npm run build
Usage
Starting the Server
npm start
Or for development with auto-reload:
npm run dev
Available Tools
1. query_users
Query users with optional filters, sorting, and projection.
Parameters:
filter(object, optional): MongoDB filter objectlimit(number, optional): Maximum results (default: 10)sort(object, optional): Sort criteriaprojection(object, optional): Fields to include/exclude
Example:
{
"filter": {"age": {"$gte": 25}},
"limit": 5,
"sort": {"name": 1},
"projection": {"_id": 1, "name": 1, "email": 1}
}
2. get_user_by_id
Retrieve a specific user by their ID.
Parameters:
userId(string, required): The user ID to search for
Example:
{
"userId": "507f1f77bcf86cd799439011"
}
3. count_users
Count total users with optional filtering.
Parameters:
filter(object, optional): MongoDB filter object
Example:
{
"filter": {"status": "active"}
}
MongoDB Connection
The server supports various MongoDB connection types:
Local MongoDB
MONGODB_URI=mongodb://localhost:27017
MONGODB_DB_NAME=myapp
MongoDB with Authentication
MONGODB_URI=mongodb://username:password@localhost:27017/myapp
MONGODB_DB_NAME=myapp
MongoDB Atlas
MONGODB_URI=mongodb+srv://username:password@cluster.mongodb.net/myapp
MONGODB_DB_NAME=myapp
Development
Project Structure
├─