prisma-knowledge-patch

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