prisma-workflowlisted
Install: claude install-skill desilokesh1/antigravity-fullstack-hq
# Prisma Workflow
## Schema Design
```prisma
model User {
id String @id @default(cuid())
email String @unique
name String?
role Role @default(USER)
posts Post[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
@@index([email])
}
model Post {
id String @id @default(cuid())
title String
content String?
published Boolean @default(false)
author User @relation(fields: [authorId], references: [id], onDelete: Cascade)
authorId String
@@index([authorId])
}
enum Role {
USER
ADMIN
}
```
## Migration Workflow
1. Edit `schema.prisma`
2. `npx prisma migrate dev --name descriptive_name`
3. Review generated SQL in `prisma/migrations/`
4. Test on development
5. `npx prisma migrate deploy` for production
### Good Migration Names
```bash
npx prisma migrate dev --name add_user_role
npx prisma migrate dev --name create_posts_table
npx prisma migrate dev --name add_index_on_email
```
## Query Patterns
### Select Specific Fields
```typescript
const user = await prisma.user.findUnique({
where: { id },
select: { id: true, email: true, name: true }
})
```
### Include Relations
```typescript
const user = await prisma.user.findUnique({
where: { id },
include: { posts: true }
})
```
### Pagination
```typescript
const users = await prisma.user.findMany({
skip: (page - 1) * limit,
take: limit,
orderBy: { createdAt: 'desc' }
})
```
### Transactions
```typescript
await