# MySQL Audit (pypi · mysql-audit-ai-agent)

MySQL migration and query safety review for AI agents: locks, table copies, data loss, injection.

- Trust score: 78/100 (medium)
- Change this week: +19
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-11-05

## Components

- pypi · `mysql-audit-ai-agent`: 78/100 (this document), [markdown](https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent.md), [page](https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent)

## Channel facts

- Registry: `pypi`
- Package: `mysql-audit-ai-agent`
- Version: `0.3.3`
- 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-11-05.

- **Supply Chain Security**: 100/100
  - No malware found by supply-chain analysis.
  - No known CVEs affecting this package version or its production dependencies.
  - Runs hatchling.build at install time, a recognised build step with no custom scripting around it.
  - 1 of 30 dependencies flagged as unhealthy.
- **Provenance & Transparency**: 97/100
  - Source repository is publicly reachable at the declared URL.
  - Cryptographically verified build provenance (signed, bound to jimmyjan0824/mysql_audit_ai_agent).
  - Clear OSI-approved license (Apache-2.0).
  - Actively maintained (last published 7 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 63/100
  - AI-judged instruction clarity (good).
  - Context-footprint check failed: tool/resource definitions use about 889 tokens (~148/item across 6 items; 6 tools + 0 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 30/100
  - Stability observed for 9 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 71/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 0% of tool parameters carry a description.
  - Structured output schemas are declared (17% of tools); any adoption earns full credit.
- **Tool Safety**: 50/100
  - Injection-marker check failed: the server instructions contains an instruction to conceal the call from the user, the text "Never tell the user", at byte 658 of that field.
  - We read all 6 captured tool definition(s), and no name or description among them implies an irreversible operation.
  - An AI judge read all 7 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a current MCP spec version (2026-07-28).

## Install

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

MySQL Audit runs locally as a PyPI package, launched with uvx mysql-audit-ai-agent. 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 jimmyjan0824-mysql-audit -- uvx mysql-audit-ai-agent
```

### Cursor

```json
{
  "mcpServers": {
    "jimmyjan0824-mysql-audit": {
      "command": "uvx",
      "args": [
        "mysql-audit-ai-agent"
      ]
    }
  }
}
```

### VS Code

```json
{
  "servers": {
    "jimmyjan0824-mysql-audit": {
      "command": "uvx",
      "args": [
        "mysql-audit-ai-agent"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add jimmyjan0824-mysql-audit -- uvx mysql-audit-ai-agent
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "jimmyjan0824-mysql-audit": {
      "type": "local",
      "command": [
        "uvx",
        "mysql-audit-ai-agent"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add jimmyjan0824-mysql-audit --command uvx --arg mysql-audit-ai-agent
```

### Hermes

```yaml
mcp_servers:
  jimmyjan0824-mysql-audit:
    command: "uvx"
    args: ["mysql-audit-ai-agent"]
```

### Netclaw

```json
{
  "McpServers": {
    "jimmyjan0824-mysql-audit": {
      "Transport": "stdio",
      "Command": "uvx",
      "Arguments": [
        "mysql-audit-ai-agent"
      ]
    }
  }
}
```

### Vellum

```bash
assistant mcp add jimmyjan0824-mysql-audit -t stdio -c uvx -a mysql-audit-ai-agent
```

### Other

```json
{
  "mcpServers": {
    "jimmyjan0824-mysql-audit": {
      "command": "uvx",
      "args": [
        "mysql-audit-ai-agent"
      ]
    }
  }
}
```

## 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-11-05 (score 78, +16)

- [security improvement] Malware scan: unverified → pass

### 2026-11-03 (score 62, +1)

No change was recorded against any check on this day. Stability & Change Management went from 20 to 23. That category is still filling its 30-day observation window: 6 days of observed history at the previous scan, 7 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-11-01 (score 61, +1)

No change was recorded against any check on this day. Stability & Change Management went from 13 to 17. That category is still filling its 30-day observation window: 4 days of observed history at the previous scan, 5 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-10-30 (score 60, +1)

No change was recorded against any check on this day. Stability & Change Management went from 7 to 10. That category is still filling its 30-day observation window: 2 days of observed history at the previous scan, 3 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-10-29 (score 59, −3)

- [security regression] Injection markers: pass → fail
- [functional] Package version: 0.3.2 → 0.3.3

### 2026-10-28 (score 62, −1)

- [functional regression] Schema quality: pass → fail
- [functional improvement] Stability: unverified → 0.03
- [functional] Package version: 0.2.0 → 0.3.2
- [functional] Package version: 0.2.0 → 0.3.1
- [functional] Package version: 0.2.0 → 0.3.0
- [functional] Package version: 0.2.0 → 0.2.1

### 2026-10-27 (score 63)

First indexed and scored.

## MCP tools (6)

### `review_migration` (~353 tokens)

Review MySQL DDL or a migration script for locking, data-loss and replication risks.

Args:
    sql: The SQL to run, one or more statements separated by semicolons.
    schema: Optional CREATE TABLE statements for the tables involved (e.g. from
        SHOW CREATE TABLE). Makes column-type and index checks exact.
    stats: Optional size per table from information_schema.tables: a row count
        ({"orders": 25000000}) or {"orders": {"rows": 25000000, "data_bytes":
        <data_length>, "index_bytes": <index_length>}}. Large = 1M rows or 5 GB.
    mysql_version: Optional target server version, e.g. "8.0.28", "8.4.3" or
        "aurora-3.04" (SELECT VERSION()). Older servers copy the table for more
        column changes. Without it, 8.0.29 or later is assumed.
    free_disk_gb: Optional free space on the server's data volume, in GB. With
        byte sizes in stats, a table rebuild that does not fit is blocked.
    rollback_sql: Optional down migration kept in a separate file (e.g. a
        golang-migrate .down.sql or Flyway U__ file). Down sections and
        --rollback lines inside sql are found without it.

Returns a verdict (safe / review / block) and findings with line, impact and fix.

Input parameters:

- `free_disk_gb`
- `mysql_version`
- `rollback_sql`
- `schema`
- `sql` (string, required)
- `stats`

### `review_query` (~86 tokens)

Review queries an application will run (SELECT / UPDATE / DELETE / INSERT) for missing
indexes, unbatched writes and unsafe UPDATE/DELETE. Pass schema for index checks.

Returns a verdict (safe / review / block) and findings with line, impact and fix.

Input parameters:

- `mysql_version`
- `schema`
- `sql` (string, required)
- `stats`

### `review_code` (~68 tokens)

Check application source code (Python, JS/TS, PHP, Go, Java) for SQL built by string
interpolation or concatenation, i.e. SQL injection.

Returns a verdict (safe / block) and findings with line and the parameterized fix.

Input parameters:

- `code` (string, required)

### `preflight_checks` (~136 tokens)

SQL for the user (or DBA) to run on the primary right before deploying a migration:
long transactions, long queries and metadata locks on the tables it touches, current
table sizes, and how to check replica lag. Each query returns rows only when the deploy
should wait. This tool does not connect to the database; hand the SQL to the user.

Args:
    sql: The migration that is about to run.
    mysql_version: Optional server version, e.g. "5.7.44"; picks SHOW SLAVE / REPLICA STATUS.

Input parameters:

- `mysql_version`
- `sql` (string, required)

### `explain_rule` (~35 tokens)

Explain one rule (e.g. "L02"): why it matters and a safe example.

Input parameters:

- `rule_id` (string, required)

### `list_rules` (~24 tokens)

List every rule this server checks, with its id, title and default severity.

Output parameters:

- `result` (array)

## Diagnostics

Captured diagnostic sections: Provenance, Install scripts, Dependencies. The full working is on the page: https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent#diagnostics

## Score history

- 2026-11-05: 78
- 2026-11-04: 62
- 2026-11-03: 62
- 2026-11-02: 61
- 2026-11-01: 61
- 2026-10-31: 60
- 2026-10-30: 60
- 2026-10-29: 59
- 2026-10-28: 62
- 2026-10-27: 63

## Common questions

### What is the MySQL Audit MCP server?

MySQL Audit is an MCP server listed in the public MCP registry as io.github.jimmyjan0824/mysql-audit. MySQL migration and query safety review for AI agents: locks, table copies, data loss, injection. This page covers its PyPI package (mysql-audit-ai-agent).

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

MySQL Audit scores 78 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 5 November 2026. 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 Audit MCP server expose?

MySQL Audit exposes 6 tools: review_migration, review_query, review_code, preflight_checks, explain_rule, list_rules. Their descriptions and schemas cost roughly 702 tokens of context every time the server is loaded.

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

MySQL Audit is still listed as active in the MCP registry. We last reached this channel on 5 November 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 Audit MCP server under?

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

### What did VerifyMCP test on the MySQL Audit MCP server?

VerifyMCP ran 16 checks on MySQL Audit, covering Malware scan, Known CVEs, Install scripts, Dependency health and 12 more. Endpoint Security and Transport & Reachability do not apply to a PyPI package, so they were not tested. The score does not measure everything, and the scoring documentation lists what it leaves out.

## Links

- PyPI project: https://pypi.org/project/mysql-audit-ai-agent/
- Socket report: https://socket.dev/pypi/package/mysql-audit-ai-agent
- Repository: https://github.com/jimmyjan0824/mysql_audit_ai_agent
- Changelog RSS feed: https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent.xml
- Changelog JSON feed: https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent/changelog.json
- Trust report (JSON): https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent.json
- HTML version of this page: https://verifymcp.io/servers/jimmyjan0824-mysql-audit/mysql-audit-ai-agent