---
title: "Prisma ORM v7 upgrade: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/skills/prisma-prisma-upgrade-v7/
description: "Numbered Prisma ORM v6 to v7 migration that requires SQL driver adapters and stops the path for MongoDB."
---

# Prisma ORM v7 upgrade: review, setup & limitations · Undominated.ai

> Numbered Prisma ORM v6 to v7 migration that requires SQL driver adapters and stops the path for MongoDB.

[← Explore all skills](/skills/)

DATABASE MIGRATIONS / Prisma

# Prisma ORM v7 upgrade

Numbered Prisma ORM v6 to v7 migration that requires SQL driver adapters and stops the path for MongoDB.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/prisma/skills/tree/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7)

SOURCE REVIEW

 Reviewed 2026-10-15
 Evidence 5 linked sources
 Publisher Prisma
 Licence [MIT ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/LICENSE)
 Revision be16a8740d01
 [Read what was—and wasn’t—checked ↓](#review)

“Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes. Use when upgrading Prisma versions, encountering v7 errors, or migrating existing projects. Triggers on "upgrade to prisma 7", "prisma 7 migration", "prisma-client generator", "driver adapter required".”

 [Prisma · upstream description ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/SKILL.md) Our analysis follows below.

01 / THE REASONING

## Why this made the selection.

 - The file is a numbered upgrade: prisma-client generator, prisma.config.ts, required SQL driver adapters, and a client import from the generated path.
- It refuses provider = "mongodb" for this path and says MongoDB projects should stay on Prisma 6.x or move to Prisma 8 rather than Prisma 7's SQL client path.

### A good fit for

 - Upgrading a SQL Prisma project from v6 to v7
- Stopping a MongoDB project before the SQL adapter steps
- Migrate SQL clients from Prisma 6 to 7 while matching generated entrypoints and runtime adapter settings
- Retain a CommonJS application during a Prisma 7 migration by selecting the generator moduleFormat setting instead of forcing ESM.

### Weigh up before choosing

 - The file states Latest stable Prisma ORM version: 7.6.0 and requires Node.js 20.19.0+ and TypeScript 5.4.0+. This review did not query the npm registry.
- Troubleshooting offers ssl: { rejectUnauthorized: false } to preserve old behaviour, beside NODE_EXTRA_CA_CERTS. Both schema and driver-adapter references were inspected in this wave. The installer was not executed.
- Disabling TLS certificate verification is not a general migration fix; configure trusted certificates. The guide excludes MongoDB and does not configure Prisma 8.

02 / THE REVIEW RECORD

## What we actually inspected.

Source review has boundaries. A clear record is more useful than a “safe” badge.

### Material inspected

 - prisma-upgrade-v7/SKILL.md
- LICENSE at the same commit
- prisma-upgrade-v7/references/schema-changes.md
- prisma-upgrade-v7/references/driver-adapters.md

### Our findings

 - LICENSE is the MIT Licence with Copyright (c) 2025 Prisma.
- The MongoDB stop and the insecure SSL shortcut are both in the primary file.
- Schema and adapter references were read: client/browser entrypoints differ, CommonJS remains configurable, SQL pooling moves to underlying drivers, and MongoDB follows another version path.
- The breaking-change table marks an explicit generator output path and a SQL driver adapter as required, where v6 generated into node_modules and made adapters optional.

### Not established by this review

 - prisma generate and prisma migrate dev were not run.
- The reference files the closing section says to follow first were not opened.
- 7.6.0 was not checked against npm.
- Not executed: it was not installed or run.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

## Add a skill to your workflow.

[Upstream setup instructions ↗](https://github.com/vercel-labs/skills/blob/48dc9e8eb8aa19040e91cb90ba0b642c9cbad57e/README.md)

DOCUMENTED COMMAND

 npx skills add prisma/skills/prisma-upgrade-v7 Copy command ↗

Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.

 Optional: install the reviewed revision

Keeps the original source and installer version where recorded, while leaving your AI tools and installation scope for you to choose.

 npx skills add https://github.com/prisma/skills/tree/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7 Copy reviewed-revision command ↗ - The command pins only prisma-upgrade-v7 at the reviewed commit. The installer was not executed.
- A shorter prisma/skills command can install other skills this review did not open, including the MongoDB skill this file points at.
- The publisher README lists npx skills add prisma/skills --skill prisma-upgrade-v7, which does not pin revision be16a8740d01363d13552b317042431ee8dfc581.
- For manual installation instead, download the complete bundle from https://undominated.ai/resources/skills/prisma-prisma-upgrade-v7/bundle.zip and extract it into a new directory. It holds SKILL.md and 7 supporting files unchanged at revision be16a874, the upstream licence and an attribution file.
- Place the extracted directory in your host's documented skills directory, named prisma-upgrade-v7. Keep SKILL.md and the licence together.

### Before you start

 - Node.js 20.19.0 or newer, as the file states
- A SQL Prisma project, or a decision to stop if the provider is MongoDB

### Compatibility

Agent Skills hosts · Prisma ORM SQL projects

### Implementation

Markdown

### Local migration instructions that edit schema, config, and client imports

 - Read and edit the Prisma project the agent is given
- Run prisma generate and prisma migrate dev when the agent follows the file
- Edit package/schema/config files, regenerate client and run authorized database validation; migration commands can alter schema.

### Cost model

MIT instructions at no charge. Database migrations affect the database you point Prisma at.

THE COMPLETE REVIEWED DEFINITION

## Read it before you reuse it.

Original source bytes, with attribution. Review the host-specific setup notes above.

 Copy definition ↗ [Download complete resource + licence ↗](/resources/skills/prisma-prisma-upgrade-v7/bundle.zip)[Raw Markdown ↗](/resources/skills/prisma-prisma-upgrade-v7/definition.md)
 ---
name: prisma-upgrade-v7
description: Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes. Use when upgrading Prisma versions, encountering v7 errors, or migrating existing projects. Triggers on "upgrade to prisma 7", "prisma 7 migration", "prisma-client generator", "driver adapter required".
license: MIT
metadata:
 author: prisma
 version: "7.6.0"
---

# Upgrade to Prisma ORM 7

Complete guide for migrating from Prisma ORM v6 to v7. This upgrade introduces significant breaking changes around the new `prisma-client` generator, driver adapters, `prisma.config.ts`, explicit environment loading, and generated client entrypoints.

## When to Apply

Reference this skill when:
- Upgrading from Prisma v6 to v7
- Updating to the `prisma-client` generator
- Setting up driver adapters
- Configuring `prisma.config.ts`
- Fixing import errors after upgrade

## Rule Categories by Priority

| Priority | Category | Impact | Prefix |
|----------|----------|--------|--------|
| 1 | Schema Migration | CRITICAL | `schema-changes` |
| 2 | Database Connectivity | CRITICAL | `driver-adapters` |
| 3 | Module System | CRITICAL | `esm-support` |
| 4 | Config and Env | HIGH | `prisma-config`, `env-variables` |
| 5 | Removed Features | HIGH | `removed-features` |
| 6 | Accelerate | HIGH | `accelerate-users` |

## Quick Reference

- `schema-changes` - generator migration, required output paths, generated entrypoints, and `Prisma.validator` replacement
- `driver-adapters` - required adapter installation for SQL providers, pool differences, and Prisma Postgres adapter choices
- `esm-support` - ESM-first setup plus CommonJS fallback with `moduleFormat = "cjs"`
- `prisma-config` - creating and using `prisma.config.ts`
- `env-variables` - explicit environment loading
- `removed-features` - removed middleware, metrics, and legacy CLI behavior
- `accelerate-users` - migration notes for Accelerate users

## Using MongoDB? This guide does not apply

Prisma 7 has no MongoDB connector. Do not apply any step in this guide to a project with
`provider = "mongodb"` — see the `prisma-mongodb-upgrade` skill for the actual decision
(stay on v6 deliberately vs migrate to Prisma 8).

## Important Notes

- **MongoDB projects should stay on Prisma 6.x or migrate to Prisma 8** - do not migrate MongoDB apps to Prisma 7's SQL client path (see `prisma-mongodb-upgrade`)
- **Node.js 20.19.0+** required
- **TypeScript 5.4.0+** required
- **Latest stable Prisma ORM version**: `7.6.0`

## Upgrade Steps Overview

1. Update packages to v7
2. Choose your module format (`esm` by default, `cjs` if needed)
3. Update TypeScript configuration
4. Update the schema generator block
5. Create `prisma.config.ts`
6. Install and configure a driver adapter for SQL providers
7. Update Prisma Client imports
8. Update client instantiation
9. Replace deprecated helper patterns like `Prisma.validator`
10. Run `prisma generate` and test

## Quick Upgrade Commands

```bash
# Update packages
npm install @prisma/client@7
npm install -D prisma@7

# Install a driver adapter (PostgreSQL or Prisma Postgres via direct TCP)
npm install @prisma/adapter-pg pg

# Install dotenv for env loading
npm install dotenv

# Regenerate client
npx prisma generate
```

## Breaking Changes Summary

| Change | v6 | v7 |
|--------|----|----|
| Module format | Implicit / mixed | ESM-first, `moduleFormat = "cjs"` supported |
| Generator provider | `prisma-client-js` | `prisma-client` is the default, while `prisma-client-js` still exists for legacy setups |
| Output path | Auto (node_modules) | Required explicit |
| Driver adapters | Optional | Required for SQL providers |
| Config file | `.env` + schema | `prisma.config.ts` |
| Env loading | Automatic | Manual (dotenv) |
| Generated entrypoints | Single package export | `client`, `browser`, `models`, `enums` entrypoints |
| Type-safe query fragments | `Prisma.validator()` | TypeScript `satisfies` |
| Middleware | `$use()` | Client Extensions |
| Metrics | Preview feature | Removed |

## Rule Files

Detailed migration guides for each breaking change:

```
references/esm-support.md - ESM and CommonJS configuration
references/schema-changes.md - Generator, output, imports, and generated entrypoints
references/driver-adapters.md - Required driver adapter setup
references/prisma-config.md - New configuration file
references/env-variables.md - Environment variable loading
references/removed-features.md - Middleware, metrics, and CLI flags
references/accelerate-users.md - Special handling for Accelerate
```

## Step-by-Step Migration

### 1. Update package.json for ESM-first projects

```json
{
 "type": "module"
}
```

If you need to stay on CommonJS, keep your app as CJS and set `moduleFormat = "cjs"` in the generator block instead of forcing ESM.

### 2. Update tsconfig.json

```json
{
 "compilerOptions": {
 "module": "ESNext",
 "moduleResolution": "bundler",
 "target": "ES2023",
 "strict": true,
 "esModuleInterop": true
 }
}
```

### 3. Update schema.prisma

```prisma
// Before (v6)
generator client {
 provider = "prisma-client-js"
}

// After (v7)
generator client {
 provider = "prisma-client"
 output = "../generated/prisma"
 // Optional if you need CommonJS:
 // moduleFormat = "cjs"
}
```

### 4. Create prisma.config.ts

```typescript
import 'dotenv/config'
import { defineConfig, env } from 'prisma/config'

export default defineConfig({
 schema: 'prisma/schema.prisma',
 migrations: {
 path: 'prisma/migrations',
 },
 datasource: {
 url: env('DATABASE_URL'),
 },
})
```

### 5. Install a driver adapter (SQL providers only)

```bash
# PostgreSQL
npm install @prisma/adapter-pg pg

# MySQL
npm install @prisma/adapter-mariadb mariadb

# SQLite
npm install @prisma/adapter-better-sqlite3 better-sqlite3

# Prisma Postgres in standard Node.js apps (recommended)
npm install @prisma/adapter-pg pg

# Prisma Postgres serverless driver (edge/serverless)
npm install @prisma/adapter-ppg @prisma/ppg

# Neon
npm install @prisma/adapter-neon
```

MongoDB does not have a SQL `@prisma/adapter-*` package in the published Prisma 7.6.0 packages. If you're upgrading a MongoDB project, stop and keep that project on the latest Prisma 6.x release instead of following the standard Prisma 7 migration path.

### 6. Update client instantiation

```typescript
// Before (v6)
import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()

// After (v7)
import { PrismaClient } from '../generated/prisma/client'
import { PrismaPg } from '@prisma/adapter-pg'

const adapter = new PrismaPg({
 connectionString: process.env.DATABASE_URL
})

const prisma = new PrismaClient({ adapter })
```

### 7. Replace Prisma.validator with satisfies

```typescript
import { Prisma } from '../generated/prisma/client'

const userSelect = {
 id: true,
 email: true,
 name: true,
} satisfies Prisma.UserSelect
```

### 8. Run migrations and generate

```bash
npx prisma generate
npx prisma migrate dev # if needed
```

## Troubleshooting

### "Cannot find module" errors
- Check that the generator `output` path matches your import path
- Ensure `prisma generate` ran successfully

### SSL certificate errors
- Add `ssl: { rejectUnauthorized: false }` to the adapter config if you need to preserve old behavior
- Or configure your certificates properly with `NODE_EXTRA_CA_CERTS` / OpenSSL CA settings

### Connection timeout issues
- Driver adapters use the underlying driver's defaults, which differ from v6
- Configure pool settings explicitly on the adapter if needed

## Resources

- [Official v7 Upgrade Guide](https://www.prisma.io/docs/orm/more/upgrades/to-v7)
- [Driver Adapters Documentation](https://www.prisma.io/docs/orm/core-concepts/supported-databases/database-drivers)
- [Prisma Config Reference](https://www.prisma.io/docs/orm/reference/prisma-config-reference)

## How to Use

Follow `references/schema-changes.md` and `references/driver-adapters.md` first, then apply the remaining reference files based on your project setup.

The download contains SKILL.md . Extract the whole bundle; the supporting files are required. Inspect the included MANIFEST.json for file hashes.

By **Prisma**. [Exact upstream source ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/SKILL.md) · [Licence](/resources/skills/prisma-prisma-upgrade-v7/LICENSE.txt) · [Attribution](/resources/skills/prisma-prisma-upgrade-v7/ATTRIBUTION.txt)

SHA-256 03d79d99b6132b97b5b3b9d8158e40933fbb9a6d23708dc9539faeb64e09c8ff

 Read the applicable licence MIT License

Copyright (c) 2025 Prisma

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Skill definition ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/SKILL.md) Checked 2026-10-14 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/SKILL.md Supports: summary, whySelected, limitations
- [MIT licence ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/LICENSE) Checked 2026-10-07 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/LICENSE Supports: Redistribution terms and copyright notice
- [prisma-upgrade-v7/references/schema-changes.md ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/references/schema-changes.md) Checked 2026-10-14 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/references/schema-changes.md Supports: review, limitations, access, install
- [prisma-upgrade-v7/references/driver-adapters.md ↗](https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/references/driver-adapters.md) Checked 2026-10-14 https://github.com/prisma/skills/blob/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/references/driver-adapters.md Supports: review, limitations, access, install
- [Pinned source review C2-W36 ↗](https://raw.githubusercontent.com/prisma/skills/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/SKILL.md) Checked 2026-10-15 https://raw.githubusercontent.com/prisma/skills/be16a8740d01363d13552b317042431ee8dfc581/prisma-upgrade-v7/SKILL.md Supports: bestFor, review.notTested, review.reviewedAt

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### Prisma MongoDB upgrade ↗ Pins Prisma's MongoDB upgrade skill, which refuses a Prisma 7 upgrade and refuses an implicit move from MongoDB to SQL.](/skills/prisma-mongodb-upgrade/)[### Prisma Client API ↗ Covers Prisma Client model queries, relation filtering, interactive transactions, and batching semantics.](/skills/prisma-client-api/)[### Prisma ORM Setup ↗ Guides configuring Prisma ORM across PostgreSQL, MySQL, SQLite, SQL Server, CockroachDB, MongoDB, and Prisma Postgres.](/skills/prisma-orm-setup/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Choose a toolkit](/tools/)
- [Inspect execution hosts](/agents/)
- [Check tool access](/mcp-servers/)
- [Check project dependencies](/check-repo/)
