Rufflet/mysql-legacy-mcp

Overview

MCP server for legacy MySQL 5.0–5.6. Provides schema inspection and SELECT queries by default, with INSERT, UPDATE, DELETE, and DDL available as opt-in. Live-verified against MySQL 5.0 through 8.0.

Best for

Best for
Developers maintaining legacy MySQL databases who need safe MCP access

Use cases

• Inspect schemas on legacy MySQL databases
• Run read-only SELECT queries via MCP
• Enable write operations when explicitly configured

How to use

Tools exposed

• mysql-legacy-mcp
• mysql_legacy_ping
• mysql_legacy_select
• mysql_legacy_insert
• mysql_legacy_update
• mysql_legacy_delete
• mysql_legacy_ddl
• mysql_legacy_list_databases
• mysql_legacy_list_tables
• mysql_legacy_describe_table
• mysql_legacy_show_create_table
• mysql_legacy_list_indexes

Tested with

Claude Desktop, Claude Code, Cursor, Windsurf, VS Code

Notes

MCP server for legacy MySQL 5.0–5.6. Provides schema inspection and SELECT queries by default, with INSERT, UPDATE, DELETE, and DDL available as opt-in. Live-verified against MySQL 5.0 through 8.0.

0 stars on GitHub. Last updated 2026-09-15. Licensed MIT.

Use cases

• Inspect schemas on legacy MySQL databases
• Run read-only SELECT queries via MCP
• Enable write operations when explicitly configured

Pros

• Supports very old MySQL versions (5.0+)
• Read-only by default, safer for production
• Verified across MySQL 5.0 to 8.0

Cons

• No community traction yet (0 stars)
• Write operations require explicit opt-in
• Legacy focus may not cover newer MySQL features

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.