Menu
Add or modify CRUD entities following the layered architecture pattern with oRPC contracts and Inversify DI. Use when adding new database models, creating API endpoints, or implementing data access layers.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Commit, push, open a PR, and monitor CI/CD in a loop. Use when the user says "ship it", "commit push and watch CI", or wants to open a PR and monitor checks. Auto-fixes obvious CI failures and stops to ask for non-obvious ones.
Add and manage integration tests for repositories and API endpoints. Use when adding integration tests, testing a repository, testing an API endpoint, or setting up integration test infrastructure.
Wire classes into the Inversify DI container correctly. Use when adding new repositories, controllers, services, or middleware to the server. Use when wiring dependencies, configuring the DI container, or understanding how classes are resolved.
Configure the anthropics/claude-code-action GitHub Action correctly. Use when setting up Claude Code workflows, troubleshooting GitHub Action configuration, or passing CLI flags via claude_args.
Create and improve Claude Skills with proper structure, frontmatter, and best practices. Use when creating new skills, improving existing skills, refactoring skill content, or scaffolding skill files.
Troubleshoot Docker Compose startup errors. Use when encountering network conflicts, container name collisions, orphaned containers, or other Docker setup issues.
| name | crud |
| description | Add or modify CRUD entities following the layered architecture pattern with oRPC contracts and Inversify DI. Use when adding new database models, creating API endpoints, or implementing data access layers. |
This skill guides implementing CRUD operations following the layered architecture pattern.
1. Prisma Schema → apps/server/src/db/prisma/schema.prisma
2. Zod Types → packages/common/src/contracts/v1/<entity>/types.ts
3. oRPC Contract → packages/common/src/contracts/v1/<entity>/router.ts
4. Repository Layer → apps/server/src/repositories/
5. Controller Layer → apps/server/src/controllers/
6. oRPC Router (impl) → apps/server/src/routers/v1/<entity>/router.ts
7. DI Container → apps/server/src/di/container.ts
apps/server/src/db/prisma/schema.prismacd apps/server && bun run db:migratecd apps/server && bun run db:generatepackages/common/src/contracts/v1/<entity>/types.tspackages/common/src/contracts/v1/<entity>/router.tspackages/common/src/contracts/index.tspackages/common/src/contracts/app-contract.tsapps/server/src/repositories/ (with @injectable())apps/server/src/controllers/ (with @injectable())apps/server/src/routers/v1/<entity>/router.tsapps/server/src/routers/orpc.tscd apps/server && bun run buildorg_xxxxx format. Use z.string().min(1) not z.string().uuid()context.orgId in router handlersgetOrCreate patterns for users/orgs when webhooks aren't guaranteedusers (e.g., created_by), user must exist firstensureUser and ensureOrganization utilities before creating recordsapps/server/src/utils/ensure-user.ts and ensure-organization.tsauthed middleware from orpc-middleware.ts for authenticated routes — no manual auth checksunwrapResult(result) to convert Result<T> into a thrown ORPCError on failuremethod: 'GET', path: '/v1/entities')packages/common/src/contracts/errors.ts via oc.errors()For detailed implementation patterns, see reference.md.