Prisma V3

Prisma is the standard TypeScript ORM — define your schema in schema.prisma, run prisma generate to get a fully-typed client, and interact with your database without raw SQL. For agents: const users = await prisma.user.findMany({ where: { active: true }, include: { posts: true } }) returns typed User objects with type checking at compile time. Prisma Migrate tracks schema changes as version-controlled SQL migrations. Prisma Studio provides a visual database browser. Works with PostgreSQL, MySQL, SQLite, SQL Server, MongoDB. Pure local library — no network calls beyond your database. Confidence is docs-derived.

TypeScript SDK: npm install @prisma/client prisma. Schema (schema.prisma): model User { id Int @id @default(autoincrement()); email String @unique; name String?; createdAt DateTime @default(now()); posts Post[] }. Generate client: npx prisma generate. Migrate: npx prisma migrate dev --name add-user-table. CRUD: const user = await prisma.user.create({ data: { email: "alice@example.com", name: "Alice" } }). Find: const users = await prisma.user.findMany({ where: { email: { contains: "@example.com" } }, orderBy: { createdAt: "desc" }, take: 10 }). Update: await prisma.user.update({ where: { id: 1 }, data: { name: "Bob" } }). Delete: await prisma.user.delete({ where: { id: 1 } }). Relations: const posts = await prisma.post.findMany({ include: { author: true }, where: { published: true } }). Raw SQL: await prisma.$queryRaw`SELECT * FROM users WHERE id = ${userId}`. Transaction: await prisma.$transaction([prisma.user.create(...), prisma.post.create(...)]).

No external auth — Prisma connects directly to your database using the DATABASE_URL environment variable (connection string with credentials). Credentials: stored in .env file (DATABASE_URL="postgresql://user:password@host:5432/db"). Prisma Data Platform: optional hosted service for connection pooling (Accelerate) and caching — requires API key. Prisma Pulse (real-time events): API key from console.prisma.io. No OAuth2 for Prisma ORM itself. Database-level auth handled by your database (PostgreSQL roles, MySQL users, etc.).

Type safety: TypeScript types generated from schema at compile time — runtime query errors become compile-time type errors. N+1 prevention: include relations in single query rather than looping; Prisma batches related queries automatically. Connection pooling: configure connection_limit in DATABASE_URL; use Prisma Accelerate for serverless (manages connection pooling). Migrations: prisma migrate deploy applies pending migrations in CI/CD. Schema drift: prisma db pull introspects existing database for schema sync. Large result sets: use cursor-based pagination (cursor + take + skip) for efficient large table traversal. Prisma Accelerate: edge-compatible connection pooler (serverless-safe).

prisma.io/docs covers schema reference, query API, migrations guide, relation patterns, and framework-specific setup (Next.js, NestJS, Express). Getting started: npm install prisma @prisma/client, npx prisma init — first typed query in 5 minutes. Fully free and open-source. Prisma Accelerate (connection pooling): pay-per-request. GitHub: prisma/prisma (40k+ stars). Community via Prisma Discord (very active). Exceptional documentation; Prisma has one of the best ORM docs available with extensive examples and schema reference.