Prisma 5.19+ / 7.x Knowledge Patch Skill

Prisma 5.19+ / 7.x Knowledge Patch

Claude's baseline knowledge covers Prisma through 5.18. This skill provides changes from 5.19.0 onwards, with major focus on the Prisma 7 rewrite.

Prisma 7 Breaking Changes Quick Reference

| What Changed | Old (v6) | New (v7+) | |--------------|----------|-----------| | Generator | prisma-client-js | prisma-client (required) | | Output | Auto in node_modules | output field required | | Import | from "@prisma/client" | from "./generated/prisma/client" | | DB connection | Connection string in schema | Driver adapter required | | Config | schema.prisma datasource | prisma.config.ts at project root | | Module format | CJS | ESM only ("type": "module") | | Env vars | Auto-loaded .env | Manual load (use dotenv) | | Middleware | $use() | Client Extensions $extends() | | Seeding | Auto after migrate dev | Manual prisma db seed | | Generate | Auto after migrate dev | Manual prisma generate | | SSL certs | Ignored invalid certs | Validated by node-pg |

Prisma 7 Setup

// schema.prisma
generator client {
  provider = "prisma-client"
  output   = "../src/generated/prisma"
}

// prisma.config.ts (project root)
import "dotenv/config"
import { defineConfig, env } from "prisma/config"

export default defineConfig({
  schema: "prisma/schema.prisma",
  migrations: { path: "prisma/migrations", seed: "tsx prisma/seed.ts" },
  datasource: { url: env("DATABASE_URL") },
})

// app.ts — PostgreSQL
import { PrismaClient } from "./generated/prisma/client"
import { PrismaPg } from "@prisma/adapter-pg"

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

// app.ts — SQLite
import { PrismaClient } from "./generated/prisma/client"
import { PrismaBetterSqlite3 } from "@prisma/adapter-better-sqlite3"

const adapter = new PrismaBetterSqlite3({ url: "file:./dev.db" })
export const prisma = new PrismaClient({ adapter })

// app.ts — Prisma Accelerate (no adapter)
import { PrismaClient } from "./generated/prisma/client"
import { withAccelerate } from "@prisma/extension-accelerate"

export const prisma = new PrismaClient({
  accelerateUrl: process.env.DATABASE_URL,
}).$extends(withAccelerate())

See references/prisma7-migration.md for full upgrade guide.

TypedSQL (5.19.0+)

Write .sql files in prisma/sql/, generate typed functions:

-- prisma/sql/getUsersByAge.sql
SELECT * FROM "User" WHERE "age" > $1

import { getUsersByAge } from "@prisma/client/sql"  // v6
// or from "./generated/prisma/sql" in v7
const users = await prisma.$queryRawTyped(getUsersByAge(18))

SQL Comments / Observability (7.1.0+)

import { queryTags, withQueryTags } from '@prisma/sqlcommenter-query-tags'
import { traceContext } from '@prisma/sqlcommenter-trace-context'

const prisma = new PrismaClient({
  adapter,
  comments: [queryTags(), traceContext()],
})

// Per-request tags
const users = await withQueryTags(
  { route: '/api/users', requestId: 'abc-123' },
  () => prisma.user.findMany(),
)
// SQL: SELECT ... FROM "User" /*requestId='abc-123',route='/api/users'*/

Custom plugins implement SqlCommenterPlugin from @prisma/sqlcommenter.

Other New Features

6.3.0: limit on updateMany() and deleteMany()
6.3.0: NOT EXISTS replaces NOT IN for PostgreSQL relation filters (better perf)
7.0.0: MongoDB not yet supported in v7 (continue using v6)
7.0.0: prisma migrate diff options renamed: --from-url → --from-config-datasource
7.3.0: compilerBuild option ("fast" | "small") in generator block
7.3.0: Raw queries ($executeRaw/$queryRaw) bypass query compiler with driver adapters

Prerequisites (v7)

| Requirement | Minimum | Recommended | |-------------|---------|-------------| | Node.js | 20.19.0 | 22.x | | TypeScript | 5.4.0 | 5.9.x |

Agent Skills: Prisma 5.19+ / 7.x Knowledge Patch

Install this agent skill to your local

Skill Files