MySQL MCP Server

A Model Context Protocol (MCP) server that connects Claude (or any MCP-compatible client) to a MySQL database. It exposes tools for schema inspection and running read/write queries over a stdio transport.

Tools

Note: mutate rejects SELECT statements — use query for reads.

Related MCP server: mcp-mysql-server

Requirements

• Node.js 18+

• A running MySQL instance

Quick Install (Recommended)

1. Download the plugin

Go to the Releases page and download the latest .mcpb file (e.g. mysql-mcp-server-v1.0.1.mcpb).

2. Install the plugin

Via Claude Code CLI:

claude plugin install mysql-mcp-server-v1.0.1.mcpb

Via Claude Desktop:

Double-click the .mcpb file — Claude Desktop will prompt you to install it.

3. Configure your database connection

After installation, Claude will prompt you to fill in your connection details:

You can update these settings at any time in Claude's plugin settings under MySQL MCP Server.

Manual Setup (from source)

1. Clone and install dependencies

git clone https://github.com/iamdylanngo/mysql-mcp-server
cd mcp
npm install

2. Configure environment

Copy the sample env file and fill in your database credentials:

cp .env.sample .env

DB_HOST=127.0.0.1
DB_PORT=3306
DB_USER=root
DB_PASSWORD=root
DB_NAME=mydb
DB_POOL_LIMIT=10

3. Build

npm run build

Usage

Run directly

node --env-file=.env build/index.js

Inspect with MCP Inspector

npm run mcp

Connect to Claude Desktop

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": ["/[absolute-path]/mysql-mcp-server/build/index.js"],
      "env": {
        "DB_HOST": "127.0.0.1",
        "DB_PORT": "3306",
        "DB_USER": "root",
        "DB_PASSWORD": "your_password",
        "DB_NAME": "your_database",
        "DB_POOL_LIMIT": "10"
      }
    }
  }
}

Environment Variables

Tech Stack

• MCP SDK — MCP server framework

• mysql2 — MySQL client with promise support

• Zod — Input schema validation

• TypeScript

License

MIT