Skip to content
VS Code

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

MySQL MCP Server in other clients