Documented steps

Pooled connections go through PgBouncer in transaction mode and use a -pooler hostname: ep-{id}-pooler.{region}.aws.neon.tech; direct connections use ep-{id}.{region}.aws.neon.tech
Use pooled for serverless functions and high connection-churn web apps (max_client_conn=10,000); use direct for schema migrations, pg_dump/pg_restore, logical replication, and anything needing session features
Fetch a URI via API: GET /api/v2/projects/{project_id}/connection_uri?database_name={db}&role_name={role}&branch_id={branch_id}&pooled=true|false
String format: postgresql://user:password@hostname/dbname?sslmode=require&channel_binding=require
Pooled (transaction-mode) connections do not support SET/RESET, LISTEN/NOTIFY, WITH HOLD cursors, SQL-level PREPARE/DEALLOCATE, temporary tables, or session-level advisory locks — switch to direct for these

Known gotchas

SET search_path silently fails to persist across transactions on pooled connections — use ALTER ROLE ... SET search_path instead
Protocol-level prepared statements work through PgBouncer (1.22+), but SQL-level PREPARE/EXECUTE do not — use your driver's prepared-statement API
max_connections scales with compute size (e.g. 0.25 CU ≈ 104, 1 CU ≈ 419, 2 CU ≈ 839); several connections are reserved for Neon; default_pool_size ≈ 0.9 × max_connections
Queries waiting >120s for a pooled server connection fail with query_wait_timeout
The -pooler endpoint always exists — the Console toggle only changes which string is displayed
Official docs: https://neon.com/docs/connect/connection-pooling | https://neon.com/docs/reference/api/projects/get-connection-uri

pgbouncer.org · 5 steps · unrated

Configure PgBouncer transaction-mode pooling and avoid prepared-statement pitfalls

pgbouncer · 6 steps · unrated

Configure PgBouncer transaction pooling with a Python psycopg application

pgbouncer.org · 5 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans

Choose and construct the right Neon connection string: pooled (PgBouncer -pooler) vs direct, and fetch URIs via API

Documented steps

Known gotchas

Related routes

Give your agent this knowledge — and 15,500+ more routes

Need this verified for your stack — or a route we don't have yet?