pgops for Zed
io.github.arzharch/pgops-mcp
Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers
client:Zed
transport:stdio
runtime:pypi
Install pgops in Zed
~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json
{
"context_servers": {
"pgops-mcp": {
"command": "uvx",
"args": [
"pgops-mcp"
],
"env": {
"PGOPS_DSN": "<PGOPS_DSN>",
"PGOPS_READONLY_DSN": "<PGOPS_READONLY_DSN>",
"PGOPS_READ_ONLY": "<PGOPS_READ_ONLY>",
"PGOPS_APPROVAL_MODE": "<PGOPS_APPROVAL_MODE>",
"PGOPS_AUDIT_LOG": "<PGOPS_AUDIT_LOG>",
"PGOPS_DEFAULT_TIMEOUT_MS": "<PGOPS_DEFAULT_TIMEOUT_MS>",
"PGOPS_MAX_TIMEOUT_MS": "<PGOPS_MAX_TIMEOUT_MS>",
"PGOPS_DEFAULT_ROW_LIMIT": "<PGOPS_DEFAULT_ROW_LIMIT>"
}
}
}
}
Merge this into your existing settings object — do not replace the file. Zed docs