Prisma
Next-generation TypeScript ORM with auto-generated types, migrations, and a declarative data modeling language.
Version: v5.15
Official Documentation ↗Installation
npm
npm install prisma && npx prisma initpnpm
pnpm add prisma && pnpm exec prisma initMethods
No methods match this filter.
FAQ
- How does Prisma compare to Drizzle ORM?
- Prisma generates a client from a declarative schema, providing full type safety and auto-completion. Drizzle uses SQL-like syntax with zero code generation. Prisma is easier for beginners; Drizzle offers more control and smaller bundle size.
- What databases does Prisma support?
- PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, and CockroachDB. Each has full type safety, migrations, and native relation handling. Prisma also supports connection pooling via Prisma Data Platform.
- How do I handle N+1 queries?
- Use include or select to eagerly load relations. Prisma automatically optimizes joins. For complex queries, use prisma.$transaction or raw SQL via prisma.$queryRaw. The N+1 problem is visible in Prisma Studio.
Report a problem with this API docOpens a pre-filled issue on GitHub.