PostgreSQL MCP Server for Zed
io.github.musaddiq-dev/postgresql-mcp-server
Python MCP server for PostgreSQL database inspection and querying
client:Zed
transport:stdio
runtime:pypi
Install PostgreSQL MCP Server in Zed
~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json
{
"context_servers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>",
"POSTGRES_READ_QUERY_LIMIT": "<POSTGRES_READ_QUERY_LIMIT>"
}
}
}
}
Merge this into your existing settings object — do not replace the file. Zed docs