广告合作
MCP.so
登录

MCP Mysql Server

@xwb602625136

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

xwb602625136

关于 MCP Mysql Server

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

MCP Mysql Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

MCP Mysql Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is mcp_mysql_server_pro?

mcp_mysql_server_pro is an MCP server for MySQL database operations that offers CRUD functionality, database anomaly analysis, and customizable tools. It supports all MCP transport modes (STDIO, SSE, Streamable Http), OAuth2.0, and role-based permissions, making it suitable for developers who need AI-driven database management and performance diagnostics.

How to use mcp_mysql_server_pro?

Install via pip (pip install mysql_mcp_server_pro), configure a .env file with MySQL credentials (host, port, user, password, database, optional role). Run the service using mysql_mcp_server_pro --mode sse --envfile /path/to/.env for SSE mode, or use the default Streamable Http mode. For client integration, configure MCP JSON with command uvx --from mysql_mcp_server_pro mysql_mcp_server_pro --mode stdio and set environment variables.

Key features of mcp_mysql_server_pro

  • Supports all MCP transfer modes (STDIO, SSE, Streamable Http)
  • Includes SQL execution, health analysis, lock detection, and index usage tools
  • Provides permission control with readonly, writer, and admin roles
  • Supports OAuth2.0 authentication for secure access
  • Allows custom tool extension by adding new handler classes
  • Converts Chinese field names to pinyin initials

Use cases of mcp_mysql_server_pro

  • Create a table with comments and indexes, then insert data via natural language prompts
  • Query data by table comments and descriptions to locate relevant tables quickly
  • Analyze slow SQL execution plans and receive optimization suggestions in markdown
  • Diagnose database deadlock or lock contention issues using tool outputs
  • Monitor overall database health including connection status, transactions, and running state

FAQ from mcp_mysql_server_pro

What transport modes

评论

数据库 分类下的更多 MCP 服务器

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

广告合作