StackMCP

Set up MySQL MCP in VS Code

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

1

Locate the config file

VS Code reads MCP server configuration from the following file:

.vscode/settings.json → mcp section

Create this file if it does not already exist. For VS Code, this is inside your workspace .vscode/settings.json file under the mcp section.

2

Add the configuration

Add the following to your VS Code config file:

json
{
  "servers": {
    "mysql-mcp": {
      "type": "stdio",
      "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_HOSTRequired

MySQL host

MYSQL_USERRequired

MySQL username

MYSQL_PASSWORDRequired

MySQL password

MYSQL_DATABASERequired

MySQL database name

4

Verify it works

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

Set up MySQL MCP in other editors

Claude CodeCursorWindsurfClaude DesktopContinue
← Back to MySQL MCP