Give Claude Desktop, Cursor & Windsurf Read-Only SQL & EXPLAIN ANALYZE Access
Enforces read-only transactions, row-count caps, PII column masking, and automatic ER-diagram schema discovery over stdio or SSE.
Interactive Build-vs-Buy Engineering Calculator
Save ~42 Engineering Hours vs. Building From Scratch
Free OSS / $49 Pro Cloud
Instant Digital License • Merchant of Record
{
"mcpServers": {
"pgguard-postgres": {
"command": "npx",
"args": [
"-y",
"@utilforge/pgguard-mcp-server"
],
"env": {
"DATABASE_URL": "postgresql://readonly_user:secret@localhost:5432/prod_replica",
"MAX_ROWS": "250",
"MASK_PII_COLUMNS": "true"
}
}
}
}
What’s Included in PgGuard Postgres MCP
- Strict BEGIN READ ONLY transaction wrapper with statement timeout
- Automatic PII redaction for email, SSN, and token columns
- Built-in EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON) index advisor tool
- Works in Claude Desktop, Cursor, Windsurf, and Zed in 30 seconds