1---2name: prisma-73description: Use when working with database schema, migrations, queries, or relations via Prisma 7 (Rust-free client, TypedSQL, Omit API).4versions:5 prisma: 7.36 nodejs: 20.197 typescript: 5.48user-invocable: true9references: references/installation.md, references/client.md, references/client-api.md, references/prisma-config.md, references/cli-reference.md, references/editor-setup.md, references/schema.md, references/schema-reference.md, references/data-modeling.md, references/field-attributes.md, references/model-attributes.md, references/enums.md, references/default-values.md, references/composite-types.md, references/scalar-lists.md, references/referential-actions.md, references/queries.md, references/relations.md, references/filtering.md, references/sorting.md, references/select-include.md, references/pagination-cursor.md, references/pagination-offset.md, references/distinct.md, references/count-exists.md, references/case-sensitivity.md, references/aggregations.md, references/transactions.md, references/typedsql.md, references/raw-queries.md, references/json-fields.md, references/full-text-search.md, references/views.md, references/stored-procedures.md, references/triggers.md, references/constraints.md, references/indexes-advanced.md, references/migrations.md, references/seeding.md, references/baselining.md, references/shadow-database.md, references/migration-history.md, references/squashing.md, references/hotfixing.md, references/down-migrations.md, references/data-migrations.md, references/zero-downtime.md, references/optimization.md, references/query-optimization.md, references/n-plus-one.md, references/batching.md, references/lazy-loading.md, references/caching-strategies.md, references/connection-limits.md, references/cold-starts.md, references/bundle-size.md, references/accelerate.md, references/connection-pooling.md, references/connection-urls.md, references/environment-variables.md, references/ssl-tls.md, references/sql-injection.md, references/row-level-security.md, references/encryption.md, references/audit-logging.md, references/gdpr-compliance.md, references/postgresql.md, references/mysql.md, references/sqlite.md, references/mongodb.md, references/cockroachdb.md, references/planetscale.md, references/supabase.md, references/neon.md, references/turso.md, references/extensions.md, references/driver-adapters.md, references/omit-api.md, references/middleware.md, references/soft-delete.md, references/read-replicas.md, references/multi-database.md, references/multi-schema.md, references/nextjs-integration.md, references/astro.md, references/nuxt.md, references/sveltekit.md, references/solidstart.md, references/remix.md, references/react-router.md, references/hono.md, references/express.md, references/clerk.md, references/authjs.md, references/betterauth.md, references/permit-io.md, references/deployment.md, references/vercel.md, references/netlify.md, references/railway.md, references/render.md, references/flyio.md, references/aws-lambda.md, references/cloudflare-workers.md, references/docker.md, references/heroku.md, references/deno-deploy.md, references/vscode.md, references/github-copilot.md, references/tabnine.md, references/safeql.md, references/prisma-ai.md, references/mcp-server.md, references/turborepo.md, references/pnpm-workspaces.md, references/error-handling.md, references/error-codes.md, references/logging.md, references/opentelemetry.md, references/datadog.md, references/studio.md, references/testing.md, references/vs-typeorm.md, references/vs-sequelize.md, references/vs-drizzle.md, references/vs-mongoose.md, references/vs-kysely.md, references/migrate-from-typeorm.md, references/migrate-from-sequelize.md, references/migrate-from-drizzle.md10related-skills: nextjs-16, better-auth, solid-nextjs11metadata:12 source: https://skillmd.com/skills/fusengine/prisma-713---1415<objective>16Covers Prisma 7's Rust-free TypeScript ORM: the v6→v7 breaking changes (provider renamed `prisma-client-js` → `prisma-client`, output path now REQUIRED, import moves from `@prisma/client` to the generated path, database driver adapters now required — e.g. `@prisma/adapter-pg` for PostgreSQL — and config moved to `prisma.config.ts`), schema modeling, CRUD/relations/filtering/pagination/transactions, TypedSQL for type-safe raw queries, and the Omit API for excluding sensitive fields.1718Also spans migrations (baselining, shadow database, squashing, zero-downtime), performance (N+1 detection, connection pooling, Accelerate), security (SQL injection prevention, row-level security, encryption), per-database guides (PostgreSQL, MySQL, SQLite, CockroachDB, Turso — MongoDB unsupported in 7.0-7.3), framework integrations (Next.js, Astro, SvelteKit, Remix, and more), and deployment across Vercel/Netlify/Railway/AWS Lambda/Cloudflare Workers/Docker. Includes SOLID-compliant TypeScript interface references for schema design. Does not cover Better Auth's own database adapter configuration in depth (better-auth) — this skill is the ORM layer itself.19</objective>2021# Prisma 7 ORM2223Rust-free TypeScript ORM with 90% smaller bundles and 3x faster queries.2425## Agent Workflow (MANDATORY)2627Before ANY implementation, spawn 3 agents in parallel, one `Agent` call each with a `name`:28291. **fuse-ai-pilot:explore-codebase** - Analyze existing schema and database patterns302. **fuse-ai-pilot:research-expert** - Verify latest Prisma 7 docs via Context7/Exa313. **mcp__context7__query-docs** - Check breaking changes and migration guide3233After implementation, run **fuse-ai-pilot:sniper** for validation.3435---3637## Overview3839### When to Use4041- Database access in Next.js 16 applications42- Type-safe queries with full TypeScript inference43- Schema-first database modeling and migrations44- Complex queries requiring TypedSQL45- Excluding sensitive fields with Omit API4647### Why Prisma 74849| Feature | Benefit |50|---------|---------|51| Rust-free client | 90% smaller bundles (14MB → 1.6MB) |52| Query performance | Up to 3x faster on large datasets |53| ESM-first | Native ES modules, modern architecture |54| TypedSQL | Type-safe raw SQL queries |55| Omit API | Exclude sensitive fields globally |56| Driver adapters | Direct database driver integration |5758---5960## Breaking Changes from v66162### Critical Migration Points6364| Change | v6 | v7 |65|--------|----|----|66| Provider | `prisma-client-js` | `prisma-client` |67| Output path | Optional | **REQUIRED** |68| Import | `@prisma/client` | `./generated/prisma/client` |69| Drivers | Built-in | Adapter required |70| Config | Schema only | `prisma.config.ts` |7172### Required Schema Changes7374Provider must be `prisma-client` with explicit output path. No more generation to `node_modules`.7576### Driver Adapters Required7778PostgreSQL requires `@prisma/adapter-pg`, MySQL requires `@prisma/adapter-mariadb`, SQLite requires `@prisma/adapter-better-sqlite3`.7980---8182## SOLID Architecture8384### Module Structure8586Database code organized in `modules/cores/db/`:8788- `modules/cores/db/prisma.ts` - Singleton PrismaClient89- `modules/cores/db/generated/` - Generated client90- `prisma/schema.prisma` - Schema definition91- `prisma/migrations/` - Migration history92- `prisma.config.ts` - Prisma configuration9394### File Organization9596| File | Purpose | Max Lines |97|------|---------|-----------|98| `prisma.ts` | Singleton client | 30 |99| `schema.prisma` | Models, relations | 100 per section |100| `seed.ts` | Database seeding | 50 |101102---103104## Key Concepts105106### Singleton Pattern (Next.js)107108Prevent multiple PrismaClient instances during hot-reload. Use `globalThis` to cache instance in development.109110### Output Path111112Generated client goes to custom path, not `node_modules`. Import from generated folder.113114### Driver Adapters115116Direct database driver integration for better performance and control. Configure connection pooling at driver level.117118### TypedSQL119120Write raw SQL with full type safety. Results are typed based on query.121122### Omit API123124Exclude fields globally or per-query. Perfect for passwords and sensitive data.125126---127128## Reference Guide (130 files)129130### Core Setup131| Need | Reference |132|------|-----------|133| Initial setup | `installation.md` |134| PrismaClient singleton | `client.md` |135| Client API methods | `client-api.md` |136| Configuration | `prisma-config.md` |137| CLI commands | `cli-reference.md` |138| Editor setup | `editor-setup.md` |139140### Schema & Modeling141| Need | Reference |142|------|-----------|143| Schema design | `schema.md` |144| Schema syntax | `schema-reference.md` |145| Data modeling | `data-modeling.md` |146| Field attributes | `field-attributes.md` |147| Model attributes | `model-attributes.md` |148| Enums | `enums.md` |149| Default values | `default-values.md` |150| Composite types | `composite-types.md` |151| Scalar lists/arrays | `scalar-lists.md` |152| Referential actions | `referential-actions.md` |153154### Queries & Operations155| Need | Reference |156|------|-----------|157| CRUD operations | `queries.md` |158| Relations | `relations.md` |159| Filtering | `filtering.md` |160| Sorting | `sorting.md` |161| Select vs Include | `select-include.md` |162| Pagination (cursor) | `pagination-cursor.md` |163| Pagination (offset) | `pagination-offset.md` |164| Distinct | `distinct.md` |165| Count & exists | `count-exists.md` |166| Case sensitivity | `case-sensitivity.md` |167| Aggregations | `aggregations.md` |168| Transactions | `transactions.md` |169170### Advanced Queries171| Need | Reference |172|------|-----------|173| TypedSQL | `typedsql.md` |174| Raw queries | `raw-queries.md` |175| JSON fields | `json-fields.md` |176| Full-text search | `full-text-search.md` |177| Views | `views.md` |178| Stored procedures | `stored-procedures.md` |179| Triggers | `triggers.md` |180| Constraints | `constraints.md` |181| Advanced indexes | `indexes-advanced.md` |182183### Migrations184| Need | Reference |185|------|-----------|186| Migration workflow | `migrations.md` |187| Seeding | `seeding.md` |188| Baselining | `baselining.md` |189| Shadow database | `shadow-database.md` |190| Migration history | `migration-history.md` |191| Squashing | `squashing.md` |192| Hotfixing | `hotfixing.md` |193| Down migrations | `down-migrations.md` |194| Data migrations | `data-migrations.md` |195| Zero-downtime | `zero-downtime.md` |196197### Performance198| Need | Reference |199|------|-----------|200| Optimization | `optimization.md` |201| Query optimization | `query-optimization.md` |202| N+1 problem | `n-plus-one.md` |203| Batching | `batching.md` |204| Lazy loading | `lazy-loading.md` |205| Caching strategies | `caching-strategies.md` |206| Connection limits | `connection-limits.md` |207| Cold starts | `cold-starts.md` |208| Bundle size | `bundle-size.md` |209| Accelerate | `accelerate.md` |210| Connection pooling | `connection-pooling.md` |211212### Security213| Need | Reference |214|------|-----------|215| Connection URLs | `connection-urls.md` |216| Environment variables | `environment-variables.md` |217| SSL/TLS | `ssl-tls.md` |218| SQL injection | `sql-injection.md` |219| Row-level security | `row-level-security.md` |220| Encryption | `encryption.md` |221| Audit logging | `audit-logging.md` |222| GDPR compliance | `gdpr-compliance.md` |223224### Databases225| Need | Reference |226|------|-----------|227| PostgreSQL | `postgresql.md` |228| MySQL | `mysql.md` |229| SQLite | `sqlite.md` |230| MongoDB (deprecated) | `mongodb.md` |231| CockroachDB | `cockroachdb.md` |232| PlanetScale | `planetscale.md` |233| Supabase | `supabase.md` |234| Neon | `neon.md` |235| Turso | `turso.md` |236237### Extensions & Integrations238| Need | Reference |239|------|-----------|240| Extensions | `extensions.md` |241| Driver adapters | `driver-adapters.md` |242| Omit API | `omit-api.md` |243| Middleware (deprecated) | `middleware.md` |244| Soft delete | `soft-delete.md` |245| Read replicas | `read-replicas.md` |246| Multi-database | `multi-database.md` |247| Multi-schema | `multi-schema.md` |248249### Framework Integrations250| Need | Reference |251|------|-----------|252| Next.js | `nextjs-integration.md` |253| Astro | `astro.md` |254| Nuxt | `nuxt.md` |255| SvelteKit | `sveltekit.md` |256| SolidStart | `solidstart.md` |257| Remix | `remix.md` |258| React Router | `react-router.md` |259| Hono | `hono.md` |260| Express | `express.md` |261262### Auth Integrations263| Need | Reference |264|------|-----------|265| Clerk | `clerk.md` |266| Auth.js | `authjs.md` |267| Better Auth | `betterauth.md` |268| Permit.io | `permit-io.md` |269270### Deployment271| Need | Reference |272|------|-----------|273| Deployment guide | `deployment.md` |274| Vercel | `vercel.md` |275| Netlify | `netlify.md` |276| Railway | `railway.md` |277| Render | `render.md` |278| Fly.io | `flyio.md` |279| AWS Lambda | `aws-lambda.md` |280| Cloudflare Workers | `cloudflare-workers.md` |281| Docker | `docker.md` |282| Heroku | `heroku.md` |283| Deno Deploy | `deno-deploy.md` |284285### Tooling286| Need | Reference |287|------|-----------|288| VS Code | `vscode.md` |289| GitHub Copilot | `github-copilot.md` |290| Tabnine | `tabnine.md` |291| SafeQL | `safeql.md` |292| Prisma AI | `prisma-ai.md` |293| MCP Server | `mcp-server.md` |294| Turborepo | `turborepo.md` |295| pnpm workspaces | `pnpm-workspaces.md` |296297### Monitoring298| Need | Reference |299|------|-----------|300| Error handling | `error-handling.md` |301| Error codes | `error-codes.md` |302| Logging | `logging.md` |303| OpenTelemetry | `opentelemetry.md` |304| DataDog | `datadog.md` |305| Studio | `studio.md` |306| Testing | `testing.md` |307308### ORM Comparisons309| Need | Reference |310|------|-----------|311| vs TypeORM | `vs-typeorm.md` |312| vs Sequelize | `vs-sequelize.md` |313| vs Drizzle | `vs-drizzle.md` |314| vs Mongoose | `vs-mongoose.md` |315| vs Kysely | `vs-kysely.md` |316317### Migration Guides318| Need | Reference |319|------|-----------|320| From TypeORM | `migrate-from-typeorm.md` |321| From Sequelize | `migrate-from-sequelize.md` |322| From Drizzle | `migrate-from-drizzle.md` |323324### TypeScript Interfaces (SOLID)325326`references/interfaces/` holds SOLID-compliant type definitions for Prisma 7 schema design, separated from implementation. Load when writing or reviewing typed schema code:327328| Need | Reference |329|------|-----------|330| Overview of all interface files | `interfaces/INDEX.md` |331| Schema types: `GeneratorConfig`, `ModelDefinition`, `FieldAttribute`, `EnumDefinition` | `interfaces/schema.types.md` |332| Data modeling types: normalization, cardinality | `interfaces/data-modeling.types.md` |333| Enum types: value definitions, status/role patterns | `interfaces/enums.types.md` |334| Field attribute types: identity, unique, default, mapping | `interfaces/field-attributes.types.md` |335| Model attribute types: composite keys, composite indexes | `interfaces/model-attributes.types.md` |336| Relation types: one-to-one, referential actions, cascade | `interfaces/relations.types.md` |337| Migration types: workflow, deploy, seeding | `interfaces/migrations.types.md` |338339---340341## Best Practices3423431. **Singleton in Next.js** - Cache PrismaClient in globalThis3442. **Output path required** - Never generate to node_modules3453. **Driver adapters** - Use native drivers for better performance3464. **Omit sensitive fields** - Configure global omit for passwords3475. **TypedSQL for complex** - Use for queries Prisma can't express3486. **Index verification** - Check query plans for N+1 issues349350---351352## Forbidden Patterns353354| Pattern | Reason | Alternative |355|---------|--------|-------------|356| Import from `@prisma/client` | v7 requires generated path | Import from `./generated/prisma/client` |357| `prisma-client-js` provider | Deprecated in v7 | Use `prisma-client` |358| No output path | Required in v7 | Set `output` in generator |359| MongoDB | Not supported in v7.0-7.3 | Stay on Prisma 6 |360| url in datasource | Deprecated | Use `prisma.config.ts` |