Postgres deployment

Create one database per environment. For Fabric-managed staging, use a Neon project named fabric-experiments-staging; other Postgres providers are valid if migrations pass.

export DATABASE_URL=postgres://...
for f in infra/neon/migrations/*.sql; do
  psql "$DATABASE_URL" -f "$f"
done

Store the resulting DATABASE_URL in the staging secrets vault and in the API deployment environment.

Test strategy

Better Auth integration tests should use real Postgres via Testcontainers, service-container Postgres, or per-PR Neon branches. Avoid pglite/Kysely dialect shortcuts for production auth confidence.