Prototype or sync a database schema directly from prisma/schema.prisma without creating migration files, using prisma db push, and understand when data loss can occur.

Documented steps

1. Confirm prisma.config.ts datasource.url points at the target database (env("DATABASE_URL")).
2. Edit prisma/schema.prisma with your desired model/field changes.
3. Run `npx prisma db push` to make the database schema match the Prisma schema. It creates the database if it doesn't exist and does not write anything to prisma/migrations or _prisma_migrations.
4. If the command reports it would cause data loss (e.g. dropping a column or making a column required on a table with existing rows), it aborts by default. Re-run with `npx prisma db push --accept-data-loss` only if you've confirmed the loss is acceptable.
5. To wipe and recreate the database from the current schema (e.g. an unrecoverable dev database state), run `npx prisma db push --force-reset` — this drops all data.
6. Run `npx prisma generate` afterward to regenerate Prisma Client — v7's db push no longer runs generate automatically (the old --skip-generate flag was removed because generate is opt-in now).
7. Reference: https://www.prisma.io/docs/cli/db/push, https://www.prisma.io/docs/orm/reference/prisma-cli-reference