本文へスキップ
Kitbay
MCPサーバー

mysql-mcp-server-pro

ローカルで動作MIT2025年8月28日 更新249GitHubスターデータ変更可APIキーが必要

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

このサーバーについて

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.

できること

  • 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