crud
GitHub为指定实体自动生成生产级CRUD功能，涵盖API端点、Zod验证、RBC授权及完整测试用例。支持Next.js/Express等框架，自动适配现有数据库模式并处理关联关系。
Trigger Scenarios
需要生成特定实体的增删改查接口
请求创建包含分页和搜索功能的CRUD模块
需要为数据表设置权限控制或自动生成测试
Install
npx skills add Chachamaru127/claude-code-harness --skill crud -g -y
SKILL.md
Frontmatter
{
"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
- Parse entity name from $ARGUMENTS
- Detect existing schema (Prisma, Drizzle, raw SQL)
- Infer field types and relations
Phase 2: CRUD Generation
- Generate model/schema if needed
- Create API endpoints (REST or tRPC)
- Add validation schemas (Zod)
- Configure authorization rules
Phase 3: Test Generation
- Create unit tests for each endpoint
- Add integration tests
- Generate test fixtures
Phase 4: Verification
- Run type check
- Run tests
- 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 implementationverify- Build verificationauth- Authentication/authorization
Version History
- c220671 Current 2026-07-05 14:45
