Neon Postgres — Serverless Database for Agent Backends

Pros

• –Branching is transformative for testing — spin up isolated DB branch per PR in seconds
• –Autoscaling to zero eliminates idle compute costs entirely — critical for dev/staging envs
• –pgvector support is first-class — no extension installation friction
• –Connection pooling via PgBouncer built-in, no separate setup required

Cons

• –Cold start latency (500ms–2s) on scale-to-zero can cause p99 spikes in production if not pre-warmed
• –No read replicas on free tier; production workloads need Pro plan for replica support
• –Storage pricing per GiB/month adds up at scale — not cost-competitive vs RDS for large datasets
• –Branching does not copy large binary data efficiently — slow for branches with GB-scale blobs