Heldinhow Prisma ORM
Overview
Prisma provides type-safe database access with automatic migrations and a modern developer experience. This skill should be invoked when working with databases in TypeScript or Node.js applications that benefit from type safety and rapid development.
Core Principles
- Schema-Driven: Define database schema in schema.prisma
- Type Safety: Generated types for all queries
- Migration Support: Version-controlled schema changes
- Prisma Client: Type-safe query API
Preparation Checklist
- Initialize Prisma:
npm init prisma - Choose database (PostgreSQL, MySQL, SQLite)
- Design schema
- Configure connection string
Step-by-Step Process
- Initialize: Run
npm init prisma - Define Schema: Write models in schema.prisma
- Generate: Run
npx prisma generate - Migrate: Apply schema with
npx prisma db push - Query: Use Prisma Client for database operations
- Migrate: Create migrations for schema changes
Do's and Don'ts
- ✅ Do use Prisma Studio for debugging
- ✅ Do version control schema.prisma
- ✅ Do use transactions for multi-step operations
- ❌ Don't mix Prisma with raw SQL unnecessarily
- ❌ Don't skip migrations
- ❌ Don't ignore connection pooling
Anti-Patterns
- Mixed Queries: Mixing Prisma with raw SQL
- No Migrations: Changing schema without migrations
- Connection Leaks: Not properly managing connections
- Ignored Types: Not leveraging generated types