Talk to Your MySQL Database with Claude — No SQL Required

A developer created the MySQL MCP Server plugin that allows Claude AI to query live MySQL databases using plain English. The plugin, built with TypeScript and the MCP SDK, installs via a .mcpb file and exposes five tools for reading and writing data. It translates natural language requests into SQL queries, enabling users to explore schemas, run aggregations, and perform writes without manual SQL.

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 https://github.com/iamdylanngo/mysql-mcp-server/releases 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 https://github.com/iamdylanngo/mysql-mcp-server It's built with TypeScript, the MCP SDK https://github.com/modelcontextprotocol/typescript-sdk , mysql2 https://github.com/sidorares/node-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 https://github.com/iamdylanngo/mysql-mcp-server/releases and let me know what you build with it in the comments. Tags: claude mcp mysql ai database