Prisma Visualizer

Schema definition, query flow, engine internals, and migration system — all visualized

Prisma Models

Models define your data shape. Each model becomes a table + a type-safe TypeScript interface.

schema.prisma

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  role      Role     @default(USER)
  posts     Post[]
  profile   Profile?
  createdAt DateTime @default(now())
}

Generated TypeScript

interface User {
  id: number
  email: string
  name: string | null
  role: Role
  posts: Post[]
  profile: Profile | null
  createdAt: Date
}

Enums

enum Role {
  USER
  ADMIN
  MODERATOR
}

// Usage in model:
model User {
  role Role @default(USER)
}