wenb1n-dev/mysql_mcp_server_pro

开发工具

本页由 AI 翻译，技术细节请以原文为准。查看原文

250 stars 45 forks 质量 70 趋势 18MIT

Repository Install

wenb1n-dev/mysql_mcp_server_pro 是从 https://github.com/wenb1n-dev/mysql_mcp_server_pro. 导入的 MCP 服务器候选

概览

wenb1n-dev/mysql_mcp_server_pro 是从 https://github.com/wenb1n-dev/mysql_mcp_server_pro. 导入的 MCP 服务器候选

概述（AI 翻译）

引言

mcp_mysql_server_pro不仅仅涉及MySQL CRUD操作，还包含数据库异常分析功能，并便于开发者通过定制工具进行扩展。

支持所有模型上下文协议（MCP）传输模式（STDIO、SSE、可流式Http）
支持 OAuth2.0
支持多个SQL执行，中间以“;”分隔。
支持基于表注释查询数据库表名称和字段
支持SQL执行计划分析
支持中文田野转拼音
支持表锁分析
支持数据库健康状态分析
支持三种权限控制：只读、写入和管理员
支持提示模板调用

工具清单

工具名称	说明

本页由 AI 翻译，技术细节请以原文为准。

README

以下为原文 README 节选，完整内容请查看原文。

mcp_mysql_server_pro

Introduction

mcp_mysql_server_pro is not just about MySQL CRUD operations, but also includes database anomaly analysis capabilities and makes it easy for developers to extend with custom tools.

Supports all Model Context Protocol (MCP) transfer modes (STDIO, SSE, Streamable Http)
Supports OAuth2.0
Supports multiple SQL execution, separated by “;”
Supports querying database table names and fields based on table comments
Supports SQL execution plan analysis
Supports Chinese field to pinyin conversion
Supports table lock analysis
Supports database health status analysis

Supports permission control with three roles: readonly, writer, and admin

"readonly": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN"],  # Read-only permissions
"writer": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE"],  # Read-write permissions
"admin": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", 
         "CREATE", "ALTER", "DROP", "TRUNCATE"]  # Administrator permissions

Supports prompt template invocation

Tool List

Tool Name	Description
execute_sql	SQL execution tool that can execute [“SELECT”, “SHOW”, “DESCRIBE”, “EXPLAIN”, “INSERT”, “UPDATE”, “DELETE”, “CREATE”, “ALTER”, “DROP”, “TRUNCATE”] commands based on permission configuration
get_chinese_initials	Convert Chinese field names to pinyin initials
get_db_health_running	Analyze MySQL health status (connection status, transaction status, running status, lock status detection)

在 GitHub 查看完整 README

安装

uvx --from mysql_mcp_server_pro mysql_mcp_server_pro --mode stdio

新手？先看 mcpskill.org 教程 →

配置

{
	"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"
			}
		}
	}
}