prisma-orm-v7-skills

## Links - Upgrade guide (v7): https://www.prisma.io/docs/orm/more/upgrade-guides/upgrading-versions/upgrading-to-prisma-7 - Prisma Config reference: https://www.prisma.io/docs/orm/reference/prisma-config-reference - Prisma Client Extensions: https://www.prisma.io/docs/orm/prisma-client/client-extensions - Prisma 7 migration prompt (AI agents): https://www.prisma.io/docs/ai/prompts/prisma-7 ## Upgrade ```sh # Upgrade packages pnpm add @prisma/client@7 pnpm add -D prisma@7 ``` ## Breaking Changes (v7) ### Minimum versions - Node.js: 20.19.0+ (and 22.x) - TypeScript: 5.4.0+ ### Prisma is now ESM - Prisma ORM ships as ES modules. - Set `"type": "module"` in `package.json` (or migrate your project to ESM). - TypeScript projects must compile/resolve ESM (guide example: `module: ESNext`, `target: ES2023`, `moduleResolution: node`). ### Prisma schema + generation changes - Generator provider: `prisma-client-js` → `prisma-client`. - `output` is required in `generator client`. - Prisma Client is no longer generated into `node_modules` by default. - After `npx prisma generate`, update imports to your generated output path (example: `import { PrismaClient } from './generated/prisma/client'`). Schema datasource deprecations: - `url`, `directUrl`, `shadowDatabaseUrl` in `schema.prisma` are deprecated. - Move datasource config to `prisma.config.ts` (Prisma Config). - If you used `directUrl` for migrations, set the CLI migration connection string in `prisma.config.ts`. ### Driver adapters required for Prisma Client (new instantiation) - Prisma Client creation now requires a driver adapter for all databases. - Example adapters: - Postgres: `@prisma/adapter-pg` (use `PrismaPg` with a direct DB connection string) - SQLite: `@prisma/adapter-better-sqlite3` ### Prisma Accelerate users (v6 → v7) - Do not pass `prisma://` or `prisma+postgres://` (Accelerate URLs) to a driver adapter. - Keep the Accelerate URL and instantiate Prisma Client with the Accelerate extension instead. ### Env vars are not loaded by default - Prisma CLI no longer auto-loads `.env` files in v7. - Explicitly load env vars (for example `import 'dotenv/config'` in `prisma.config.ts`, or load env in your scripts). - Bun users: no change required (bun auto-loads `.env`). ### Prisma CLI config moved to `prisma.config.ts` - Prisma Config is now the default place to configure how Prisma CLI behaves. - Place `prisma.config.ts` at the project root (next to `package.json`). - Configure schema path, migrations path/seed, and datasource URL there. ### Client middleware removed - `prisma.$use(...)` is removed. - Migrate middleware logic to Prisma Client Extensions. ### Metrics removed from Client Extensions - The Metrics preview feature is removed in v7. - Use your database driver/adapter or implement custom counters via extensions. ### Migrate/seed/generate behavior changes - Automatic seeding after `prisma migrate dev` / `prisma migrate reset` is removed. - Run seeding explicitly: `pnpm prisma db seed` (or `pnpm exec prisma db seed`). - `--skip-generate` and `--skip-seed` flags removed. - `prisma migrate dev` and `prisma db push` no longer run `prisma generate` automatically. - Run `pnpm prisma generate` (or `pnpm exec prisma generate`) explicitly. ### Prisma-specific env vars removed - Removed env vars: - `PRISMA_CLI_QUERY_ENGINE_TYPE` - `PRISMA_CLIENT_ENGINE_TYPE` - `PRISMA_QUERY_ENGINE_BINARY` - `PRISMA_QUERY_ENGINE_LIBRARY` - `PRISMA_GENERATE_SKIP_AUTOINSTALL` - `PRISMA_SKIP_POSTINSTALL_GENERATE` - `PRISMA_GENERATE_IN_POSTINSTALL` - `PRISMA_GENERATE_DATAPROXY` - `PRISMA_GENERATE_NO_ENGINE` - `PRISMA_CLIENT_NO_RETRY` - `PRISMA_MIGRATE_SKIP_GENERATE` - `PRISMA_MIGRATE_SKIP_SEED` ### MongoDB support - Prisma ORM 7 does not support MongoDB yet; stay on Prisma ORM 6 if you need MongoDB. ## Upgrade Checklist (quick) - Upgrade packages; confirm Node/TypeScript versions. - Move to ESM (or adjust your runtime/build to consume ESM). - Update `schema.prisma` generator to `provider = "prisma-client"` and set `output`. - Run `pnpm prisma generate` and update Prisma Client imports to the generated output path. - Add `prisma.config.ts` at repo root; move datasource config and load env explicitly. - Update Prisma Client instantiation to use a driver adapter (unless using Accelerate). - Update workflows: run `pnpm prisma generate` and `pnpm prisma db seed` explicitly.