Requires the runtime declared in the upstream repo — check the README before running. VS Code (Copilot) uses a `servers` root key with an explicit `type` field — different from the `mcpServers` shape used by Claude Desktop and Cursor. Paste the config below, then follow the reload step to register @cano721/mysql-mcp-server.
.vscode/mcp.json (project root — committed with the repo)~/.vscode/mcp.json{
"servers": {
"mysql": {
"type": "stdio",
"command": "npx",
"args": [
"@cano721/mysql-mcp-server@latest"
],
"env": {
"MYSQL_HOST": "your-mysql-host",
"MYSQL_PORT": "3306",
"MYSQL_USER": "your-mysql-user",
"MYSQL_PASSWORD": "your-mysql-password",
"MYSQL_DATABASE": "your-default-database",
"MYSQL_CONNECTION_LIMIT": "1",
"MYSQL_QUERY_TIMEOUT": "60000",
"MYSQL_QUEUE_LIMIT": "0",
"MYSQL_CONNECT_TIMEOUT": "10000",
"MYSQL_IDLE_TIMEOUT": "60000",
"MYSQL_MAX_IDLE": "10",
"MYSQL_ALLOW_EXPLAIN": "true",
"MYSQL_ALLOW_ANALYZE": "true"
}
}
}
}