Happy slice of mcp pizzaMCP.pizza

mysql_mcp_server_pro

MCP.Pizza Chef: wenb1n-dev

Built for MySQL, this one answers questions about your tables in plain English, finds a table when you only remember what it stores, explains why a slow lookup is slow, and reports on locks, connections and indexes nobody uses. Out of the box it is limited to reading; changing or deleting rows requires deliberately switching it to a higher permission level. You supply the database address and login, and you need a MySQL server you can already reach. The last code change was August 2025.

Unmaintained · no code changes since August 2025, roughly a year
Coding
Data

Use This MCP server To

Ask a question about my data without writing the query myself Find the right table when I only remember what it holds Work out why one screen in my app got so slow Check whether something is locking up the database right now Spot indexes nobody uses that are wasting space Get a plain-English health check on a live database

README

简体中文 English MseeP.ai Security Assessment Badge MCPHub

mcp_mysql_server_pro

Introduction

mcp_mysql_server_pro is not just about MySQL CRUD operations, but also includes database anomaly analysis capabilities and makes it easy for developers to extend with custom tools.

  • Supports all Model Context Protocol (MCP) transfer modes (STDIO, SSE, Streamable Http)
  • Supports OAuth2.0
  • Supports multiple SQL execution, separated by ";"
  • Supports querying database table names and fields based on table comments
  • Supports SQL execution plan analysis
  • Supports Chinese field to pinyin conversion
  • Supports table lock analysis
  • Supports database health status analysis
  • Supports permission control with three roles: readonly, writer, and admin 
    "readonly": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN"],  # Read-only permissions
"writer": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE"],  # Read-write permissions
"admin": ["SELECT", "SHOW", "DESCRIBE", "EXPLAIN", "INSERT", "UPDATE", "DELETE", 
         "CREATE", "ALTER", "DROP", "TRUNCATE"]  # Administrator permissions
  • Supports prompt template invocation

Tool List

mysql_mcp_server_pro FAQ

Is this still being maintained?
There have been no code changes since August 2025. The project is not shut down and still installs, but nothing new has landed in roughly a year.
Can it delete or overwrite my data?
Not unless you let it. It starts in a read-only mode, and writing or deleting only becomes possible if you deliberately raise its permission level in the settings.
Do I need a paid key?
No. You do need a MySQL database you can already reach plus its login details, which you paste into the setup block.
Can I use this to answer a question about my own records?
Yes — ask in plain language, and it works out which tables to look at and reports the answer back.
Which apps does it work in?
Cline, Cursor and Trae are named in the instructions, and it works with other apps that accept a standard MCP setup snippet.
How hard is setup?
This one is for technical users. You need Python, a running MySQL server, and database credentials before anything works.
Is it safe to point at a live business database?
Keep the default read-only mode and give it a login that can only see what it needs. That combination limits the damage a mistaken instruction can do.
Is the documentation in English?
Yes, an English readme sits alongside the Chinese original.