Skip to content
VS Code

db gateway for VS Code

io.github.sijunkim/db-gateway

145+ tools across 8 databases: MySQL, PostgreSQL, Redshift, MongoDB, Redis, Kafka, and more

client:VS Code transport:stdio runtime:npm

Install db gateway in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "dbs",
      "description": "DBS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "read-only",
      "description": "READ_ONLY",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mysql",
      "description": "MYSQL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "postgresql",
      "description": "POSTGRESQL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "redshift",
      "description": "REDSHIFT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mongodb",
      "description": "MONGODB",
      "password": true
    },
    {
      "type": "promptString",
      "id": "redis",
      "description": "REDIS",
      "password": true
    },
    {
      "type": "promptString",
      "id": "elasticsearch",
      "description": "ELASTICSEARCH",
      "password": true
    },
    {
      "type": "promptString",
      "id": "kafka",
      "description": "KAFKA",
      "password": true
    },
    {
      "type": "promptString",
      "id": "dynamodb-region",
      "description": "DYNAMODB_REGION",
      "password": true
    },
    {
      "type": "promptString",
      "id": "dynamodb-access-key-id",
      "description": "DYNAMODB_ACCESS_KEY_ID",
      "password": true
    },
    {
      "type": "promptString",
      "id": "dynamodb-secret-access-key",
      "description": "DYNAMODB_SECRET_ACCESS_KEY",
      "password": true
    }
  ],
  "servers": {
    "db-gateway": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "db-gateway"
      ],
      "env": {
        "DBS": "${input:dbs}",
        "READ_ONLY": "${input:read-only}",
        "MYSQL": "${input:mysql}",
        "POSTGRESQL": "${input:postgresql}",
        "REDSHIFT": "${input:redshift}",
        "MONGODB": "${input:mongodb}",
        "REDIS": "${input:redis}",
        "ELASTICSEARCH": "${input:elasticsearch}",
        "KAFKA": "${input:kafka}",
        "DYNAMODB_REGION": "${input:dynamodb-region}",
        "DYNAMODB_ACCESS_KEY_ID": "${input:dynamodb-access-key-id}",
        "DYNAMODB_SECRET_ACCESS_KEY": "${input:dynamodb-secret-access-key}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

db gateway in other clients