Set up MySQL MCP in Claude Code
Execute SQL queries against MySQL databases. Inspect schemas, run queries, and analyze data from your AI editor.
1
Locate the config file
Claude Code reads MCP server configuration from the following file:
~/.claude.jsonCreate this file if it does not already exist.
2
Add the configuration
You can configure MySQL MCP using the CLI command or by editing the config file directly.
Option A: CLI command
bash
claude mcp add mysql-mcp -e MYSQL_HOST=YOUR_MYSQL_HOST -e MYSQL_USER=YOUR_MYSQL_USER -e MYSQL_PASSWORD=YOUR_MYSQL_PASSWORD -e MYSQL_DATABASE=YOUR_MYSQL_DATABASE -- npx -y mysql-mcpOption B: Config file
json
{
"mcpServers": {
"mysql-mcp": {
"command": "npx",
"args": [
"-y",
"mysql-mcp"
],
"env": {
"MYSQL_HOST": "YOUR_MYSQL_HOST",
"MYSQL_USER": "YOUR_MYSQL_USER",
"MYSQL_PASSWORD": "YOUR_MYSQL_PASSWORD",
"MYSQL_DATABASE": "YOUR_MYSQL_DATABASE"
}
}
}
}3
Set up environment variables
MySQL MCP requires the following environment variables:
MYSQL_HOSTRequiredMySQL host
MYSQL_USERRequiredMySQL username
MYSQL_PASSWORDRequiredMySQL password
MYSQL_DATABASERequiredMySQL database name
4
Verify it works
Restart Claude Code. MySQL MCP should appear in your MCP server list with 6 tools available.
This server adds approximately 3,090 tokens to your context window for tool definitions.