Zum Inhalt springen
Kitbay
MCP-Server

mysql-mcp-server-pro

Läuft lokalMITAktualisiert am 28. Aug. 2025249GitHub-SterneKann Daten ändernBraucht einen API-Key

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

Was er kann

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.

Funktionen

  • 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