Prisma V2

Prisma is the most widely adopted TypeScript ORM in production Node.js applications — the schema-first approach (Prisma Schema Language), auto-generated client, and Prisma Studio (visual database browser) provide an excellent developer experience for database-heavy backends. Prisma Accelerate adds serverless-friendly connection pooling and query caching. The generated client is fully type-safe (no manual type declarations needed). Confidence is docs-derived.

npm install prisma @prisma/client. Define schema.prisma: model User { id Int @id @default(autoincrement()); name String }. npx prisma generate produces the typed client. import {PrismaClient} from "@prisma/client"; const prisma = new PrismaClient(). prisma.user.findMany(), prisma.user.create({data: {name: "Alice"}}). Prisma Migrate: npx prisma migrate dev. Prisma Accelerate: change DATABASE_URL to Prisma Accelerate endpoint for pooling + caching.

No Prisma API key for open-source client. DATABASE_URL connection string in .env. Prisma Accelerate: API key for Accelerate service. Prisma Data Platform: workspace auth for Accelerate/Pulse management. Open-source Apache 2.0. Edge deployments: Prisma Client for edge (separate package for Cloudflare Workers/Vercel Edge).

Connection pooling required for serverless (Prisma Accelerate or PgBouncer). N+1 query problem: mitigated by Prisma's findMany with include, but agents should use select for performance. Migration conflicts: prisma migrate dev handles gracefully in dev. Prisma Client errors are typed (PrismaClientKnownRequestError with code P2002 for unique constraint, etc.). Active GitHub (prisma/prisma). Long-term support track.

prisma.io/docs is comprehensive — schema reference, CRUD guide, relation handling, migration docs, Accelerate and Pulse documentation. Getting started: npx prisma init, first model in under 15 minutes. Prisma Studio for visual data inspection. Large community via Prisma Slack and GitHub. Extensive ecosystem of tutorials and third-party guides.