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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

No tool schema history has been recorded yet.

Maintenance

ActivityStale
ResponsivenessNo issues

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

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

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
    5
    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.
    61
    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.
    1,081
    5
    MIT

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