Prisma — Next-Generation ORM for Node.js & TypeScript

What Prisma Does

• Prisma Schema — single source of truth for data model
• Prisma Client — auto-generated, type-safe query builder
• Prisma Migrate — declarative migrations from schema changes
• Prisma Studio — GUI browser for database
• Relation queries — include and select for nested data
• Transactions — interactive and batch

Architecture

Schema → Prisma Engine (Rust) → Database. The TypeScript client wraps a Rust binary (or WASM in edge runtimes) that handles query compilation, connection pooling, and protocol. Types are generated from the schema on prisma generate.

Self-Hosting

Prisma is a library, not a service. Ships with your app. For connection pooling in serverless, use Prisma Accelerate (hosted) or PgBouncer/Supavisor self-hosted.

# Production
npx prisma migrate deploy
node dist/server.js

Key Features

• Fully type-safe queries
• Declarative schema (.prisma file)
• Auto-migrations
• Multi-database support
• Prisma Studio (GUI)
• Edge runtime support (Cloudflare, Vercel)
• Interactive transactions
• Full-text search (PostgreSQL)

Comparison

FAQ

Q: Prisma vs Drizzle？ A: Prisma provides a higher-level abstraction (Schema DSL, automatic migrations) with great DX; Drizzle is closer to SQL, has a smaller bundle, and runs faster on edge runtimes.

Q: Slow cold start? A: Prisma 5+ provides driverAdapters, which remove the Rust engine and greatly improve cold starts.

Q: Can I write raw SQL? A: Yes. prisma.$queryRaw and $executeRaw support parameterized queries via template strings.

Sources & Credits

• Docs: https://www.prisma.io/docs
• GitHub: https://github.com/prisma/prisma
• License: Apache 2.0