DBeast PostgreSQL MCP for VS Code
io.github.snss10/dbeast
PostgreSQL MCP server for schema, query, health, security, and performance analysis.
client:VS Code
transport:stdio
runtime:oci
Install DBeast PostgreSQL MCP in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "database-url",
"description": "DATABASE_URL",
"password": true
},
{
"type": "promptString",
"id": "db-host",
"description": "DB_HOST",
"password": true
},
{
"type": "promptString",
"id": "db-port",
"description": "DB_PORT",
"password": true
},
{
"type": "promptString",
"id": "db-user",
"description": "DB_USER",
"password": true
},
{
"type": "promptString",
"id": "db-password",
"description": "DB_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "db-name",
"description": "DB_NAME",
"password": true
},
{
"type": "promptString",
"id": "aws-secret-name",
"description": "AWS_SECRET_NAME",
"password": true
},
{
"type": "promptString",
"id": "aws-region",
"description": "AWS_REGION",
"password": true
}
],
"servers": {
"dbeast": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/snss10/dbeast:2.0.2"
],
"env": {
"DATABASE_URL": "${input:database-url}",
"DB_HOST": "${input:db-host}",
"DB_PORT": "${input:db-port}",
"DB_USER": "${input:db-user}",
"DB_PASSWORD": "${input:db-password}",
"DB_NAME": "${input:db-name}",
"AWS_SECRET_NAME": "${input:aws-secret-name}",
"AWS_REGION": "${input:aws-region}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs