Quick Tip: One Neon Branch Per Pull Request — Free Postgres Previews in 5 Minutes

说明与用途

团队可以为每个 Pull Request 自动创建免费的 Neon 分支，运行迁移，并在 PR 关闭时删除分支，节省成本并提高 CI 隔离性。

问题

Teams pay $50‑$200/month for staging databases, but need a fresh preview database per PR for CI and testing.

结果

Teams can provision a free, per‑PR Postgres preview database in under 5 minutes, eliminating staging costs and improving CI isolation.

工作流

• Trigger GitHub Action on pull_request
• Create Neon branch via API call and capture branch ID
• Run database migrations (e.g., alembic upgrade head) against the new branch
• Delete the Neon branch when PR is closed

证据

Neon's free tier gives you 10 branches of serverless Postgres — and branches are instant copy-on-write clones.

来源

Branch creation: ~1 second, regardless of DB size (copy-on-write). Storage: 0.5GB free per branch, 3GB project total.

来源