# mysql-mcp

MCP server for MySQL / MariaDB / Aurora MySQL — built for Claude Desktop and Claude Code.

```bash
mysql-mcp serve --url "mysql://root:root@localhost:3306/mydb"
mysql-mcp serve --aurora-host my-cluster.cluster-xxx.us-east-1.rds.amazonaws.com \
                --aurora-region us-east-1 --aurora-user myuser --dbname mydb
mysql-mcp playbook slow-query --url "mysql://..."
mysql-mcp config desktop --url "mysql://root:root@localhost:3306/mydb"
```

## Tools exposed to Claude

| Tool | What it does |
|---|---|
| `query` | Execute SQL (read-only by default) |
| `explain` | `EXPLAIN FORMAT=JSON` + `EXPLAIN ANALYZE` on a query |
| `schema` | List tables + describe columns, indexes, constraints |
| `health_check` | InnoDB status, connections, replication, slow query summary |
| `playbook` | Named multi-step diagnostic workflow (see below) |

## Playbooks

```bash
mysql-mcp playbook health        --url "..."   # full cluster health
mysql-mcp playbook slow-query    --url "..."   # find + diagnose slow queries
mysql-mcp playbook pre-deploy    --url "..."   # safe to deploy?
mysql-mcp playbook replication   --url "..."   # diagnose replica lag
mysql-mcp playbook innodb-status --url "..."   # parse SHOW ENGINE INNODB STATUS
```

## Claude Desktop setup

```bash
mysql-mcp config desktop --url "mysql://root:root@localhost:3306/mydb"
```

Prints the JSON block to paste into `~/Library/Application Support/Claude/claude_desktop_config.json`.

## Aurora MySQL (IAM auth)

```bash
mysql-mcp serve \
  --aurora-host my-cluster.cluster-xxx.us-east-1.rds.amazonaws.com \
  --aurora-region us-east-1 \
  --aurora-user myuser \
  --dbname mydb
```

Requires `AmazonRDSReadOnlyAccess` IAM policy on the calling role and IAM DB auth enabled on the cluster.

## Part of the rajivonai polyglot database toolkit

[rajivonai.com](https://rajivonai.com) · [easy-mysql-lab](https://github.com/rajivonai/easy-mysql-lab) · [mysql-advisor](https://github.com/rajivonai/mysql-advisor)