MySQL Legacy MCP
Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
- Pricing
- Open source
- Runs
- Locally
- Version
- 0.2.1
- Listing updated
- 4 days ago
About MySQL Legacy MCP
MySQL Legacy MCP is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
Install
Run in a terminal
claude mcp add mysql-legacy-mcp --env MYSQL_LEGACY_HOST='<MYSQL_LEGACY_HOST>' --env MYSQL_LEGACY_USER='<MYSQL_LEGACY_USER>' --env MYSQL_LEGACY_PASSWORD='<MYSQL_LEGACY_PASSWORD>' -- npx -y mysql-legacy-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"mysql-legacy-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp"
],
"env": {
"MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
"MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
"MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mysql-legacy-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp"
],
"env": {
"MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
"MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
"MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"mysql-legacy-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp"
],
"env": {
"MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
"MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
"MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mysql-legacy-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp"
],
"env": {
"MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
"MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
"MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"mysql-legacy-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp"
],
"env": {
"MYSQL_LEGACY_HOST": "<MYSQL_LEGACY_HOST>",
"MYSQL_LEGACY_USER": "<MYSQL_LEGACY_USER>",
"MYSQL_LEGACY_PASSWORD": "<MYSQL_LEGACY_PASSWORD>"
}
}
}
}Configuration
MYSQL_LEGACY_HOSTDatabase host or local tunnel endpointRequiredMYSQL_LEGACY_USERDedicated database reader accountRequiredMYSQL_LEGACY_PASSWORDNonempty database account passwordRequiredMYSQL_LEGACY_PORTTCP port, 1–65535MYSQL_LEGACY_DATABASEOptional default databaseMYSQL_LEGACY_HIDE_SYSTEM_DATABASESHide mysql and information_schema from listingsMYSQL_LEGACY_QUERY_TIMEOUTDriver query timeout, 100–60000 millisecondsMYSQL_LEGACY_MAX_ROWSSELECT response row limit, 1–1000MYSQL_LEGACY_MAX_RESULT_BYTESSELECT row-data JSON byte limit, 1024–1048576MYSQL_LEGACY_CONNECT_TIMEOUTConnection-establishment timeout, 100–60000 millisecondsMYSQL_LEGACY_POOL_SIZEPooled connection limit, 1–50MYSQL_LEGACY_ALLOW_INSERTEnable the mysql_legacy_insert toolMYSQL_LEGACY_ALLOW_UPDATEEnable the mysql_legacy_update tool (WHERE clause always required)MYSQL_LEGACY_ALLOW_DELETEEnable the mysql_legacy_delete tool (WHERE clause always required)MYSQL_LEGACY_ALLOW_DDLEnable the mysql_legacy_ddl tool (table-level statements only)MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONSDisable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+
Pricing
Open source
MySQL Legacy MCP FAQ
Is MySQL Legacy MCP free?
Yes. MySQL Legacy MCP is open source, so you can use and self-host it for free.
How do I add MySQL Legacy MCP to Claude Code?
Run this command in your terminal: claude mcp add mysql-legacy-mcp --env MYSQL_LEGACY_HOST='<MYSQL_LEGACY_HOST>' --env MYSQL_LEGACY_USER='<MYSQL_LEGACY_USER>' --env MYSQL_LEGACY_PASSWORD='<MYSQL_LEGACY_PASSWORD>' -- npx -y mysql-legacy-mcp
What are the best alternatives to MySQL Legacy MCP?
The closest alternatives to MySQL Legacy MCP are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.
Alternatives to MySQL Legacy MCP

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

PlatypusDB
MCP serverGives MCP clients access to your PlatypusDB database connections, scoped per agent
Runs locally- Open source
- Databases

Lorebase
MCP serverLets agents read and change a governed, versioned Postgres knowledge graph
Runs locally- Open source
- Knowledge and memory
Sovaria
MCP serverManage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant
Not checked yet- 4 tools
- Remote
- Freemium
- Databases

model2data studio
MCP serverGenerate realistic connected test data, dbt projects and dashboards from a schema
- Remote
- Freemium
- Databases

semlayer
MCP serverInfers a semantic layer from your data warehouse and serves it to agents
Runs locally- Free
- Databases