sw-postgres-mcp for VS Code
io.github.jpka/sw-postgres-mcp
Safe-write Postgres MCP server with preview-before-execute writes and rollback safety.
client:VS Code
transport:stdio
runtime:npm
Install sw-postgres-mcp in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "database-url-readonly",
"description": "DATABASE_URL_READONLY",
"password": true
},
{
"type": "promptString",
"id": "database-url-writer",
"description": "DATABASE_URL_WRITER",
"password": true
}
],
"servers": {
"sw-postgres-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"sw-postgres-mcp"
],
"env": {
"DATABASE_URL_READONLY": "${input:database-url-readonly}",
"DATABASE_URL_WRITER": "${input:database-url-writer}"
}
}
}
}VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs