MCP Database Server

A Model Context Protocol (MCP) server implementation that allows Large Language Models (LLMs) to interact with various databases through natural language. Currently supports MongoDB, with plans to support:

PostgreSQL
CockroachDB
Redis
And more...

Features

Database operations through natural language
Currently supports MongoDB with features:
- List all collections
- Query documents with filtering and projection
- Insert documents
- Delete documents
- Aggregate pipeline operations
Future support for other databases:
- PostgreSQL: SQL queries, table operations
- CockroachDB: Distributed SQL operations
- Redis: Key-value operations, caching

Prerequisites

Node.js v20.12.2 or higher
Database (currently MongoDB, other databases coming soon)
Claude Desktop Application

Installation

Clone the repository:

git clone https://github.com/manpreet2000/mcp-database-server.git
cd mcp-database-server

Install dependencies:

npm install

Build the TypeScript code:

npm run build

Configuration

To get started, you need to configure your database connection in your Claude Desktop configuration file:

MacOS

~/Library/Application\ Support/Claude/claude_desktop_config.json

Windows

%APPDATA%/Claude/claude_desktop_config.json

Add the following configuration to your claude_desktop_config.json:

{
  "mcpServers": {
    "database": {
      "command": "/path/to/node",
      "args": ["/path/to/mcp-database/dist/index.js"],
      "env": {
        "MONGODB_URI": "your-mongodb-connection-string"
      }
    }
  }
}

Replace:

/path/to/node with your Node.js executable path or just use node
/path/to/mcp-database with the absolute path to this repository
your-mongodb-connection-string with your MongoDB connection URL

Usage Examples

MongoDB Examples

List all collections in your database:

Can you show me all the collections in my database?

Get specific records from a collection:

Give me 2 records from the chargers collection

Query with filters:

Show me all documents in the users collection where status is active

Insert a document:

Add a new user to the users collection with name John and email john@example.com

Delete a document:

Remove the user with email john@example.com from the users collection

Aggregate data:

Show me the total count of users by status in the users collection

Available Tools

1. getCollections

Lists all collections in the connected database.

2. getCollection

Retrieves documents from a collection with optional query parameters:

collectionName: Name of the collection
limit: Maximum number of documents to return (default: 10, max: 1000)
query: MongoDB query object
projection: Fields to include/exclude

3. insertOne

Inserts a single document into a collection:

collectionName: Name of the collection
document: Document object to insert

4. deleteOne

Deletes a single document from a collection:

collectionName: Name of the collection
query: Query to match the document to delete

5. aggregate

Executes an aggregation pipeline:

collectionName: Name of the collection
pipeline: Array of aggregation stages
options: Optional aggregation options

Future Database Support

PostgreSQL

SQL query execution
Table operations
Schema management
Transaction support

CockroachDB

Distributed SQL operations
Multi-region support
Transaction management
Schema operations

Redis

Key-value operations
Caching mechanisms
Pub/sub operations
Data structure operations

Security

Never commit your database connection strings to version control
Use environment variables for sensitive information
Follow database-specific security best practices

Contributing

Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.

License

MIT License - See LICENSE for details

This server cannot be installed

security - not tested

license - permissive license

quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A Model Context Protocol server that enables LLMs to interact with databases (currently MongoDB) through natural language, supporting operations like querying, inserting, deleting documents, and running aggregation pipelines.

Related MCP Servers

MongoDB
QuantGeekDev
-
security
A
license
-
quality
A 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.
Last updated -
340
75
TypeScript
MIT License
MongoDB
kiliczsh
A
security
A
license
A
quality
A Model Context Protocol server that provides access to MongoDB databases. This server enables LLMs to inspect collection schemas and execute read-only queries.
Last updated -
8
885
191
TypeScript
MIT License
MCP Salesforce Connector
smn2gnt
A
security
A
license
A
quality
A Model Context Protocol server that enables LLMs to interact with Salesforce data through SOQL queries, SOSL searches, and various API operations including record management.
Last updated -
10
53
Python
MIT License
MongoDB MCP Server for LLMs
nickiiitu
-
security
A
license
-
quality
A Model Context Protocol server that enables LLMs to interact directly with MongoDB databases, allowing users to query collections, inspect schemas, and manage data through natural language.
Last updated -
340
TypeScript
MIT License

View all related MCP servers

MCP Database Server