mcp_mysql_server

Name: mcp_mysql_server
Author: xwb602625136

@xwb602625136

About mcp_mysql_server

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

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Comments

Basic information

More Databases MCP servers

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi