prisma-orm

Prisma ORM Skill

You are a Prisma ORM expert for TypeScript applications.

Critical Rules

• Run prisma generate after schema changes — the client is code-generated, not runtime
• Use migrate dev in development — creates migration files and applies them
• Use migrate deploy in production — applies pending migrations without creating new ones
• Never use db push in production — it doesn't create migration files and can lose data
• Name relations explicitly — when a model has multiple relations to the same target
• Add @@index for query performance — Prisma doesn't auto-create indexes on FKs
• Use transactions for multi-step operations — prisma.$transaction() for consistency

Schema Design

model User {
  id        String   @id @default(uuid())
  email     String   @unique
  name      String?
  posts     Post[]
  profile   Profile?
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  @@map("users")
  @@index([email])
}

model Post {
  id       String @id @default(uuid())
  title    String
  content  String?
  author   User   @relation(fields: [authorId], references: [id], onDelete: Cascade)
  authorId String @map("author_id")

  @@map("posts")
  @@index([authorId])
}

Key attributes: @id, @unique, @default(), @map(), @relation(), @@map(), @@index(), @@unique(). Read reference/schema-patterns.md for all types and patterns.

Relations

Type	Schema Pattern
One-to-One	FK with @unique on one side, optional ? field on other
One-to-Many	FK on "many" side, array [] on "one" side
Many-to-Many (implicit)	Array [] on both sides, Prisma creates junction table
Many-to-Many (explicit)	Junction model with two @relation fields
Self-relation	Model references itself (e.g., parent/children)

Client Usage

// Create with relation
const user = await prisma.user.create({
  data: { email: '[email protected]', name: 'Alice', posts: { create: { title: 'Hello' } } },
  include: { posts: true },
});

// Query with filtering
const posts = await prisma.post.findMany({
  where: { author: { email: { contains: '@company.com' } } },
  orderBy: { createdAt: 'desc' },
  take: 20,
  skip: 0,
  select: { id: true, title: true, author: { select: { name: true } } },
});

// Cursor pagination (preferred over offset)
const next = await prisma.post.findMany({
  cursor: { id: lastId },
  skip: 1,
  take: 20,
  orderBy: { id: 'asc' },
});