Database

The database stance is Postgres-first.

Neon is recommended for Fabric-managed hosted staging because it is serverless and easy to branch, but the migrations should run against standard Postgres providers such as RDS Postgres, Cloud SQL Postgres, Supabase Postgres, Crunchy, or local/Testcontainers Postgres.

Migrations

Migrations live in infra/neon/migrations:

1. 001_fx_initial.sql
2. 002_better_auth.sql
3. 003_manifest_keys.sql
4. 004_audit_exports.sql
5. 005_idempotency.sql
6. 006_audit_export_cursor_id.sql
7. 007_billing_ledger.sql
8. 008_byok_config.sql
9. 009_event_retention.sql
10. 010_audit_forward_cursor.sql

Apply them in order for every new environment.

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