mysql-mcp

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

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

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

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)

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 · easy-mysql-lab · mysql-advisor