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:

Execution Flow

See references/execution-flow.md for detailed steps.

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

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