wenb1n-dev/mysql_mcp_server_pro

3.9

Certified

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

Tools

Functions exposed to the LLM to take actions

execute_sql

在MySQL数据库上执行SQL (multiple SQL execution, separated by ';')

get_chinese_initials

创建表结构时，将中文字段名转换为拼音首字母字段

get_table_desc

根据表名搜索数据库中对应的表字段,支持多表查询(Search for table structures in the database based on table names, supporting multi-table queries)

get_table_index

根据表名搜索数据库中对应的表索引,支持多表查询(Search for table indexes in the database based on table names, supporting multi-table queries)

get_table_lock

获取当前mysql服务器行级锁、表级锁情况(Check if there are row-level locks or table-level locks in the current MySQL server )

get_table_name

根据表中文名或表描述搜索数据库中对应的表名(Search for table names in the database based on table comments and descriptions )

get_db_health_running

获取当前mysql的健康状态(Analyze MySQL health status )

get_db_health_index_usage

获取当前连接的mysql库的索引使用情况,包含冗余索引情况、性能较差的索引情况、未使用索引且查询时间大于30秒top5情况(Get the index usage of the currently connected mysql database, including redundant index situations, poorly performing index situations, and the top 5 unused index situations with query times greater than 30 seconds)

Prompts

Interactive templates invoked by user choice

analyzing-mysql-prompt

这是分析mysql相关问题的提示词

query-table-data-prompt

这是通过调用工具查询表数据的提示词

Resources

Contextual data attached and managed by the client

No resources

Author

wenb1n-dev

Claim Ownership

Verify you have write access to the repository

Version

v1.7.0

Repository

https://github.com/wenb1n-dev/mysql_mcp_server_pro

GitHub Stars

246

License

MIT License

Last publish date

2025-08-04

Last update date

2025-08-15

Server configs

in claude desktop

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "--from",
        "mysql_mcp_server_pro",
        "mysql_mcp_server_pro",
        "--mode",
        "stdio"
      ],
      "env": {
        "MYSQL_HOST": "192.168.x.xxx",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "root",
        "MYSQL_DATABASE": "a_llm",
        "MYSQL_ROLE": "admin"
      }
    }
  }
}

in vscode

{
  "mcpServers": {
    "mysql_mcp_server_pro": {
      "name": "mysql_mcp_server_pro",
      "type": "streamableHttp",
      "description": "",
      "isActive": true,
      "url": "http://localhost:3000/mcp/"
    }
  }
}

in cursor

{
  "mcpServers": {
    "mysql_mcp_server_pro": {
      "name": "mysql_mcp_server_pro",
      "description": "",
      "isActive": true,
      "url": "http://localhost:9000/sse"
    }
  }
}

in cline

{
  "mcpServers": {
      "operateMysql": {
        "isActive": true,
        "name": "operateMysql",
        "command": "uv",
        "args": [
          "--directory",
          "/Volumes/mysql_mcp_server_pro/src/mysql_mcp_server_pro",
          "run",
          "-m",
          "mysql_mcp_server_pro.server",
          "--mode",
          "stdio"
        ],
        "env": {
          "MYSQL_HOST": "localhost",
          "MYSQL_PORT": "3306",
          "MYSQL_USER": "root", 
          "MYSQL_PASSWORD": "123456",
          "MYSQL_DATABASE": "a_llm",
          "MYSQL_ROLE": "admin"
       }
    }
  }
}

Top Comments

Related MCP Servers

View all databases servers →

mcp-notion-server

4.4

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

wenb1n-dev/mysql_mcp_server_pro

Tools

execute_sql

get_chinese_initials

get_table_desc

get_table_index

get_table_lock

get_table_name

get_db_health_running

get_db_health_index_usage

Prompts

analyzing-mysql-prompt

query-table-data-prompt

Resources

No resources

Related MCP Servers

mcp-notion-server

mcp-pinecone

mcp-clickhouse

mcp-server-qdrant

mongodb-mcp-server

notion-mcp-server

prisma

genai-toolbox

mcp-memory-libsql

db-mcp-server

mcp-server

airtable-mcp

anyquery

mcp-server-mysql

mcp-databricks-server

mcp-proxy

chroma-mcp

openehr-mcp-server

mcp-server-motherduck

mcp-server-elasticsearch

mariadb-mcp-server

mcp-google-sheets

postg-mem

prometheus-mcp-server

xiyan_mcp_server

mcp-redis

mongo-mcp