mysql_mcp_server_pro

概述

mysql_mcp_server_pro 是一个功能强大的 MCP 服务器，不仅支持基础的 CRUD 操作，还提供了全面的数据库管理功能。它包含专门的 SQL 执行工具、中文字段名转换、健康状态分析、表锁检测和性能优化工具。服务器支持多种 MCP 传输模式（STDIO、SSE、Streamable Http），并实现了 OAuth2.0 认证，具有基于角色的权限控制（只读、写入、管理员）。此外，它还提供内置的提示模板，以增强与 MySQL 的交互体验。

试试问 AI

装完之后，这里有 5 个你可以让 AI 做的事：

• execute_sql

  SQL execution tool that can execute various SQL commands based on permission configuration

  试试:Execute SELECT * FROM users试试:Create a new table called products试试:Show all tables in the database
• get_chinese_initials

  Convert Chinese field names to pinyin initials

  试试:Convert '客户姓名' to pinyin initials试试:Get pinyin for '部门编号'
• get_db_health_running

  Analyze MySQL health status including connection, transaction, and lock status

  试试:Check MySQL health status试试:Show current transaction status试试:Detect any lock issues
• get_table_desc

  Search for table structures in the database based on table names

  试试:Show structure of users table试试:Describe columns in products table试试:Get schema for orders and customers tables
• get_table_index

  Search for table indexes in the database based on table names

  试试:Show indexes on users table试试:List all indexes in products table试试:Get index information for orders table
• get_table_lock

  Check for row-level or table-level locks in the MySQL server

  试试:Check for table locks试试:Show current lock status试试:Detect any row locks
• get_table_name

  Search for table names in the database based on table comments and descriptions

  试试:Find tables with 'customer' in comments试试:Search for tables related to 'orders'试试:List tables with 'product' description
• get_db_health_index_usage

  Get index usage statistics including redundant and poorly performing indexes

  试试:Show index usage statistics试试:List unused indexes试试:Check for redundant indexes
• optimize_sql

  Provide SQL optimization suggestions based on execution plans and table structure

  试试:Optimize this query: SELECT * FROM users WHERE name = 'John'试试:Review execution plan for slow query试试:Suggest improvements for SELECT * FROM large_table
• use_prompt_queryTableData

  Use built-in prompts to construct tool chains for querying table data

  试试:Use prompt template to get customer data试试:Query table data using built-in prompt试试:Get product information using template

可对比工具

安装

pip install mysql_mcp_server_pro

MYSQL_HOST=localhost
MYSQL_PORT=3306
MYSQL_USER=your_username
MYSQL_PASSWORD=your_password
MYSQL_DATABASE=your_database
MYSQL_ROLE=readonly # 或 writer, admin

# SSE 模式
mysql_mcp_server_pro --mode sse --envfile /path/to/.env

# Streamable Http 模式（默认）
mysql_mcp_server_pro --envfile /path/to/.env

# 带 OAuth 认证
mysql_mcp_server_pro --oauth true

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "MYSQL_HOST": "your_host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database",
        "MYSQL_ROLE": "admin"
      }
    }
  }
}

FAQ

此 MCP 服务器支持哪些身份验证方法？

服务器支持使用环境变量的基本身份验证和基于令牌的 OAuth2.0 身份验证。

如何使用自定义工具扩展服务器？

您可以在 handles 包中添加新的工具类，继承自 BaseHandler，并实现 get_tool_description 和 run_tool 方法，然后在 __init__.py 中导入它。

mysql_mcp_server_pro 对比