Database Schema

packages/db/
├── src/
│   └── supabase/
│       └── schema/           # Table definitions (Drizzle)
│           ├── index.ts      # Central re-export
│           ├── submissions.ts
│           ├── policies.ts
│           └── ...
├── migrations/
│   └── postgres/             # SQL migration files (0000–0081+)
│       ├── 0000_kind_famine.sql
│       ├── ...
│       └── meta/             # Drizzle migration journal
├── seeds/
│   └── demo-data.sql         # Demo seed data
└── drizzle.config.ts         # Drizzle CLI config

import { createDb } from '@openinsure/db';

// In a Cloudflare Worker handler:
const db = createDb(env.HYPERDRIVE);
// env.HYPERDRIVE is the Cloudflare Hyperdrive binding
// configured in wrangler.toml under [[hyperdrive]]

await db.transaction(async (tx) => {
  await setOrgContext(tx, orgId); // MUST be called inside transaction
  const policies = await tx.select().from(schema.policies);
  // Only returns policies for this org
});

# Generate a new migration from schema changes
cd packages/db
pnpm drizzle-kit generate

# Apply migrations to the database
pnpm drizzle-kit push

# Or run via the migration job (CI/CD)
DATABASE_URL=$DATABASE_URL pnpm drizzle-kit migrate

pscale shell openinsure main < packages/db/seeds/demo-data.sql

# Create a branch for a feature
pscale branch create openinsure feat/my-feature

# Run migrations against the branch
DATABASE_URL=$(pscale connect openinsure feat/my-feature --execute 'echo') pnpm drizzle-kit push

# Delete branch when done
pscale branch delete openinsure feat/my-feature