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