# MySQL Legacy MCP (npm · mysql-legacy-mcp)

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

- Trust score: 82/100 (high trust)
- Change this week: +25
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-09-21

## Components

- npm · `mysql-legacy-mcp`: 82/100 (this document), [markdown](https://verifymcp.io/servers/rufflet-mysql-legacy-mcp/mysql-legacy-mcp.md), [page](https://verifymcp.io/servers/rufflet-mysql-legacy-mcp/mysql-legacy-mcp)

## Channel facts

- Registry: `npm`
- Package: `mysql-legacy-mcp`
- Version: `0.2.1`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-09-21.

- **Supply Chain Security**: 98/100
  - No malware found by supply-chain analysis.
  - No known CVEs affecting this package version or its production dependencies.
  - No install/post-install scripts declared.
  - 41 of 109 dependencies flagged as unhealthy.
- **Provenance & Transparency**: 97/100
  - Source repository is publicly reachable at the declared URL.
  - Cryptographically verified build provenance (signed, bound to Rufflet/mysql-legacy-mcp).
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 6 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 86/100
  - AI-judged instruction clarity (excellent).
  - Tool/resource definitions use about 1020 tokens (~92/item across 11 items; 11 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Tool Safety**: 100/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - All 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation.
  - An AI judge read all 11 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### How do I install the MySQL Legacy MCP server?

MySQL Legacy MCP runs locally as an npm package, launched with npx -y mysql-legacy-mcp. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add rufflet-mysql-legacy-mcp -- npx -y mysql-legacy-mcp
```

### Cursor

```json
{
  "mcpServers": {
    "rufflet-mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ]
    }
  }
}
```

### VS Code

```json
{
  "servers": {
    "rufflet-mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add rufflet-mysql-legacy-mcp -- npx -y mysql-legacy-mcp
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "rufflet-mysql-legacy-mcp": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "mysql-legacy-mcp"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add rufflet-mysql-legacy-mcp --command npx --arg -y --arg mysql-legacy-mcp
```

### Hermes

```yaml
mcp_servers:
  rufflet-mysql-legacy-mcp:
    command: "npx"
    args: ["-y", "mysql-legacy-mcp"]
```

### Netclaw

```json
{
  "McpServers": {
    "rufflet-mysql-legacy-mcp": {
      "Transport": "stdio",
      "Command": "npx",
      "Arguments": [
        "-y",
        "mysql-legacy-mcp"
      ]
    }
  }
}
```

### Vellum

```bash
assistant mcp add rufflet-mysql-legacy-mcp -t stdio -c npx -a -y mysql-legacy-mcp
```

### Other

```json
{
  "mcpServers": {
    "rufflet-mysql-legacy-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "mysql-legacy-mcp"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-09-15 (score 82, +25)

- [security improvement] Malware scan: unverified → pass
- [security improvement] Known CVEs: unverified → pass
- [functional improvement] Dependency health: unverified → 0.81

### 2026-09-14 (score 57)

First indexed and scored.

## MCP tools (11)

### `mysql_legacy_ping` (~52 tokens)

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_select` (~132 tokens)

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, mysql_legacy_update, or mysql_legacy_delete.

Input parameters:

- `sql` (string, required): One MySQL 5.1-compatible SELECT statement.

### `mysql_legacy_insert` (~87 tokens)

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.

Input parameters:

- `sql` (string, required): One MySQL INSERT statement.

### `mysql_legacy_update` (~80 tokens)

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.

Input parameters:

- `sql` (string, required): One MySQL UPDATE statement with a WHERE clause.

### `mysql_legacy_delete` (~77 tokens)

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.

Input parameters:

- `sql` (string, required): One MySQL DELETE statement with a WHERE clause.

### `mysql_legacy_ddl` (~110 tokens)

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.

Input parameters:

- `sql` (string, required): One MySQL table-level DDL statement: CREATE/ALTER/DROP/TRUNCATE/RENAME TABLE.

### `mysql_legacy_list_databases` (~93 tokens)

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.

Input parameters:

- `include_system_databases` (boolean): When true, include mysql and information_schema for this call. Overrides MYSQL_LEGACY_HIDE_SYSTEM_DATABASES.

### `mysql_legacy_list_tables` (~92 tokens)

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.

Input parameters:

- `database` (string, required): MySQL database name, 1–64 characters.

### `mysql_legacy_describe_table` (~108 tokens)

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.

Input parameters:

- `database` (string, required): MySQL database name, 1–64 characters.
- `table` (string, required): MySQL table or view name, 1–64 characters.

### `mysql_legacy_show_create_table` (~96 tokens)

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.

Input parameters:

- `database` (string, required): MySQL database name, 1–64 characters.
- `table` (string, required): MySQL table or view name, 1–64 characters.

### `mysql_legacy_list_indexes` (~93 tokens)

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.

Input parameters:

- `database` (string, required): MySQL database name, 1–64 characters.
- `table` (string, required): MySQL table or view name, 1–64 characters.

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/rufflet-mysql-legacy-mcp/mysql-legacy-mcp#diagnostics

## Score history

- 2026-09-21: 82
- 2026-09-20: 82
- 2026-09-19: 82
- 2026-09-18: 82
- 2026-09-17: 82
- 2026-09-16: 82
- 2026-09-15: 82
- 2026-09-14: 57

## Common questions

### What is the MySQL Legacy MCP server?

MySQL Legacy MCP is listed in the public MCP registry as io.github.Rufflet/mysql-legacy-mcp. Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0. This page covers its npm package (mysql-legacy-mcp).

### Is the MySQL Legacy MCP server safe to use?

MySQL Legacy MCP scores 82 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 21 September 2026. It declares no install or post-install scripts. Its build provenance is signed and verified. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.

### What tools does the MySQL Legacy MCP server expose?

MySQL Legacy MCP exposes 11 tools: mysql_legacy_ping, mysql_legacy_select, mysql_legacy_insert, mysql_legacy_update, mysql_legacy_delete, and 6 more. Their descriptions and schemas cost roughly 1,020 tokens of context every time the server is loaded.

### Is the MySQL Legacy MCP server still maintained?

MySQL Legacy MCP is still listed as active in the MCP registry. We last reached this channel on 21 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.

### What licence is the MySQL Legacy MCP server under?

MySQL Legacy MCP declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.

## Links

- npm package: https://www.npmjs.com/package/mysql-legacy-mcp
- Socket report: https://socket.dev/npm/package/mysql-legacy-mcp
- Repository: https://github.com/Rufflet/mysql-legacy-mcp
- Changelog RSS feed: https://verifymcp.io/servers/rufflet-mysql-legacy-mcp/mysql-legacy-mcp.xml
- Changelog JSON feed: https://verifymcp.io/servers/rufflet-mysql-legacy-mcp/mysql-legacy-mcp.json
- HTML version of this page: https://verifymcp.io/servers/rufflet-mysql-legacy-mcp/mysql-legacy-mcp