Set up MySQL MCP in Windsurf

Execute SQL queries against MySQL databases. Inspect schemas, run queries, and analyze data from your AI editor.

Locate the config file

Windsurf reads MCP server configuration from the following file:

~/.codeium/windsurf/mcp_config.json

Create this file if it does not already exist.

Add the configuration

Add the following to your Windsurf 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"
      }
    }
  }
}

Set up environment variables

MySQL MCP requires the following environment variables:

MYSQL_HOSTRequired

MySQL host

MYSQL_USERRequired

MySQL username

MYSQL_PASSWORDRequired

MySQL password

MYSQL_DATABASERequired

MySQL database name

Verify it works

Restart Windsurf. 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.

Set up MySQL MCP in other editors

Claude Code Cursor VS Code Claude Desktop Continue

← Back to MySQL MCP