Overview
What is MCP-MongoDB-MySQL-Server?
MCP-MongoDB-MySQL-Server is a Model Context Protocol server that provides MySQL and MongoDB database operations. It enables AI models to interact with both MySQL and MongoDB databases through a standardized interface. This is a fork of enemyrr/mcp-mysql-server with added MongoDB support for applications requiring both relational and document databases.
How to use MCP-MongoDB-MySQL-Server?
Install via Smithery (npx -y @smithery/cli install @yaoxiaolinglong/mcp-mongodb-mysql-server --client claude) or clone and build manually (git clone, npm install, npm run build). For Cursor IDE, add a server with type command and command node /absolute/path/to/mcp-mongodb-mysql-server/build/index.js. Configure databases via .env files (e.g., DATABASE_URL, MONGODB_URI) or by passing credentials directly to the connect_db or connect_mongodb tools.
Key features of MCP-MongoDB-MySQL-Server
- Multiple connection methods: URL, workspace file, or direct parameters.
- Support for both MySQL and MongoDB databases in one server.
- Prepared statement support for MySQL queries to prevent SQL injection.
- Schema management tools: create tables, add columns, list collections.
- Secure connection handling with automatic cleanup.
- Comprehensive error handling and validation for database operations.
Use cases of MCP-MongoDB-MySQL-Server
- Query and update MySQL tables (e.g., user profiles, inventory) via AI assistants.
- Perform CRUD operations on MongoDB collections (e.g., logs, product catalogs).
- Manage database schemas: create MySQL tables or MongoDB collections on the fly.
- Connect AI agents to existing databases using environment variables or runtime credentials.
FAQ from MCP-MongoDB-MySQL-Server
How do I configure database connections?
You can configure via .env file using DATABASE_URL for MySQL and MONGODB_URI with MONGODB_DATABASE for MongoDB, or pass credentials directly to the connect_db and connect_mongodb tools.
What MySQL tools are available?
The server provides connect_db, query, execute, list_tables, describe_table, create_table, and add_column tools for MySQL interaction.
What MongoDB tools are available?
The server provides connect_mongodb, mongodb_list_collections, mongodb_find, mongodb_insert, mongodb_update, mongodb_delete, and mongodb_create_collection tools.
How do I install the server for use with Claude Desktop?
Use the Smithery command: npx -y @smithery/cli install @yaoxiaolinglong/mcp-mongodb-mysql-server --client claude. This automates installation for Claude Desktop.
How does the server handle security?
It uses prepared statements for MySQL queries to prevent SQL injection, supports secure password handling through environment variables, validates queries and operations before execution, and automatically closes connections when done.
