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

Related MCP Connectors

  • Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.

  • Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.

  • The Ramp MCP server enables users to securely connect Ramp with AI assistants like ChatGPT and Claude to query financial data and take actions using natural language. It transforms Ramp's developer API into a SQL interface that LLMs can query, allowing admins to analyze spend trends, identify cost savings, and run complex SQL analyses on comprehensive datasets (transactions, purchase orders, vendors, users), while all users can manage cards, view transactions, request reimbursements, and get expense policy answers.

  • Hosted Amazon Seller and Vendor MCP server for Claude, ChatGPT, Cursor, Codex, Gemini, Copilot.

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
    2 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.
    30 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.
    600 npm
    5
    MIT