Skip to main content
Glama
rajivonai

mysql-mcp

by rajivonai

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)

Related MCP server: Database Tools for Claude AI

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

A
license - permissive license
-
quality - not tested
C
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/rajivonai/mysql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server