crud

name	crud
description	Explicit helper for CRUD scaffolding and API endpoint generation. Do NOT load for: UI components, form design, database schema discussion, or general implementation.

CRUD Skill

Auto-generates CRUD functionality for specified entities (tables) at production-ready level.

Quick Reference

• "Create CRUD for task management" → /crud tasks
• "Want search and pagination too" → Includes all together
• "Include permissions (who can view/edit)" → Sets up authorization/rules together

Deliverables

• CRUD + validation + authorization + tests, complete production-safe set
• Minimize diff to match existing DB/code

Features:

• Validation (Zod) auto-add
• Auth/authorization (Row Level Security) auto-config
• Relations (one-to-many, many-to-many) support
• Pagination, search, filters
• Auto-generated test cases

---

Auto-invoke Skills

This skill must explicitly invoke the following skills with the Skill tool:

Skill	Purpose	When to Call
impl	Implementation (parent skill)	CRUD feature implementation
verify	Verification (parent skill)	Post-implementation verification

---

Execution Flow

Detailed steps are described in the phases below.

Phase 1: Entity Analysis

1. Parse entity name from $ARGUMENTS
2. Detect existing schema (Prisma, Drizzle, raw SQL)
3. Infer field types and relations

Phase 2: CRUD Generation

1. Generate model/schema if needed
2. Create API endpoints (REST or tRPC)
3. Add validation schemas (Zod)
4. Configure authorization rules

Phase 3: Test Generation

1. Create unit tests for each endpoint
2. Add integration tests
3. Generate test fixtures

Phase 4: Verification

1. Run type check
2. Run tests
3. Verify build

---

Supported Frameworks

Framework	Detection	Generated Files
Next.js + Prisma	prisma/schema.prisma	API routes, Prisma client
Next.js + Drizzle	drizzle.config.ts	API routes, Drizzle queries
Express	express in package.json	Controllers, routes
Hono	hono in package.json	Route handlers

---

Output Structure

src/
├── lib/
│   └── validations/
│       └── {entity}.ts        # Zod schemas
├── app/api/{entity}/
│   ├── route.ts              # GET (list), POST (create)
│   └── [id]/
│       └── route.ts          # GET, PUT, DELETE
└── tests/
    └── {entity}.test.ts      # Test cases

---

Related Skills

• impl - Feature implementation
• verify - Build verification
• auth - Authentication/authorization