prisma-upgrade-v7

Update @prisma/client and prisma to version 7, switch the generator provider to prisma-client with an explicit output path, create prisma.config.ts, install a driver adapter such as @prisma/adapter-pg, update client imports and instantiation, then run prisma generate.

A driver adapter connects Prisma Client to SQL databases through native Node.js drivers instead of a bundled engine binary. Prisma 7 requires adapters like @prisma/adapter-pg for PostgreSQL or @prisma/adapter-mariadb for MySQL, giving smaller bundles and better serverless compatibility.

No, Prisma 7 has no MongoDB connector and no MongoDB driver adapter package. MongoDB projects should stay on the latest Prisma 6.x release or migrate to Prisma Next instead of following the standard v7 SQL migration path.

Yes, Prisma 7 is ESM-first but supports CommonJS by setting moduleFormat = "cjs" in the generator block. Keep your app as CommonJS, regenerate the client, and ensure tsconfig module settings match the chosen format.

Prisma 7 no longer loads .env files automatically, so DATABASE_URL is undefined unless you load it explicitly. Install dotenv and add import 'dotenv/config' as the first line of prisma.config.ts, or rely on Bun's automatic .env loading.

Prisma.validator is replaced by TypeScript's satisfies operator, for example satisfies Prisma.UserSelect. The $use middleware API is removed; use Client Extensions with $extends and query hooks for logging, soft deletes, and similar cross-cutting behavior.