What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the MySQL Legacy MCP MCP server?
Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
How to install MySQL Legacy MCP
Copy-paste configuration for popular MCP clients.
MYSQL_LEGACY_HOSTrequiredDatabase host or local tunnel endpoint
MYSQL_LEGACY_USERrequiredDedicated database reader account
MYSQL_LEGACY_PASSWORDrequiredsecretNonempty database account password
MYSQL_LEGACY_PORTTCP port, 1–65535
MYSQL_LEGACY_DATABASEOptional default database
MYSQL_LEGACY_HIDE_SYSTEM_DATABASESHide mysql and information_schema from listings
MYSQL_LEGACY_QUERY_TIMEOUTDriver query timeout, 100–60000 milliseconds
MYSQL_LEGACY_MAX_ROWSSELECT response row limit, 1–1000
MYSQL_LEGACY_MAX_RESULT_BYTESSELECT row-data JSON byte limit, 1024–1048576
MYSQL_LEGACY_CONNECT_TIMEOUTConnection-establishment timeout, 100–60000 milliseconds
MYSQL_LEGACY_POOL_SIZEPooled connection limit, 1–50
MYSQL_LEGACY_ALLOW_INSERTEnable the mysql_legacy_insert tool
MYSQL_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+
{
"mcpServers": {
"mysql-legacy-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-legacy-mcp"
],
"env": {
"MYSQL_LEGACY_HOST": "<YOUR_MYSQL_LEGACY_HOST>",
"MYSQL_LEGACY_USER": "<YOUR_MYSQL_LEGACY_USER>",
"MYSQL_LEGACY_PASSWORD": "<YOUR_MYSQL_LEGACY_PASSWORD>",
"MYSQL_LEGACY_PORT": "<YOUR_MYSQL_LEGACY_PORT>",
"MYSQL_LEGACY_DATABASE": "<YOUR_MYSQL_LEGACY_DATABASE>",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<YOUR_MYSQL_LEGACY_HIDE_SYSTEM_DATABASES>",
"MYSQL_LEGACY_QUERY_TIMEOUT": "<YOUR_MYSQL_LEGACY_QUERY_TIMEOUT>",
"MYSQL_LEGACY_MAX_ROWS": "<YOUR_MYSQL_LEGACY_MAX_ROWS>",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "<YOUR_MYSQL_LEGACY_MAX_RESULT_BYTES>",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "<YOUR_MYSQL_LEGACY_CONNECT_TIMEOUT>",
"MYSQL_LEGACY_POOL_SIZE": "<YOUR_MYSQL_LEGACY_POOL_SIZE>",
"MYSQL_LEGACY_ALLOW_INSERT": "<YOUR_MYSQL_LEGACY_ALLOW_INSERT>",
"MYSQL_LEGACY_ALLOW_UPDATE": "<YOUR_MYSQL_LEGACY_ALLOW_UPDATE>",
"MYSQL_LEGACY_ALLOW_DELETE": "<YOUR_MYSQL_LEGACY_ALLOW_DELETE>",
"MYSQL_LEGACY_ALLOW_DDL": "<YOUR_MYSQL_LEGACY_ALLOW_DDL>",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<YOUR_MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS>"
}
}
}
}Related MCP servers

io.github.RyanKramer/wisegrid-mcp
Read and write WiseGrid sheets, rows, columns and reports from any AI agent.
MCP server for Ryvo Gateway x402, Helius Wallet, and Tokens API market data.
View repository →
longpath
Read-only P6 / MS Project schedule analysis: CPM, float, DCMA 14-point, logic checks, S-curves.

sqlglass
SQL Server / Azure SQL for agents: real schema, lint, read-only runs, plans, write previews.

Assay MCP Server
Policy-enforcing MCP proxy with portable evidence output.

Indexes your project's markdown docs and serves them to any agent via local hybrid search.
