Yaoxiaolinglong MCP Mongodb Mysql Server

🚀 MCP-MongoDB-MySQL Server

The MCP-MongoDB-MySQL Server is a powerful tool that enables simultaneous connections to both MongoDB and MySQL databases. It offers a wide range of features, including database connection management, query execution, and schema operations.

🚀 Quick Start

Installation

The installation steps are as follows:

1. Download the source code: git clone https://github.com/yaoxiaolinglong/mcp-mongodb-mysql-server.git
2. Install dependencies: Run npm install in the project root directory.
3. Start the server: Use the command node index.js or npm start.

Configuration

MySQL Connection Parameters

{
  mysql: {
    connectionLimit: 10,
    host: 'localhost',
    port: 3306,
    user: 'root',
    password: 'password'
  }
}

MongoDB Connection Parameters

{
  mongodb: {
    url: 'mongodb://localhost:27017',
    dbName: 'mydb',
    options: {
      useNewUrlParser: true,
      useUnifiedTopology: true
    }
  }
}

✨ Features

• Multiple Connection Methods: Supports connections via URL, workspace, or direct parameters.
• Dual Database Compatibility: Supports both MySQL and MongoDB databases simultaneously.
• Security Measures: Uses prepared statements to prevent SQL injection and supports secure password management through environment variables.
• Schema Management Tools: Provides comprehensive query validation and error handling capabilities.

💻 Usage Examples

Execute a MySQL Query

{
  "mysql": {
    "command": "query",
    "database": "mydb",
    "sql": "SELECT * FROM users WHERE id = ?",
    "params": [123]
  }
}

Insert a MongoDB Document

{
  "mongodb": {
    "command": "insert",
    "collection": "users",
    "documents": [
      { "name": "John Doe", "email": "john@example.com" },
      { "name": "Jane Smith", "email": "jane@example.com" }
    ]
  }
}

🤝 Contributing

We welcome all developers to actively participate in the development and improvement of this project. Please visit the GitHub repository to submit your Pull Requests.

Thanks to the enemyrr/mcp-mysql-server project and the original author for their contributions.

📄 License

This project is open-source under the MIT License.