Database

The database stance is Postgres-first.

Fabric-managed environments run on Databricks Lakebase Postgres via DATABASE_PROVIDER=databricks-lakebase (see Databricks deployment). The migrations also run against standard Postgres providers such as Neon, RDS Postgres, Cloud SQL Postgres, Supabase Postgres, Crunchy, or local/Testcontainers Postgres.

Migrations

Migrations are provider-neutral Postgres migrations. They live in infra/neon/migrations (the directory name is historical):

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
11. 011_preview_secrets.sql
12. 012_api_keys.sql
13. 013_rename_org_to_tenant.sql
14. 014_workspace_resources.sql
15. 015_test_runs.sql
16. 016_enterprise_identity.sql
17. 017_scim_group_provisioning.sql
18. 018_governance_settings.sql
19. 019_datasets_evals.sql
20. 020_eval_run_outbox.sql
21. 022_traces.sql (021 is intentionally unused)
22. 023_ingest_tokens.sql
23. 024_prompts_playground.sql
24. 025_stripe_webhook_state.sql

Apply them in order for every new environment.

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