plugins/aai-stack-prisma/skills/prisma-schema/SKILL.md
February 1, 2026
Select agents to install to:
npx add-skill https://github.com/the-answerai/alphaagent-team/blob/main/plugins/aai-stack-prisma/skills/prisma-schema/SKILL.md -a claude-code --skill prisma-schemaInstallation paths:
.claude/skills/prisma-schema/# Prisma Schema Skill
Patterns for designing Prisma schemas.
## Basic Schema Structure
### Model Definition
```prisma
model User {
id String @id @default(uuid())
email String @unique
name String?
role Role @default(USER)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
posts Post[]
profile Profile?
sessions Session[]
@@index([email])
@@map("users")
}
enum Role {
USER
ADMIN
MODERATOR
}
```
### Field Types
```prisma
model Example {
// Scalar types
id String @id @default(uuid())
name String
bio String? // Optional
age Int
price Float
active Boolean @default(true)
count BigInt
// Dates
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
deletedAt DateTime?
// Database-specific
data Json
content String @db.Text
amount Decimal @db.Decimal(10, 2)
metadata Bytes
}
```
### ID Strategies
```prisma
// UUID (recommended for distributed systems)
model User {
id String @id @default(uuid())
}
// CUID (shorter, URL-safe)
model Post {
id String @id @default(cuid())
}
// Auto-increment
model Legacy {
id Int @id @default(autoincrement())
}
// Composite ID
model OrderItem {
orderId String
productId String
@@id([orderId, productId])
}
```
## Relationships
### One-to-One
```prisma
model User {
id String @id @default(uuid())
profile Profile?
}
model Profile {
id String @id @default(uuid())
bio String?
userId String @unique
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}
```
### One-to-Many
```prisma
model User {
id String @id @default(uuid())
posts Post[]
}
model Post {
id String @id @default(uuid())
title String
authorId String
author User @relation(fields: [authorId], references: [id])
@@index([authorId])
}
```
### Many-to-Many (Implicit)
```prisma
model Post {
id String