DatabasePython

mysql_mcp_server_pro

This MCP server facilitates secure interactions with MySQL databases while providing advanced anomaly analysis capabilities.

Free
N/A rating (0 reviews)0 installs281 GitHub stars
MySQLMCPAnomaly Analysis
Local ProcessRuns locally on your machine via stdio. Lower risk than remote servers.

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.

Compatible with

Claude DesktopCursor

Install

Claude Desktop

No verified install config available for this server.

View install instructions on GitHub ->

Config File Location

Mac: ~/Library/Application Support/Claude/claude_desktop_config.json

Windows: %APPDATA%\Claude\claude_desktop_config.json

Linux: ~/.config/claude/claude_desktop_config.json

Some servers require additional setup - check the GitHub README for specific instructions.

Permissions

ok0
ok1

Reviews

Sign in to review

Loading reviews...

Credentials

Store API keys for mysql_mcp_server_pro securely

Loading...