MySQL Legacy MCP server

Read from the package source without running it. The installed server may list more.

• mysql_legacy_ddlwrite action

  Runs exactly one table-level CREATE, ALTER, DROP, TRUNCATE, or RENAME supplied in sql. Off unless MYSQL_LEGACY_ALLOW_DDL=true. DROP and TRUNCATE are irreversible. Rejects DROP DATABASE, views, and indexes. For row changes use mysql_legacy_insert, mysql_legacy_update, or mysql_legacy_delete.

• mysql_legacy_deletewrite action

  Runs exactly one DELETE supplied in sql. WHERE is required and cannot be disabled. Off unless MYSQL_LEGACY_ALLOW_DELETE=true. Returns affectedRows. To empty a table use TRUNCATE via mysql_legacy_ddl, not a WHERE-less DELETE.

• mysql_legacy_describe_table

  Lists columns for database.table via SHOW FULL COLUMNS, including type, nullability, keys, comments, and collation. Use this for per-column metadata. For the full CREATE TABLE text and default charset use mysql_legacy_show_create_table. For index column order use mysql_legacy_list_indexes.

• mysql_legacy_insertwrite action

  Runs exactly one INSERT supplied in sql. Off unless MYSQL_LEGACY_ALLOW_INSERT=true. Returns insertId and affectedRows. INSERT ... ON DUPLICATE KEY UPDATE is accepted and can overwrite existing rows. For UPDATE/DELETE/DDL use mysql_legacy_update, mysql_legacy_delete, or mysql_legacy_ddl.

• mysql_legacy_list_databases

  Lists database names via SHOW DATABASES. Hides mysql and information_schema unless include_system_databases=true (or MYSQL_LEGACY_HIDE_SYSTEM_DATABASES=false). Then pass a name to mysql_legacy_list_tables. Does not list tables or columns.

• mysql_legacy_list_indexes

  Lists indexes for database.table via SHOW INDEX (key name, columns, uniqueness, type). Use this for keys. For column types use mysql_legacy_describe_table; for full DDL use mysql_legacy_show_create_table.

• mysql_legacy_list_tables

  Lists base tables and views in one database via SHOW FULL TABLES FROM database. Pass database. For column types use mysql_legacy_describe_table; for CREATE TABLE text use mysql_legacy_show_create_table; for keys use mysql_legacy_list_indexes. To list databases first, use mysql_legacy_list_databases.

• mysql_legacy_ping

  Checks the MySQL connection with SELECT VERSION() AS version and returns {connected, version}. Call this first after connecting. For schema use mysql_legacy_list_tables; for row data use mysql_legacy_select.

• mysql_legacy_selectwrite action

  Runs exactly one SELECT supplied in sql. Rejects SELECT INTO and locking reads; truncates by MYSQL_LEGACY_MAX_ROWS and MYSQL_LEGACY_MAX_RESULT_BYTES. On MySQL 5.6.5+ wraps in START TRANSACTION READ ONLY unless MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS=true. For columns use mysql_legacy_describe_table; for CREATE TABLE text use mysql_legacy_show_create_table; for writes use mysql_legacy_insert, m

• mysql_legacy_show_create_tablewrite action

  Returns SHOW CREATE TABLE for database.table plus the parsed default charset. Use this for DDL text. For per-column types and collation use mysql_legacy_describe_table. For unique/non-unique keys use mysql_legacy_list_indexes.

• mysql_legacy_updatewrite action

  Runs exactly one UPDATE supplied in sql. WHERE is required and cannot be disabled. Off unless MYSQL_LEGACY_ALLOW_UPDATE=true. Returns affectedRows and changedRows. To empty a table use TRUNCATE via mysql_legacy_ddl, not a WHERE-less UPDATE.

• Code scan2 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitystatic API keys via environment variables6/15
• Maintenancelast push 11 days ago15/15
• Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Safety score

83/100

higher than 60% of 802 Databases servers

Tools

11

the typical Databases server has 8

Tools that change things

55%

typical: 10%. Fewer write tools means less an agent can break

Downloads a week

44

more than 31% of 328 Databases servers with a package

MySQL Legacy MCP: common questions

Is MySQL Legacy MCP server safe?

Mostly: it is graded B (83/100). Read the MySQL Legacy MCP safety report

How do I install MySQL Legacy MCP?

It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.

Does MySQL Legacy MCP need an API key?

Yes. The registry entry asks for MYSQL_LEGACY_PASSWORD.

Is MySQL Legacy MCP maintained?

The last commit was 43 days ago (2026-09-22). The latest release is v0.2.1.

What can I use instead of MySQL Legacy MCP?

Servers from other publishers that do the same job: MCP Local WP MCP server, DBHub MCP server and Appwrite MCP server.

How does MySQL Legacy MCP compare with other Databases MCP servers?

safety score 83/100 (higher than 60% of 802 Databases servers); tools 11 (the typical Databases server has 8); tools that change things 55% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.