The MCP-MongoDB-MySQL-Server provides a Model Context Protocol interface to interact with both MySQL and MongoDB databases through a standardized interface.

MySQL Capabilities:

• Connect using URL, credentials, or workspace environment variables

• Execute queries (SELECT, INSERT, UPDATE, DELETE)

• Manage tables (create, describe, list, add columns)

• Uses prepared statements to prevent SQL injection

MongoDB Capabilities:

• Connect using URL, database name, or workspace environment variables

• Perform CRUD operations (find, insert, update, delete)

• List and create collections

• Support for filters, limits, skips, and sorting

General Features:

• Secure connection handling and credential management

• Comprehensive error handling and validation

• TypeScript compatibility

• Automatic connection cleanup

Supports secure database configuration through environment variables, allowing database credentials and connection strings to be stored in .env files for both MySQL and MongoDB connections.

Provides comprehensive MongoDB database operations including connecting to databases, listing collections, querying documents with filters and sorting, inserting new documents, updating existing records, deleting data, and creating new collections with custom options.

Enables complete MySQL database management with tools for executing queries, performing data modifications, listing and describing tables, creating new tables with custom fields and indexes, and adding columns to existing tables using prepared statements for security.

1. Click on "Install Server".

2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.

3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MCP-MongoDB-MySQL-Server show me the top 5 customers by total purchases from the orders table"

That's it! The server will respond to your query, and you can continue using it as needed.

Here is a step-by-step guide with screenshots.

npx -y @smithery/cli install @yaoxiaolinglong/mcp-mongodb-mysql-server --client claude

git clone https://github.com/yaoxiaolinglong/mcp-mongodb-mysql-server.git
cd mcp-mongodb-mysql-server
npm install
npm run build

DATABASE_URL=mysql://user:password@host:3306/database

DB_HOST=localhost
DB_USER=your_user
DB_PASSWORD=your_password
DB_DATABASE=your_database

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "connect_db",
 arguments: {
 url: "mysql://user:password@host:3306/database"
 // 或者 | OR
 workspace: "/path/to/your/project" // 将使用项目的.env文件 | Will use project's .env
 // 或者 | OR
 host: "localhost",
 user: "your_user",
 password: "your_password",
 database: "your_database"
 }
});

MONGODB_URI=mongodb://user:password@host:27017/database
MONGODB_DATABASE=your_database

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "connect_mongodb",
 arguments: {
 url: "mongodb://user:password@host:27017/database"
 // 或者 | OR
 workspace: "/path/to/your/project" // 将使用项目的.env文件 | Will use project's .env
 // 或者 | OR
 database: "your_database" // 将使用默认连接URI | Will use default connection URI
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "query",
 arguments: {
 sql: "SELECT * FROM users WHERE id = ?",
 params: [1]
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "execute",
 arguments: {
 sql: "INSERT INTO users (name, email) VALUES (?, ?)",
 params: ["John Doe", "john@example.com"]
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "list_tables"
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "describe_table",
 arguments: {
 table: "users"
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "create_table",
 arguments: {
 table: "users",
 fields: [
 {
 name: "id",
 type: "int",
 autoIncrement: true,
 primary: true
 },
 {
 name: "email",
 type: "varchar",
 length: 255,
 nullable: false
 }
 ],
 indexes: [
 {
 name: "email_idx",
 columns: ["email"],
 unique: true
 }
 ]
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "add_column",
 arguments: {
 table: "users",
 field: {
 name: "phone",
 type: "varchar",
 length: 20,
 nullable: true
 }
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "connect_mongodb",
 arguments: {
 url: "mongodb://user:password@host:27017/database"
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "mongodb_list_collections"
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "mongodb_find",
 arguments: {
 collection: "users",
 filter: { age: { $gt: 18 } },
 limit: 10,
 skip: 0,
 sort: { name: 1 }
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "mongodb_insert",
 arguments: {
 collection: "users",
 documents: [
 { name: "John Doe", email: "john@example.com", age: 30 },
 { name: "Jane Smith", email: "jane@example.com", age: 25 }
 ]
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "mongodb_update",
 arguments: {
 collection: "users",
 filter: { name: "John Doe" },
 update: { $set: { age: 31 } },
 many: false // 只更新一个文档（默认）| Update only one document (default)
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "mongodb_delete",
 arguments: {
 collection: "users",
 filter: { name: "John Doe" },
 many: false // 只删除一个文档（默认）| Delete only one document (default)
 }
});

use_mcp_tool({
 server_name: "mysql-mongodb",
 tool_name: "mongodb_create_collection",
 arguments: {
 collection: "new_collection",
 options: { capped: true, size: 1000000 }
 }
});