Set up MySQL MCP in Cursor
Execute SQL queries against MySQL databases. Inspect schemas, run queries, and analyze data from your AI editor.
1
Locate the config file
Cursor reads MCP server configuration from the following file:
.cursor/mcp.jsonCreate this file if it does not already exist.
2
Add the configuration
Add the following to your Cursor 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 Cursor. 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.