MySQL MCP Server
MySQL database integration with configurable access controls and schema inspection.
- Maintained by
- Community (benborla)
- Hosting
- Runs locally on your machine
- Authentication
- API key or credentials (environment variables)
- Last checked
How to connect the MySQL MCP server
Pick your AI client and paste the snippet. Swap the YOUR_… placeholders for your own values. New to this? Our guide to how MCP clients and servers fit together explains what each piece does.
Claude Code
claude mcp add --env MYSQL_HOST=127.0.0.1 --env MYSQL_PORT=3306 --env MYSQL_USER=YOUR_USER --env MYSQL_PASS=YOUR_PASSWORD --env MYSQL_DB=YOUR_DATABASE --transport stdio mysql \
-- npx -y @benborla29/mcp-server-mysqlClaude Desktop
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "YOUR_USER",
"MYSQL_PASS": "YOUR_PASSWORD",
"MYSQL_DB": "YOUR_DATABASE"
}
}
}
}Fully quit and reopen Claude Desktop after saving.
Full Claude Desktop setup guide →Cursor
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "YOUR_USER",
"MYSQL_PASS": "YOUR_PASSWORD",
"MYSQL_DB": "YOUR_DATABASE"
}
}
}
}VS Code
{
"servers": {
"mysql": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@benborla29/mcp-server-mysql"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "YOUR_USER",
"MYSQL_PASS": "YOUR_PASSWORD",
"MYSQL_DB": "YOUR_DATABASE"
}
}
}
}Frequently asked questions
What is the MySQL MCP server?
It is a Model Context Protocol (MCP) server — a small piece of software that gives AI assistants like Claude a secure, governed connection to MySQL. MySQL database integration with configurable access controls and schema inspection.
Is there an official MySQL MCP server?
Not from MySQL itself. This one is community-maintained (benborla). It is widely used, but review the repository and pin a version before relying on it in production.
Is the MySQL MCP server hosted, or do I run it myself?
It runs locally. Your AI client starts it on your own machine with npx, and it talks to the client over standard input and output rather than the network.
Do I need an API key for the MySQL MCP server?
Yes. The local server reads MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB from its environment, so you create those credentials first and add them to your client's config.
What can an AI assistant actually do with MySQL?
Through this server an assistant can work with sql, schema, query, access control — reading from and acting on MySQL directly instead of you copy-pasting between windows. What you allow it to do is controlled by the permissions you grant.
How do I set this up for my business?
The setup section above has copy-paste config for Claude Code, Claude Desktop, Cursor and VS Code. If you want it rolled out across a team with permissions, governance and support handled, that is what Crox's Build engagement covers.
New to MCP? Start with our plain-English guide to the Model Context Protocol or see how to connect AI to your business tools without writing code .
Want this connected to your business — with governance handled?
Crox maps your processes, connects AI to the tools you already use, and keeps it working as models change. Start with a readiness assessment or talk to us about a build.