MySQL Legacy MCP
io.github.Rufflet/mysql-legacy-mcp · version 0.2.1
Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.
Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.
https://github.com/Rufflet/mysql-legacy-mcpQuick facts
- Listing: Community
- Published Sep 14, 11:28 UTC
- Transport: stdio
- Package: npm
mysql-legacy-mcp0.2.1 - Listed by cosmic-mcp: Nov 9, 04:25 UTC
Details
- Repository: https://github.com/Rufflet/mysql-legacy-mcp
- npm: https://www.npmjs.com/package/mysql-legacy-mcp
- Website: https://github.com/Rufflet/mysql-legacy-mcp
- Needs settings:
MYSQL_LEGACY_HOSTMYSQL_LEGACY_USERMYSQL_LEGACY_PASSWORDMYSQL_LEGACY_PORTMYSQL_LEGACY_DATABASEMYSQL_LEGACY_HIDE_SYSTEM_DATABASESMYSQL_LEGACY_QUERY_TIMEOUTMYSQL_LEGACY_MAX_ROWSMYSQL_LEGACY_MAX_RESULT_BYTESMYSQL_LEGACY_CONNECT_TIMEOUTMYSQL_LEGACY_POOL_SIZEMYSQL_LEGACY_ALLOW_INSERTMYSQL_LEGACY_ALLOW_UPDATEMYSQL_LEGACY_ALLOW_DELETEMYSQL_LEGACY_ALLOW_DDLMYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS
Setup snippets
Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.
Run it locally (npm)
npx -y '[email protected]'Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"mysql-legacy-mcp": {
"args": [
"-y",
"[email protected]"
],
"command": "npx",
"env": {
"MYSQL_LEGACY_ALLOW_DDL": "<your mysql legacy allow ddl>",
"MYSQL_LEGACY_ALLOW_DELETE": "<your mysql legacy allow delete>",
"MYSQL_LEGACY_ALLOW_INSERT": "<your mysql legacy allow insert>",
"MYSQL_LEGACY_ALLOW_UPDATE": "<your mysql legacy allow update>",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "<your mysql legacy connect timeout>",
"MYSQL_LEGACY_DATABASE": "<your mysql legacy database>",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<your mysql legacy disable read only transactions>",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<your mysql legacy hide system databases>",
"MYSQL_LEGACY_HOST": "<your mysql legacy host>",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "<your mysql legacy max result bytes>",
"MYSQL_LEGACY_MAX_ROWS": "<your mysql legacy max rows>",
"MYSQL_LEGACY_PASSWORD": "<your mysql legacy password>",
"MYSQL_LEGACY_POOL_SIZE": "<your mysql legacy pool size>",
"MYSQL_LEGACY_PORT": "<your mysql legacy port>",
"MYSQL_LEGACY_QUERY_TIMEOUT": "<your mysql legacy query timeout>",
"MYSQL_LEGACY_USER": "<your mysql legacy user>"
}
}
}
}Claude Code
claude mcp add 'mysql-legacy-mcp' -- npx -y '[email protected]'Cursor (.cursor/mcp.json)
{
"mcpServers": {
"mysql-legacy-mcp": {
"args": [
"-y",
"[email protected]"
],
"command": "npx",
"env": {
"MYSQL_LEGACY_ALLOW_DDL": "<your mysql legacy allow ddl>",
"MYSQL_LEGACY_ALLOW_DELETE": "<your mysql legacy allow delete>",
"MYSQL_LEGACY_ALLOW_INSERT": "<your mysql legacy allow insert>",
"MYSQL_LEGACY_ALLOW_UPDATE": "<your mysql legacy allow update>",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "<your mysql legacy connect timeout>",
"MYSQL_LEGACY_DATABASE": "<your mysql legacy database>",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<your mysql legacy disable read only transactions>",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<your mysql legacy hide system databases>",
"MYSQL_LEGACY_HOST": "<your mysql legacy host>",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "<your mysql legacy max result bytes>",
"MYSQL_LEGACY_MAX_ROWS": "<your mysql legacy max rows>",
"MYSQL_LEGACY_PASSWORD": "<your mysql legacy password>",
"MYSQL_LEGACY_POOL_SIZE": "<your mysql legacy pool size>",
"MYSQL_LEGACY_PORT": "<your mysql legacy port>",
"MYSQL_LEGACY_QUERY_TIMEOUT": "<your mysql legacy query timeout>",
"MYSQL_LEGACY_USER": "<your mysql legacy user>"
}
}
}
}VS Code (.vscode/mcp.json)
{
"servers": {
"mysql-legacy-mcp": {
"args": [
"-y",
"[email protected]"
],
"command": "npx",
"env": {
"MYSQL_LEGACY_ALLOW_DDL": "<your mysql legacy allow ddl>",
"MYSQL_LEGACY_ALLOW_DELETE": "<your mysql legacy allow delete>",
"MYSQL_LEGACY_ALLOW_INSERT": "<your mysql legacy allow insert>",
"MYSQL_LEGACY_ALLOW_UPDATE": "<your mysql legacy allow update>",
"MYSQL_LEGACY_CONNECT_TIMEOUT": "<your mysql legacy connect timeout>",
"MYSQL_LEGACY_DATABASE": "<your mysql legacy database>",
"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS": "<your mysql legacy disable read only transactions>",
"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES": "<your mysql legacy hide system databases>",
"MYSQL_LEGACY_HOST": "<your mysql legacy host>",
"MYSQL_LEGACY_MAX_RESULT_BYTES": "<your mysql legacy max result bytes>",
"MYSQL_LEGACY_MAX_ROWS": "<your mysql legacy max rows>",
"MYSQL_LEGACY_PASSWORD": "<your mysql legacy password>",
"MYSQL_LEGACY_POOL_SIZE": "<your mysql legacy pool size>",
"MYSQL_LEGACY_PORT": "<your mysql legacy port>",
"MYSQL_LEGACY_QUERY_TIMEOUT": "<your mysql legacy query timeout>",
"MYSQL_LEGACY_USER": "<your mysql legacy user>"
},
"type": "stdio"
}
}
}Related servers
- spotdb Verified domain
Ephemeral data sandbox for AI workflows with guardrails and security - Reasonbook Verified domain
Reasonbook: decisions that survive the session, in a local record AI agents keep. - AI for Database Verified domain
Ask your databases questions in plain English, run read-only SQL and set up data alerts. - AI2SQL Verified domain
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema - AICasePredict Verified domain
Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts. - APC Security Reference Server
Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...