prisma-orm-v7-skills AI Agent Skill

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

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