Query and manage PostgreSQL databases from Claude Code, Cursor, and any MCP client, with read-only by default and built-in schema introspection, EXPLAIN, and performance diagnostics.
Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find.
Install from
M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.
process.env. You'll be asked to provide them before it can run.ALLOW_WRITES— EXPLAIN as a first-class tool - text or JSON format, with optional ANALYZE. ANALYZE for non-SELECT statements requires =1 and always rolls back, so the plan is real but the write doesn't persist.DATABASE_URL— "": "postgres://user:password@host:5432/dbname"POSTGRES_CONNECTION_TIMEOUT_MS— 10000 TCP connect timeout. Without this, a dead host hangs until the OS gives up (~2 minutes).POSTGRES_MAX_ROWS— Result truncation - large result sets are capped at (default 1000) with a truncated: true flag, so a stray SELECT FROM events doesn't blow out the model context.POSTGRES_MCP_INTEGRATION— DATABASE_URL='postgres://user:pass@host:5432/db' =1 npm run test:integrationPOSTGRES_POOL_MAX— 5 Max pool connections. Set to 1 for single-threaded backends (pglite-socket, PgBouncer transaction mode).POSTGRES_SSL_REJECT_UNAUTHORIZED— unset Set to false to skip TLS cert verification (for managed DBs using private-CA certs). Connection is still encrypted.POSTGRES_STATEMENT_TIMEOUT_MS— 30000 Per-statement timeout.[](https://m8ven.ai/mcp/yawlabs-postgres-mcp-10h055)