MySQL MCP Server for VS Code
io.github.musaddiq-dev/mysql-mcp-server
Python MCP server for MySQL database inspection and querying
client:VS Code
transport:stdio
runtime:pypi
Install MySQL MCP Server in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "mysql-host",
"description": "MYSQL_HOST",
"password": true
},
{
"type": "promptString",
"id": "mysql-port",
"description": "MYSQL_PORT",
"password": true
},
{
"type": "promptString",
"id": "mysql-user",
"description": "MYSQL_USER",
"password": true
},
{
"type": "promptString",
"id": "mysql-password",
"description": "MYSQL_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "mysql-database",
"description": "MYSQL_DATABASE",
"password": true
},
{
"type": "promptString",
"id": "mysql-pool-size",
"description": "MYSQL_POOL_SIZE",
"password": true
},
{
"type": "promptString",
"id": "log-level",
"description": "LOG_LEVEL",
"password": true
},
{
"type": "promptString",
"id": "mysql-read-query-limit",
"description": "MYSQL_READ_QUERY_LIMIT",
"password": true
}
],
"servers": {
"mysql-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": [
"mdev-mysql-mcp-server"
],
"env": {
"MYSQL_HOST": "${input:mysql-host}",
"MYSQL_PORT": "${input:mysql-port}",
"MYSQL_USER": "${input:mysql-user}",
"MYSQL_PASSWORD": "${input:mysql-password}",
"MYSQL_DATABASE": "${input:mysql-database}",
"MYSQL_POOL_SIZE": "${input:mysql-pool-size}",
"LOG_LEVEL": "${input:log-level}",
"MYSQL_READ_QUERY_LIMIT": "${input:mysql-read-query-limit}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs