MoreAI.tools
M
MySQL MCP
42
Stack Score
Editorial pick✓ Verified workingMCP server
MySQL MCP logo

MySQL MCP

Query MySQL / MariaDB / Aurora from Claude.

Try MySQL MCP

Best for

Best for teams on MySQL/MariaDB who want Claude to query the operational database.

At a glance

Pricing
open-source
Setup time
15 minutes
Learning curve
moderate
Last verified
5/27/2026

What we love

  • ✓Wide compatibility (MySQL/Maria/Aurora)
  • ✓Schema introspection helps prompts
  • ✓Configurable read-only for safety

Where it falls short

  • −Easy to write destructive queries — read-only mode advised
  • −SSL setup adds steps
  • −Limited stored-proc support

Install & connect

Copy-paste ready

Install
shell
npx -y @smithery/cli@latest install huangfeng19820712/mcp-mysql-server --client claude
Config — Claude Desktop
json
{
  "mcpServers": {
    "mysql-server": {
      "command": "npx",
      "args": ["-y","@smithery/cli@latest","run","huangfeng19820712/mcp-mysql-server","--config","{}"]
    }
  }
}

Pricing

✓ Pricing verified Jun 14, 2026

1 tier

Open-source

$0

perpetual

  • ✓MIT

Overview

MCP server exposing MySQL — SELECT, INSERT, UPDATE, DELETE, schema introspection, query history. Works with MariaDB and Aurora MySQL too.

Key features

  • ●Read + write queries
  • ●Schema introspection
  • ●Connection pooling
  • ●Read-only mode option
  • ●TLS auth

Exposed tools

The MCP-tool names this server exposes. Your agent can invoke any of these when this server is connected.

  • connect_db
    Connect to a MySQL database.
  • query
    Execute a SELECT query.
  • execute
    Execute an INSERT, UPDATE, or DELETE query.
  • list_tables
    List all tables in the database.
  • describe_table
    Get table structure.
  • show_statement
    Execute a SHOW statement.
  • explain
    Analyze SQL query performance using EXPLAIN.

Best use cases

AI data analyst

Let Claude write SQL against your MySQL warehouse and return analysis.

Operational queries

Run report-style queries from chat instead of writing one-off SQL by hand.

Integrations

MySQL
MariaDB
Aurora MySQL
PlanetScale

Similar tools

See all analytics →
Hotjar
58
Heatmaps, session recordings, and surveys.
Mixpanel
55
Event analytics for product teams.
Amplitude
52
Product analytics and experimentation platform.
Compare side-by-side
MySQL MCP vs Hotjar vs Mixpanel
Pros, cons, pricing, role-fit — all on one page.
Open comparison

One AI Stack pick every week.

The tool we’d pay for this week, why we’d pay for it, and what we’d skip. No promo spam.