Prisma is used for database access. The schema lives in backend/prisma/schema.prisma.

Generate Prisma client

pnpm --dir backend run prisma:generate

Run migrations locally

pnpm --dir backend run prisma:migrate:dev

Deploy migrations

pnpm --dir backend run prisma:migrate

Connection string

The API and ingestion worker both read DATABASE_URL from the environment.