prisma

name	prisma
description	Prisma 7 — TypeScript-first ORM. Declarative schema, type-safe client, migrations, driver adapters (PrismaPg/Neon/LibSQL/D1). Use when: prisma 7, prisma.config.ts, prisma migrate, PrismaClient, PrismaPg, driver adapter, schema.prisma, @prisma/adapter-pg, $transaction, $queryRaw, $extends, Accelerate, Pulse, findMany, include, select, upsert. SKIP: Drizzle (→drizzle cascade), TypeORM (legacy), raw SQL only (→postgresql), MongoDB Prisma usage.
stacks	["prisma","nodejs-backend","typescript","orm"]
packages	["prisma","@prisma/client","@prisma/adapter-pg","@prisma/adapter-neon","@prisma/adapter-libsql","@prisma/adapter-d1","@prisma/extension-accelerate","@prisma/extension-pulse"]
tags	["prisma","orm","nodejs","typescript","migrations","schema"]
manifests	["package.json","prisma/schema.prisma","prisma.config.ts"]
source	vechkasov-global-skills
risk	high-stakes

🎯 Version Requirements (May 2026)

Primary pins:

• Prisma: 7.x
• PostgreSQL: 18.x
• TypeScript: 6.0.x

Source of truth: STACK_VERSIONS.md — verified 2026-05-16

Usage

Loaded when the description matches the task. Open only the reference you need.

Use this skill when

• Designing or evolving a Prisma 7 schema.prisma (models, relations, indexes, enums)
• Writing or auditing Prisma queries — findMany/findUnique/include/select/where
• Setting up migrations — migrate dev/deploy/diff/reset, custom SQL, shadow DB
• Configuring v7's prisma.config.ts (datasource URL moved out of schema.prisma)
• Choosing and wiring driver adapters — PrismaPg/PrismaNeon/PrismaLibSQL/PrismaD1
• Running transactions — interactive $transaction(async tx => ...) or batched
• Writing raw SQL via $queryRaw (tagged template parameter binding)
• Composing extensions via $extends({ query, model, client, result })
• Setting up Accelerate (cache + edge pool) or Pulse (CDC)
• Tuning queries — EXPLAIN ANALYZE, indexes, N+1, select over include
• Migrating from Prisma 6 → 7 (datasource URL, ESM-only, driver-adapter mandatory)

Do not use this skill when

• Drizzle ORM — use drizzle (cascade marker)
• TypeORM / Sequelize / MikroORM — legacy
• Pure raw SQL without ORM coupling — use postgresql
• MongoDB-specific Prisma — niche, use general assistant
• Supabase platform (auth/edge/storage) — use supabase (cascade)
• PostgreSQL DBA work (pg_dump, RLS policies, pgBouncer) — use postgresql

Purpose

Prisma 7 is the dominant TypeScript-first ORM in 2026. Declarative schema.prisma → typed client with IDE autocomplete; migration system with shadow databases; route queries through native drivers (, , , ) instead of a Rust binary — enabling edge runtimes and ~30% lower memory.