MySQL Legacy MCP Server

Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.

Local serverstdio

What is the MySQL Legacy MCP Server?

MySQL Legacy MCP is an MCP integration. Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.

Packages and local setup

The published npm package is mysql-legacy-mcp, version 0.2.1. Its declared MCP transport is stdio.

The package declares MYSQL_LEGACY_HOST (required): Database host or local tunnel endpoint; MYSQL_LEGACY_USER (required): Dedicated database reader account; MYSQL_LEGACY_PASSWORD (required): Nonempty database account password; MYSQL_LEGACY_PORT: TCP port, 1–65535; MYSQL_LEGACY_DATABASE: Optional default database; MYSQL_LEGACY_HIDE_SYSTEM_DATABASES: Hide mysql and information_schema from listings; MYSQL_LEGACY_QUERY_TIMEOUT: Driver query timeout, 100–60000 milliseconds; MYSQL_LEGACY_MAX_ROWS: SELECT response row limit, 1–1000; MYSQL_LEGACY_MAX_RESULT_BYTES: SELECT row-data JSON byte limit, 1024–1048576; MYSQL_LEGACY_CONNECT_TIMEOUT: Connection-establishment timeout, 100–60000 milliseconds; MYSQL_LEGACY_POOL_SIZE: Pooled connection limit, 1–50; MYSQL_LEGACY_ALLOW_INSERT: Enable the mysql_legacy_insert tool; MYSQL_LEGACY_ALLOW_UPDATE: Enable the mysql_legacy_update tool (WHERE clause always required); MYSQL_LEGACY_ALLOW_DELETE: Enable the mysql_legacy_delete tool (WHERE clause always required); MYSQL_LEGACY_ALLOW_DDL: Enable the mysql_legacy_ddl tool (table-level statements only); MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS: Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+.

Before connecting

Check the maintainer’s instructions for account access, authentication and the supported client configuration. Once connected, inspect the tools your client receives and try a small task that matches the server’s stated purpose. The registry description does not include a verified, complete tool list.

Project and source

View the publisher’s registry entry · Project repository · Project website. This profile uses version 0.2.1 from the registry. Registration identifies the publisher namespace; it does not establish that this is a first-party integration for every service it connects.

Browse related databases MCP servers for tools that cover the same kind of work.

Configuration

VariableDescriptionRequired
MYSQL_LEGACY_HOSTDatabase host or local tunnel endpointYes
MYSQL_LEGACY_USERDedicated database reader accountYes
MYSQL_LEGACY_PASSWORDNonempty database account passwordYes
MYSQL_LEGACY_PORTTCP port, 1–65535Optional
MYSQL_LEGACY_DATABASEOptional default databaseOptional
MYSQL_LEGACY_HIDE_SYSTEM_DATABASESHide mysql and information_schema from listingsOptional
MYSQL_LEGACY_QUERY_TIMEOUTDriver query timeout, 100–60000 millisecondsOptional
MYSQL_LEGACY_MAX_ROWSSELECT response row limit, 1–1000Optional
MYSQL_LEGACY_MAX_RESULT_BYTESSELECT row-data JSON byte limit, 1024–1048576Optional
MYSQL_LEGACY_CONNECT_TIMEOUTConnection-establishment timeout, 100–60000 millisecondsOptional
MYSQL_LEGACY_POOL_SIZEPooled connection limit, 1–50Optional
MYSQL_LEGACY_ALLOW_INSERTEnable the mysql_legacy_insert toolOptional
MYSQL_LEGACY_ALLOW_UPDATEEnable the mysql_legacy_update tool (WHERE clause always required)Optional
MYSQL_LEGACY_ALLOW_DELETEEnable the mysql_legacy_delete tool (WHERE clause always required)Optional
MYSQL_LEGACY_ALLOW_DDLEnable the mysql_legacy_ddl tool (table-level statements only)Optional
MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONSDisable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+Optional