Python Mysql MCP Server

MySQL MCP Server

English | 中文

English

A MySQL database server based on MCP (Model Context Protocol) that provides database operation capabilities for Cursor IDE.

✨ Features

• 🔍 Data Querying: Execute SELECT queries with formatted results
• ✏️ Data Modification: Support INSERT, UPDATE, DELETE operations
• 🏗️ Schema Management: Create tables, add columns, view table structures
• 📊 Metadata Operations: List databases and tables, describe table structures
• 🔒 Security: Database connection configured through environment variables
• 🚀 Easy Integration: Seamless integration with Cursor IDE via MCP protocol

📋 Prerequisites

• Python 3.7+
• MySQL 5.7+ or 8.0+
• Cursor IDE with MCP support

🚀 Installation & Setup

1. Install Dependencies

pip install -r requirements.txt

2. Configure Database Connection

Copy the example configuration file:

cp mcp-config.example.json mcp-config.json

Edit mcp-config.json with your database connection details:

{
  "mcpServers": {
    "mysql-server": {
      "command": "python",
      "args": ["mysql_mcp_server.py"],
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_PORT": "3306",
        "MYSQL_DATABASE": "your-database-name",
        "MYSQL_USER": "your-username",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_CHARSET": "utf8mb4"
      }
    }
  }
}

3. Cursor IDE Integration

Add the MCP server configuration to Cursor settings:

1. Open Cursor Settings
2. Search for "MCP"
3. Add your mcp-config.json configuration to MCP server settings

🛠️ Available Tools

🔧 Environment Variables

🔒 Security Features

• 🔐 Database credentials passed via environment variables
• 🛡️ Only safe SQL operation types allowed
• ⚠️ Query result limits to prevent large data output
• 🔍 Basic security checks for all SQL operations

🐛 Development & Testing

Run the server directly for testing:

# Set environment variables
export MYSQL_HOST="your-host"
export MYSQL_USER="your-user"
export MYSQL_PASSWORD="your-password" 
export MYSQL_DATABASE="your-database"

# Run server
python mysql_mcp_server.py

📄 License

MIT License

🤝 Contributing

Issues and Pull Requests are welcome!

中文

一个基于 MCP (Model Context Protocol) 的 MySQL 数据库服务器，为 Cursor IDE 提供数据库操作功能。

✨ 功能特性

• 🔍 数据查询: 执行 SELECT 查询并格式化返回结果
• ✏️ 数据修改: 支持 INSERT, UPDATE, DELETE 操作
• 🏗️ 结构管理: 创建表、添加列、查看表结构
• 📊 元数据查看: 列出数据库、表，查看表结构
• 🔒 安全控制: 通过环境变量配置数据库连接信息
• 🚀 轻松集成: 通过 MCP 协议无缝集成到 Cursor IDE

📋 环境要求

• Python 3.7+
• MySQL 5.7+ 或 8.0+
• 支持 MCP 的 Cursor IDE

🚀 安装配置

1. 安装依赖

pip install -r requirements.txt

2. 配置数据库连接

复制配置示例文件：

cp mcp-config.example.json mcp-config.json

编辑 mcp-config.json 文件，填入您的数据库连接信息：

{
  "mcpServers": {
    "mysql-server": {
      "command": "python", // 可以用项目的绝对路径 如 : /Users/baozi/python-mysql-mcp-server/venv/bin/python
      "args": ["mysql_mcp_server.py"],  // 这里也是,如 : /Users/baozi/python-mysql-mcp-server/mysql_mcp_server.py
      "env": {
        "MYSQL_HOST": "your-mysql-host",
        "MYSQL_PORT": "3306",
        "MYSQL_DATABASE": "your-database-name",
        "MYSQL_USER": "your-username",
        "MYSQL_PASSWORD": "your-password",
        "MYSQL_CHARSET": "utf8mb4"
      }
    }
  }
}

3. Cursor IDE 集成

将 MCP 服务器配置添加到 Cursor 的设置中：

1. 打开 Cursor 设置 (Settings)
2. 搜索 "MCP"
3. 在 MCP 服务器配置中添加您的 mcp-config.json 配置

🛠️ 可用工具

🔧 环境变量说明

🔒 安全注意事项

• 🔐 数据库凭据通过环境变量传递，避免硬编码
• 🛡️ 只允许安全的 SQL 操作类型
• ⚠️ 查询结果有行数限制，防止大量数据输出
• 🔍 所有 SQL 操作都会进行基本的安全检查

🐛 开发和调试

直接运行服务器进行测试：

# 设置环境变量
export MYSQL_HOST="your-host"
export MYSQL_USER="your-user"
export MYSQL_PASSWORD="your-password"
export MYSQL_DATABASE="your-database"

# 运行服务器
python mysql_mcp_server.py

📄 许可证

MIT License

🤝 贡献

欢迎提交 Issue 和 Pull Request！