prisma-orm-v7-skills

Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting

By gocallum · 1,002 installs

npx skills add gocallum/nextjs16-agent-skills --skill prisma-orm-v7-skills

Source repository · Upstream listing

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 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.