postgres mcp for VS Code
io.github.pgedge/postgres-mcp
Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI
client:VS Code
transport:stdio
runtime:oci
Install postgres mcp in VS Code
.vscode/mcp.json
{
"servers": {
"postgres-mcp": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pgedge/postgres-mcp:latest"
]
}
}
}
Requires agent mode. MCP: Open User Configuration puts the same block in every workspace. VS Code docs