Advertise
MCP.so
Sign In

MCP Mysql Server

@xwb602625136

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

xwb602625136

About MCP Mysql Server

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

MCP Mysql Server 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": ""
      }
    }
  }
}

MCP Mysql Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

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

More Databases MCP servers

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Database Gateway

centralmind

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

531
Advertise