Pular para o conteúdo
Kitbay
Servidor MCP

mysql-mcp-server-pro

Roda localmenteMITAtualizado em 28 de ago. de 2025249Estrelas no GitHubPode alterar dadosExige chave de API

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

Resumo

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.

O que faz

  • 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