Postgres MCP for Zed
io.github.edelciomolina/postgres-mcp
PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.
client:Zed
transport:stdio
runtime:npm
Install Postgres MCP in Zed
~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json
{
"context_servers": {
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@edelciomolina/postgres-mcp"
],
"env": {
"MCP_KEY_HOST": "<MCP_KEY_HOST>",
"MCP_KEY_PORT": "<MCP_KEY_PORT>",
"MCP_KEY_NAME": "<MCP_KEY_NAME>",
"MCP_KEY_USER": "<MCP_KEY_USER>",
"MCP_KEY_PASS": "<MCP_KEY_PASS>",
"MCP_KEY_SSLMODE": "<MCP_KEY_SSLMODE>"
}
}
}
}
Merge this into your existing settings object — do not replace the file. Zed docs