Skip to content
Kitbay
MCP server

mysql-mcp-server-pro

Runs locallyMITUpdated on Aug 28, 2025249GitHub starsCan change dataNeeds an API key

A Python MCP server for MySQL that adds diagnostics to ordinary queries.

What it does

A Python MCP server for MySQL that adds diagnostics to ordinary queries. Besides running SQL, including several statements at once, it finds tables from their comments, describes table structures and indexes, checks for row and table locks, reports on database health and index usage, and suggests SQL optimisations from execution plans. One tool converts Chinese field names to pinyin initials. Access is controlled by a role setting: read-only, writer, or admin, which also allows creating, altering and dropping tables. It supports stdio, SSE and Streamable HTTP, optionally with OAuth 2.0, and developers can add their own tools.

Capabilities

  • Run SQL with read-only, writer or admin permissions
  • Describe tables and indexes
  • Detect row and table locks
  • Analyse database health and index usage
  • Suggest SQL optimisations from execution plans