Agent skill

Prisma Upgrade V7

by aiskillstore in aiskillstore/marketplace

Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.

MITAuto-check: notesDatabases

Install Prisma Upgrade V7

skills CLI
$ npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install aiskillstore/marketplace prisma-upgrade-v7 --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/aiskillstore/marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/prisma/prisma-upgrade-v7 .claude/skills/prisma-upgrade-v7 && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
prisma-upgrade-v7
GitHub stars
433
Token cost
~2k tokens
SKILL.md length
601 words
Files
9 (incl. references)
Skills in repo
1,044
Repo updated
First seen
Licence
MIT

At a glance

Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.

  • Works in 8 steps: Update package.json for ESM-first projects → Update tsconfig.json → Update schema.prisma → …
  • Upgrading Prisma versions
  • SKILL.md covers When to Apply, Rule Categories by Priority, Quick Reference and Using MongoDB? This guide does…, plus 9 more sections
  • Calls npm and npx

What it does

Prisma Upgrade V7 is an agent skill from aiskillstore/marketplace. 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".

Its SKILL.md is about 2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files, including reference files (for example `references/accelerate-users.md`, `references/driver-adapters.md` and `references/env-variables.md`).

It sits in Databases, covering ORMs and data access. It works with Prisma, MongoDB and SQL. The repository describes itself as: Security-audited skills for Claude, Codex & Claude Code. One-click install, quality verified. The licence is MIT.

When your agent uses it

  • Upgrading Prisma versions
  • Encountering v7 errors
  • Migrating existing projects
  • Upgrade to prisma 7

Example prompts

  • “upgrade to prisma 7”
  • “prisma 7 migration”
  • “prisma-client generator”
  • “/prisma-upgrade-v7”

Requirements

  • Node.js

Workflow steps

8 steps, taken from the step headings in SKILL.md.

  1. Update package.json for ESM-first projects
  2. Update tsconfig.json
  3. Update schema.prisma
  4. Create prisma.config.ts
  5. Install a driver adapter (SQL providers only)
  6. Update client instantiation
  7. Replace Prisma.validator with satisfies
  8. Run migrations and generate

What it can do on your machine

Read from SKILL.md and the folder at commit 44923f3. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • npm
    • npx

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • prisma.io

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Prisma Upgrade V7 loads about 2k tokens when it runs, and up to ~9k if it reads all its reference files. Until then it costs about 75 tokens; SKILL.md has 601 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~75
When it runs · the whole SKILL.md, loaded when a task matches
~2k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~9k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteMentions a .env fileSKILL.md:95
    | Config file | `.env` + schema | `prisma.config.ts` |

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from aiskillstore/marketplace at commit 44923f3, republished under its MIT licence (© aiskillstore). 601 words, ~2,019 tokens.

Download SKILL.mdSave it as .claude/skills/prisma-upgrade-v7/SKILL.md (or your agent's skills folder). This skill also uses 8 other files; get the full folder from GitHub.
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
metadata.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

PriorityCategoryImpactPrefix
1Schema MigrationCRITICALschema-changes
2Database ConnectivityCRITICALdriver-adapters
3Module SystemCRITICALesm-support
4Config and EnvHIGHprisma-config, env-variables
5Removed FeaturesHIGHremoved-features
6AccelerateHIGHaccelerate-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 Next).

Important Notes

  • MongoDB projects should stay on Prisma 6.x or migrate to Prisma Next - 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

Changev6v7
Module formatImplicit / mixedESM-first, moduleFormat = "cjs" supported
Generator providerprisma-client-jsprisma-client is the default, while prisma-client-js still exists for legacy setups
Output pathAuto (node_modules)Required explicit
Driver adaptersOptionalRequired for SQL providers
Config file.env + schemaprisma.config.ts
Env loadingAutomaticManual (dotenv)
Generated entrypointsSingle package exportclient, browser, models, enums entrypoints
Type-safe query fragmentsPrisma.validator()TypeScript satisfies
Middleware$use()Client Extensions
MetricsPreview featureRemoved
Show full SKILL.md (213 more words)Show less

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

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.

© aiskillstore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 8 other files (references) in skills/prisma/prisma-upgrade-v7 of aiskillstore/marketplace.

  • SKILL.md
  • references/accelerate-users.md
  • references/driver-adapters.md
  • references/env-variables.md
  • references/esm-support.md
  • references/prisma-config.md
  • references/removed-features.md
  • references/schema-changes.md
  • skill-report.json

Open the folder on GitHubat commit 44923f3

Compare with similar skills

Prisma Upgrade V7 next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Prisma Upgrade V7 compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Prisma Upgrade V7 this skillaiskillstore/marketplace433—~2kAutomated safety check: NotesMIT
Database FundamentalsDanielPodolsky/ownyourcode2901 repos~1.6kAutomated safety check: PassMIT
DB SculptorEliasOulkadi/shokunin114—~3.1kAutomated safety check: NotesMIT
Database Testingpetrkindlmann/qa-skills170—~4.2kAutomated safety check: PassMIT
Prisma Database Setupcurvenote/curvenote1703 repos~1.4kAutomated safety check: PassMIT
Create Auth Skilldeadlock-mod-manager/deadlock-mod-manager4784 repos~3.4kAutomated safety check: PassGPL-3.0

Similar skills

  • Database Fundamentals

    DanielPodolsky/ownyourcode

    Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.

    290 GitHub starsUsed in 1 repo~1.6k tokens
    DatabasesAuto-check passed
  • DB Sculptor

    EliasOulkadi/shokunin

    Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

    114 GitHub stars~3.1k tokensUpdated 5 days ago
    DatabasesAuto-check: notes
  • Database Testing

    petrkindlmann/qa-skills

    Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues.

    170 GitHub stars~4.2k tokensUpdated 4 mo ago
    DatabasesAuto-check passed
  • Prisma Database Setup

    curvenote/curvenote

    Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).

    170 GitHub starsUsed in 3 repos~1.4k tokens
    DatabasesAuto-check passed
  • Create Auth Skill

    deadlock-mod-manager/deadlock-mod-manager

    Scaffold and implement authentication in TypeScript/JavaScript apps using Better Auth.

    478 GitHub starsUsed in 4 repos~3.4k tokens
    DatabasesAuto-check passed
  • Drizzle Migrations

    bretzel-app/crumbs

    Drizzle ORM schema management and SQLite migrations — adding tables, modifying columns, creating indexes, generating and running migrations, Drizzle query patterns.

    127 GitHub starsUsed in 1 repo~2.6k tokens
    DatabasesAuto-check passed

More from aiskillstore/marketplace

All 1,044 skills in this repo
  • Code Stats

    aiskillstore/marketplace

    Analyze codebase with tokei (fast line counts by language) and difft (semantic AST-aware diffs).

    433 GitHub starsUsed in 1 repo~697 tokens
    Auto-check: notes
  • Data Processing

    aiskillstore/marketplace

    Process JSON with jq and YAML/TOML with yq. An agent skill from aiskillstore/marketplace.

    433 GitHub starsUsed in 1 repo~720 tokens
    Auto-check: notes
  • Doc Scanner

    aiskillstore/marketplace

    Scans for project documentation files (AGENTS.md, CLAUDE.md, GEMINI.md, COPILOT.md, CURSOR.md, WARP.md, and 15+ other formats) and synthesizes guidance.

    433 GitHub starsUsed in 1 repo~644 tokens
    Auto-check: notes
  • File Search

    aiskillstore/marketplace

    Modern file and content search using fd, ripgrep (rg), and fzf.

    433 GitHub starsUsed in 1 repo~598 tokens
    Auto-check: notes
  • Find Replace

    aiskillstore/marketplace

    Modern find-and-replace using sd (simpler than sed) and batch replacement patterns.

    433 GitHub starsUsed in 1 repo~527 tokens
    Auto-check: notes
  • Project Planner

    aiskillstore/marketplace

    Detects stale project plans and suggests session commands. An agent skill from aiskillstore/marketplace.

    433 GitHub starsUsed in 1 repo~504 tokens
    Auto-check passed

Categories

Questions about Prisma Upgrade V7

What does Prisma Upgrade V7 do?

Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes. Prisma Upgrade V7 is an agent skill from aiskillstore/marketplace. Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes.

When should I use Prisma Upgrade V7?

Prisma Upgrade V7 fits situations like: upgrading Prisma versions; encountering v7 errors; migrating existing projects; upgrade to prisma 7.

How do I install Prisma Upgrade V7 in Claude Code?

Run `npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a claude-code`. Or copy the skill folder (skills/prisma/prisma-upgrade-v7 in aiskillstore/marketplace) into .claude/skills/prisma-upgrade-v7 in your project. Claude Code loads it when a task matches its description.

How do I install Prisma Upgrade V7 in Codex?

Run `npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a codex`. Or copy the skill folder (skills/prisma/prisma-upgrade-v7 in aiskillstore/marketplace) into .agents/skills/prisma-upgrade-v7 in your project. Codex loads it when a task matches its description.

Can I use Prisma Upgrade V7 in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add aiskillstore/marketplace --skill prisma-upgrade-v7 -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/prisma-upgrade-v7, .gemini/skills/prisma-upgrade-v7, .github/skills/prisma-upgrade-v7 and .opencode/skills/prisma-upgrade-v7 in your project.

What does Prisma Upgrade V7 need to run?

Going by SKILL.md and its folder, Prisma Upgrade V7 needs the command-line tools its instructions call (npm and npx). Our summary lists: Node.js.

Does Prisma Upgrade V7 access the network?

SKILL.md names 1 domain. As links in the text: prisma.io. This is read from the text; nothing was executed.

Is Prisma Upgrade V7 safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Prisma Upgrade V7 use?

Prisma Upgrade V7 is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Prisma Upgrade V7 use?

About 2k tokens (SKILL.md is roughly 8.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 7k tokens, read only when the agent opens those files.

What are the alternatives to Prisma Upgrade V7?

Skills that share tags, products or a category with Prisma Upgrade V7: Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars), DB Sculptor (EliasOulkadi/shokunin, 114 stars), Database Testing (petrkindlmann/qa-skills, 170 stars) and Prisma Database Setup (curvenote/curvenote, 170 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Prisma Upgrade V7?

aiskillstore (a GitHub organization) maintains it in aiskillstore/marketplace, which has 433 GitHub stars. The repository holds 1,044 skills in this directory. The repository was last updated on October 10, 2026.

Source: aiskillstore/marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.