Prisma Orm V7 Skills

1---2name: prisma-orm-v7-skills3description: Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting4---5 6## Links7 8- Upgrade guide (v7): https://www.prisma.io/docs/orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-79- Prisma Config reference: https://www.prisma.io/docs/orm/reference/prisma-config-reference10- Prisma Client Extensions: https://www.prisma.io/docs/orm/prisma-client/client-extensions11- Prisma 7 migration prompt (AI agents): https://www.prisma.io/docs/ai/prompts/prisma-712 13## Upgrade14 15```sh16# Upgrade packages17pnpm add @prisma/client@718pnpm add -D prisma@719```20 21## Breaking Changes (v7)22 23### Minimum versions24 25- Node.js: 20.19.0+ (and 22.x)26- TypeScript: 5.4.0+27 28### Prisma is now ESM29 30- Prisma ORM ships as ES modules.31- Set `"type": "module"` in `package.json` (or migrate your project to ESM).32- TypeScript projects must compile/resolve ESM (guide example: `module: ESNext`, `target: ES2023`, `moduleResolution: node`).33 34### Prisma schema + generation changes35 36- Generator provider: `prisma-client-js` → `prisma-client`.37- `output` is required in `generator client`.38- Prisma Client is no longer generated into `node_modules` by default.39- After `npx prisma generate`, update imports to your generated output path (example:40	`import { PrismaClient } from './generated/prisma/client'`).41 42Schema datasource deprecations:43 44- `url`, `directUrl`, `shadowDatabaseUrl` in `schema.prisma` are deprecated.45- Move datasource config to `prisma.config.ts` (Prisma Config).46- If you used `directUrl` for migrations, set the CLI migration connection string in `prisma.config.ts`.47 48### Driver adapters required for Prisma Client (new instantiation)49 50- Prisma Client creation now requires a driver adapter for all databases.51- Example adapters:52	- Postgres: `@prisma/adapter-pg` (use `PrismaPg` with a direct DB connection string)53	- SQLite: `@prisma/adapter-better-sqlite3`54 55### Prisma Accelerate users (v6 → v7)56 57- Do not pass `prisma://` or `prisma+postgres://` (Accelerate URLs) to a driver adapter.58- Keep the Accelerate URL and instantiate Prisma Client with the Accelerate extension instead.59 60### Env vars are not loaded by default61 62- Prisma CLI no longer auto-loads `.env` files in v7.63- Explicitly load env vars (for example `import 'dotenv/config'` in `prisma.config.ts`, or load env in your scripts).64- Bun users: no change required (bun auto-loads `.env`).65 66### Prisma CLI config moved to `prisma.config.ts`67 68- Prisma Config is now the default place to configure how Prisma CLI behaves.69- Place `prisma.config.ts` at the project root (next to `package.json`).70- Configure schema path, migrations path/seed, and datasource URL there.71 72### Client middleware removed73 74- `prisma.$use(...)` is removed.75- Migrate middleware logic to Prisma Client Extensions.76 77### Metrics removed from Client Extensions78 79- The Metrics preview feature is removed in v7.80- Use your database driver/adapter or implement custom counters via extensions.81 82### Migrate/seed/generate behavior changes83 84- Automatic seeding after `prisma migrate dev` / `prisma migrate reset` is removed.85	- Run seeding explicitly: `pnpm prisma db seed` (or `pnpm exec prisma db seed`).86- `--skip-generate` and `--skip-seed` flags removed.87- `prisma migrate dev` and `prisma db push` no longer run `prisma generate` automatically.88	- Run `pnpm prisma generate` (or `pnpm exec prisma generate`) explicitly.89 90### Prisma-specific env vars removed91 92- Removed env vars:93	- `PRISMA_CLI_QUERY_ENGINE_TYPE`94	- `PRISMA_CLIENT_ENGINE_TYPE`95	- `PRISMA_QUERY_ENGINE_BINARY`96	- `PRISMA_QUERY_ENGINE_LIBRARY`97	- `PRISMA_GENERATE_SKIP_AUTOINSTALL`98	- `PRISMA_SKIP_POSTINSTALL_GENERATE`99	- `PRISMA_GENERATE_IN_POSTINSTALL`100	- `PRISMA_GENERATE_DATAPROXY`101	- `PRISMA_GENERATE_NO_ENGINE`102	- `PRISMA_CLIENT_NO_RETRY`103	- `PRISMA_MIGRATE_SKIP_GENERATE`104	- `PRISMA_MIGRATE_SKIP_SEED`105 106### MongoDB support107 108- Prisma ORM 7 does not support MongoDB yet; stay on Prisma ORM 6 if you need MongoDB.109 110## Upgrade Checklist (quick)111 112- Upgrade packages; confirm Node/TypeScript versions.113- Move to ESM (or adjust your runtime/build to consume ESM).114- Update `schema.prisma` generator to `provider = "prisma-client"` and set `output`.115- Run `pnpm prisma generate` and update Prisma Client imports to the generated output path.116- Add `prisma.config.ts` at repo root; move datasource config and load env explicitly.117- Update Prisma Client instantiation to use a driver adapter (unless using Accelerate).118- Update workflows: run `pnpm prisma generate` and `pnpm prisma db seed` explicitly.