mysql_mcp_server_pro

The mcp_mysql_server_pro is designed not only for standard MySQL CRUD operations but also incorporates features for database anomaly analysis, making it a powerful tool for developers. It supports various Model Context Protocol (MCP) transfer modes, including STDIO, SSE, and Streamable Http, ensuring flexibility in communication. Additionally, it offers OAuth2.0 support for secure authentication and allows multiple SQL executions in a single request, enhancing efficiency. Developers can leverage features such as querying database table names and fields based on comments, analyzing SQL execution plans, converting Chinese fields to pinyin, and conducting health status analyses of the database. The server also implements a robust permission control system with three distinct roles: readonly, writer, and admin, each with specific permissions. This allows for fine-grained access control, ensuring that users can only perform actions appropriate to their roles.

{
  "mcpServers": {
    "mysql-mcp-server-pro": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mysql-mcp-server-pro"
      ]
    }
  }
}