PostgreSQL MCP Server for VS Code
io.github.itunified-io/postgres
PostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management
client:VS Code
transport:stdio
runtime:npm
Install PostgreSQL MCP Server in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "postgres-connection-string",
"description": "POSTGRES_CONNECTION_STRING",
"password": true
}
],
"servers": {
"postgres": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@itunified.io/mcp-postgres"
],
"env": {
"POSTGRES_CONNECTION_STRING": "${input:postgres-connection-string}"
}
}
}
}VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs