If you use Claude daily, you already know it's great for writing, coding, and answering questions. But what if Claude could also query your live MySQL database — in plain English?
That's exactly what the MySQL MCP Server plugin makes possible. In this tutorial, I'll show you how to install it and start having real conversations with your database in under five minutes.
MCP (Model Context Protocol) is an open standard that lets AI assistants like Claude connect to external tools and data sources. Think of it as a plugin system: instead of copy-pasting data into Claude's chat window, you connect Claude directly to the source.
With an MCP server running, Claude can read and write data in real time — no manual exports, no SQL gymnastics.
Once connected, you can ask Claude things like:
Claude translates your plain-English request into the right SQL query, runs it, and gives you a human-readable answer. You stay in the conversation — no switching to a SQL client.
Head to the Releases page and download the latest .mcpb
file:
mysql-mcp-server-v1.0.1.mcpb
.mcpb
is Claude's plugin bundle format — a single file that contains everything needed to run the server.
Option A — Claude Code (CLI):
claude plugin install mysql-mcp-server-v1.0.1.mcpb
Option B — Claude Desktop:
Double-click the .mcpb
file. Claude Desktop will detect it and open an install prompt.
After installation, Claude will ask for your connection details. Fill in the fields:
| Field | Example | Notes |
|---|---|---|
| Database Host | 127.0.0.1 |
|
| Use your server IP for remote databases | ||
| Database Port | 3306 |
|
| Default MySQL port | ||
| Database User | root |
|
| Use a least-privilege user in production | ||
| Database Password | •••••• |
|
| Stored securely | ||
| Database Name | mydb |
|
| The specific database to connect to | ||
| Connection Pool Limit | 10 |
|
| Max concurrent connections |
Tip:For production use, create a dedicated read-only MySQL user for Claude. This prevents accidental writes if you only need to query data.
You can update these settings at any time from Claude's plugin settings under MySQL MCP Server.
Once connected, start a new conversation in Claude and try these prompts:
Explore your schema:
"What tables do I have? Give me a quick summary of what each one stores."
Query data in plain English:
"Show me the 10 most recent signups with their email and created date."
Get aggregations without writing SQL:
"How many orders are in each status? Show me a breakdown."
Write data when you need to:
"Set the
is_active
flag to false for all users who haven't logged in since January."
Claude will show you the SQL it's about to run before executing write operations, so you're always in control.
The plugin exposes five tools that Claude uses behind the scenes:
| Tool | What it does |
|---|---|
select_mysql_version |
|
| Returns the MySQL server version | |
list_tables |
|
| Lists all tables in the connected database | |
describe_table |
|
| Shows columns, types, and constraints for a table | |
query |
|
Runs a read-only SELECT query |
|
mutate |
|
Runs INSERT , UPDATE , or DELETE statements |
mutate
rejects SELECT
statements — reads and writes are intentionally separated.
The source is on GitHub: iamdylanngo/mysql-mcp-server
It's built with TypeScript, the MCP SDK, mysql2, and Zod for input validation. PRs and issues are welcome.
The MySQL MCP Server bridges the gap between Claude's language understanding and your real data. If you've ever wanted to ask questions about your database the same way you'd ask a colleague, this is the plugin to try.
Download it from the Releases page and let me know what you build with it in the comments.
Tags: claude mcp mysql ai database