nestjs-agent-workflow-kit: Skill for Claude Code

Prisma data layer

Persistence for this project uses Prisma. Rules summary lives in database.md; this skill is the deep reference.

PrismaService

The only place a Prisma client is instantiated:

@Injectable()
export class PrismaService extends PrismaClient implements OnModuleInit, OnModuleDestroy {
  async onModuleInit() { await this.$connect(); }
  async onModuleDestroy() { await this.$disconnect(); }
}

PrismaModule (global infrastructure)

@Global()
@Module({ providers: [PrismaService], exports: [PrismaService] })
export class PrismaModule {}

Never new PrismaClient() elsewhere. Inject PrismaService.

Where queries live

• Simple queries: directly in the feature service.
• Non-trivial aggregates: a repository per aggregate that wraps PrismaService. Repositories translate domain intent into queries and return models/DTOs; they hold no business rules.

@Injectable()
export class UsersRepository {
  constructor(private readonly prisma: PrismaService) {}

  findById(id: string) {
    return this.prisma.user.findUnique({ where: { id } });
  }

  create(data: Prisma.UserCreateInput) {
    return this.prisma.user.create({ data });
  }
}

Schema conventions (schema.prisma)

• Models PascalCase singular (User, OrderItem); fields camelCase.
• Use @map/@@map when the DB uses snake_case.
• Prefer cuid()/uuid() ids; add createdAt @default(now()) and updatedAt @updatedAt.
• Index foreign keys and frequent filters (@@index). Add @unique for natural keys.

model User {
  id           String   @id @default(cuid())
  email        String   @unique
  name         String
  passwordHash String   @map("password_hash")
  createdAt    DateTime @default(now()) @map("created_at")
  updatedAt    DateTime @updatedAt @map("updated_at")
  @@map("users")
}

Query hygiene

• Never $queryRawUnsafe/$executeRawUnsafe with interpolated input. Use the typed API or parameterized $queryRaw tagged templates.
• Use select/omit so sensitive columns never leave the data layer.
• Avoid N+1: use include/select relations or $transaction/findMany batching instead of awaiting queries in a loop.
• Always paginate list queries (take/skip or cursor).