Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
To add MySQL Legacy MCP to Claude, run the install command below or copy the ready-made config for Claude Code, Claude Desktop, Cursor and VS Code further down. Restart your client after adding it and its tools show up in your next conversation. It needs 16 environment variables, listed below.
Install
npx -y mysql-legacy-mcp@0.2.1Environment variables
MYSQL_LEGACY_HOSTSet in your MCP configMYSQL_LEGACY_USERSet in your MCP configMYSQL_LEGACY_PASSWORDSet in your MCP configMYSQL_LEGACY_PORTSet in your MCP configMYSQL_LEGACY_DATABASESet in your MCP configMYSQL_LEGACY_HIDE_SYSTEM_DATABASESSet in your MCP configMYSQL_LEGACY_QUERY_TIMEOUTSet in your MCP configMYSQL_LEGACY_MAX_ROWSSet in your MCP configMYSQL_LEGACY_MAX_RESULT_BYTESSet in your MCP configMYSQL_LEGACY_CONNECT_TIMEOUTSet in your MCP configMYSQL_LEGACY_POOL_SIZESet in your MCP configMYSQL_LEGACY_ALLOW_INSERTSet in your MCP configMYSQL_LEGACY_ALLOW_UPDATESet in your MCP configMYSQL_LEGACY_ALLOW_DELETESet in your MCP configMYSQL_LEGACY_ALLOW_DDLSet in your MCP configMYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONSSet in your MCP configInstall with your client
claude mcp add mysql-legacy --env MYSQL_LEGACY_HOST=<YOUR_MYSQL_LEGACY_HOST> --env MYSQL_LEGACY_USER=<YOUR_MYSQL_LEGACY_USER> --env MYSQL_LEGACY_PASSWORD=<YOUR_MYSQL_LEGACY_PASSWORD> --env MYSQL_LEGACY_PORT=<YOUR_MYSQL_LEGACY_PORT> --env MYSQL_LEGACY_DATABASE=<YOUR_MYSQL_LEGACY_DATABASE> --env MYSQL_LEGACY_HIDE_SYSTEM_DATABASES=<YOUR_MYSQL_LEGACY_HIDE_SYSTEM_DATABASES> --env MYSQL_LEGACY_QUERY_TIMEOUT=<YOUR_MYSQL_LEGACY_QUERY_TIMEOUT> --env MYSQL_LEGACY_MAX_ROWS=<YOUR_MYSQL_LEGACY_MAX_ROWS> --env MYSQL_LEGACY_MAX_RESULT_BYTES=<YOUR_MYSQL_LEGACY_MAX_RESULT_BYTES> --env MYSQL_LEGACY_CONNECT_TIMEOUT=<YOUR_MYSQL_LEGACY_CONNECT_TIMEOUT> --env MYSQL_LEGACY_POOL_SIZE=<YOUR_MYSQL_LEGACY_POOL_SIZE> --env MYSQL_LEGACY_ALLOW_INSERT=<YOUR_MYSQL_LEGACY_ALLOW_INSERT> --env MYSQL_LEGACY_ALLOW_UPDATE=<YOUR_MYSQL_LEGACY_ALLOW_UPDATE> --env MYSQL_LEGACY_ALLOW_DELETE=<YOUR_MYSQL_LEGACY_ALLOW_DELETE> --env MYSQL_LEGACY_ALLOW_DDL=<YOUR_MYSQL_LEGACY_ALLOW_DDL> --env MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS=<YOUR_MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS> -- npx -y mysql-legacy-mcp@0.2.1
Run this in a terminal to add the server to Claude Code.
What this does
MySQL Legacy MCP exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation.
Requirements
This server needs the following environment variables to be set before it can run:
MYSQL_LEGACY_HOST MYSQL_LEGACY_USER MYSQL_LEGACY_PASSWORD MYSQL_LEGACY_PORT MYSQL_LEGACY_DATABASE MYSQL_LEGACY_HIDE_SYSTEM_DATABASES MYSQL_LEGACY_QUERY_TIMEOUT MYSQL_LEGACY_MAX_ROWS MYSQL_LEGACY_MAX_RESULT_BYTES MYSQL_LEGACY_CONNECT_TIMEOUT MYSQL_LEGACY_POOL_SIZE MYSQL_LEGACY_ALLOW_INSERT MYSQL_LEGACY_ALLOW_UPDATE MYSQL_LEGACY_ALLOW_DELETE MYSQL_LEGACY_ALLOW_DDL MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Frequently asked questions
How do I install MySQL Legacy MCP?
Run the Claude Code command in the install section to add MySQL Legacy MCP to Claude Code, or copy the ready-made config for your client from the install section on this page. Restart your client afterwards and the tools appear in your next conversation.
Which clients work with MySQL Legacy MCP?
This page carries setup and config for Claude Code, Claude Desktop, Cursor and VS Code. Any other MCP client that accepts a standard server config can connect to MySQL Legacy MCP as well.
Does MySQL Legacy MCP need an API key?
Yes. Before it can run, set these environment variables: MYSQL_LEGACY_HOST, MYSQL_LEGACY_USER, MYSQL_LEGACY_PASSWORD, MYSQL_LEGACY_PORT, MYSQL_LEGACY_DATABASE, MYSQL_LEGACY_HIDE_SYSTEM_DATABASES, MYSQL_LEGACY_QUERY_TIMEOUT, MYSQL_LEGACY_MAX_ROWS, MYSQL_LEGACY_MAX_RESULT_BYTES, MYSQL_LEGACY_CONNECT_TIMEOUT, MYSQL_LEGACY_POOL_SIZE, MYSQL_LEGACY_ALLOW_INSERT, MYSQL_LEGACY_ALLOW_UPDATE, MYSQL_LEGACY_ALLOW_DELETE, MYSQL_LEGACY_ALLOW_DDL, MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS. They go in the env block of your MCP config.
Imported from the Official MCP Registry. The details above come from the registry entry; the maker can claim this listing to correct them, add docs, and see its traffic.
Is this your MCP server?
Claim this listing to see its traffic, fix details yourself, and skip the review queue on future updates.
Add this badge to your README
Show visitors this server is listed in the ClaudeRules directory. The badge links straight to this listing.
[](https://clauderules.net/mcp/io-github-rufflet-mysql-legacy-mcp)<a href="https://clauderules.net/mcp/io-github-rufflet-mysql-legacy-mcp" target="_blank" rel="noopener noreferrer"><img src="https://clauderules.net/api/badge/io-github-rufflet-mysql-legacy-mcp" alt="Listed on clauderules.net" /></a>More Database MCP servers
GitHub
Connect AI assistants to GitHub - manage repos, issues, PRs, and workflows through natural language.
Serena MCP: the IDE for your agent
A powerful toolkit for coding, providing semantic retrieval and editing capabilities.
MCP Toolbox for Databases
MCP Toolbox for Databases enables your agent to connect to your database.
Figma-Context-MCP
Give your coding agent access to your Figma data. Implement designs in any framework in one-shot.