prisma-workflow · git:20260120.f21f52f · 2026-01-20 · sha256 7d121a88c83189fd

prisma-workflow git:20260120.f21f52fA

Immutable. This exact content never changes and is served at /api/v1/blob/7d121a88c83189fd.

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_pphvt5ad7x74axxd/7d121a88c83189fdb1c54a970b9f7ed1e6869803ab463aa28cc87ba363b084a9.json

Then /plugin install prisma-workflow@markdownregistry-pphvt5ad7x74axxd in Claude Code. It installs this exact version, the one graded A here, pinned to the commit it was graded at, and leaves it there.

---
name: prisma-workflow
description: Prisma ORM best practices, schema design, migrations, seeding, and query optimization for PostgreSQL. Use when working with database schemas, migrations, or Prisma queries.
---

# 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 prisma.$transaction([
  prisma.user.update({ where: { id }, data: { balance: { decrement: 100 } } }),
  prisma.order.create({ data: { userId: id, amount: 100 } })
])
```

## Performance Tips

- Always index foreign keys
- Use `select` to fetch only needed fields
- Use `take` for large tables
- Batch operations with `createMany`
- Use transactions for related operations

## Prisma Service (NestJS)

```typescript
@Injectable()
export class PrismaService extends PrismaClient implements OnModuleInit {
  async onModuleInit() {
    await this.$connect()
  }
}
```