Skip to main content
Glama
mysql-mcp

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

Related MCP Connectors

Related MCP Servers

  • A
    license
    B
    quality
    D
    maintenance
    MCP server that allows Claude AI to interact directly with MySQL databases, enabling query execution and table information retrieval through natural language.
    1
    4 npm
    4
    MIT
  • A
    license
    Not graded
    quality
    C
    maintenance
    MySQL MCP Server enables Claude Desktop and Claude Code to execute SQL queries, explore databases, Webview to add or enable Databases, Connections, and interact with your MySQL data - all through a secure, permission-controlled interface.
    18 npm
    1
    MIT
  • A
    license
    Not graded
    quality
    D
    maintenance
    A MySQL MCP server for secure database interaction, enabling schema inspection, query execution, and RBAC via AI coding assistants.
    688 npm
    5
    MIT