api-crud-generator

API CRUD Generator

Generate production-ready CRUD REST API endpoints. This skill creates complete resource endpoints with validation, authentication, error handling, pagination, and tests.

When to Use

Trigger when the user asks to:

• Create API endpoints for a resource
• Build REST CRUD operations
• Generate backend routes with validation
• Add a new resource/entity to an existing API

Tech Stack Detection

Before generating code, detect the project's tech stack:

1. Check for package.json -> Node.js (Express, Fastify, Nest)
2. Check for requirements.txt or pyproject.toml -> Python (FastAPI, Django, Flask)
3. Check for go.mod -> Go (Gin, Echo, Chi)
4. Check for Gemfile -> Ruby (Rails, Sinatra)
5. If unclear, ask the user which framework to use.

Read the existing project structure to match conventions:

• File naming (camelCase vs snake_case vs kebab-case)
• Directory structure (routes/, controllers/, handlers/)
• Import style (ES modules vs CommonJS vs relative paths)
• Existing middleware patterns
• Database ORM in use (Prisma, TypeORM, SQLAlchemy, GORM, ActiveRecord)

Resource Definition

For each resource, determine:

1. Resource name (singular and plural forms)
2. Fields with types and constraints:
   • Required vs optional
   • String length limits
   • Number ranges
   • Enum values
   • Unique constraints
   • Default values
3. Relationships to other resources (hasMany, belongsTo, manyToMany)
4. Which fields are searchable/filterable
5. Which fields should be excluded from responses (passwords, internal IDs)

Endpoint Generation

Generate these endpoints for each resource:

GET /resources

• Pagination: ?page=1&limit=20 with max limit of 100
• Sorting: ?sort=createdAt&order=desc
• Filtering: ?status=active&category=tech
• Search: ?q=search+term across searchable fields
• Response format:

{
  "data": [...],
  "meta": {
    "total": 150,
    "page": 1,
    "limit": 20,
    "totalPages": 8
  }
}

GET /resources/:id

• Return 404 with { "error": "Resource not found" } if not exists
• Include related resources if ?include=comments,author is specified