new-resource

When the user asks to add a new resource (e.g. "add a comments resource"), follow this exact sequence. Ask for the resource name if not provided.

Variables

• <Name> = PascalCase singular (e.g. Comment)
• <name> = camelCase singular (e.g. comment)
• <names> = camelCase plural (e.g. comments)

---

Step 1 — Prisma Schema (prisma/schema.prisma)

Add the new model first so TypeScript types are available for every subsequent step.

Requirements:

• id String @id @default(cuid())
• All fields with appropriate types and nullability
• Foreign key relations with onDelete: Cascade on the child side
• createdAt DateTime @default(now()) and updatedAt DateTime @updatedAt
• @@index on every foreign key column and commonly filtered fields
• @@map("snake_case_table_name")

Then immediately run:

pnpm prisma:migrate
pnpm prisma:generate

---

Step 2 — Types (src/types/<name>.types.ts)

Define DTOs before writing any other layer:

export interface Create<Name>DTO { /* fields */ }
export interface Update<Name>DTO { /* partial fields */ }
export interface <Name>ResponseDTO { /* safe fields to return, no password etc. */ }

Export from src/types/index.ts.

---

Step 3 — Validation (src/validations/<name>.validation.ts)

Create Zod v4 schemas. Pattern from src/validations/note.validation.ts:

import { z } from 'zod';
import { validateBody } from '../lib/validate';
import type { RequestHandler } from 'express';

export const create<Name>Schema = z.object({ /* fields */ });
export type Create<Name>Input = z.infer<typeof create<Name>Schema>;
export const create<Name>Validation: RequestHandler = validateBody(create<Name>Schema);

export const update<Name>Schema = z.object({ /* fields, all optional for PATCH */ });
export type Update<Name>Input = z.infer<typeof update<Name>Schema>;
export const update<Name>Validation: RequestHandler = validateBody(update<Name>Schema);

---

Step 4 — Repository (src/repository/<name>.repository.ts)