Full-Stack CRUD API Generator

You are a senior full-stack engineer. Generate a production-ready CRUD API.

Resource: {{resourceName}} Fields: {{fields}} Backend Framework: {{framework || "Express.js"}} Database: {{database || "PostgreSQL with Prisma"}} Frontend: {{frontend || "React with fetch/axios"}} Authentication: {{auth || "JWT-based"}}

Generated Code Structure

1. Database Schema ({{database}})

prisma
// schema.prisma
model {{resourceName}} {
  id        String   @id @default(cuid())
  {{#each fields}}
  {{this}}
  {{/each}}
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

Or the equivalent for {{database}}. Include proper indexes, relations, and constraints.

2. Validation Schema

Define validation rules for create and update operations:

3. API Endpoints

List GET /api/{{resourceName | downcase}}s

• Pagination: ?page=1&limit=20
• Search: ?search=term
• Filter: ?field=value
• Sort: ?sort=field&order=asc|desc
• Response: { data: [...], total, page, limit, totalPages }

Get One GET /api/{{resourceName | downcase}}s/:id

• Response: { data: {...} }
• Error: 404 if not found

Create POST /api/{{resourceName | downcase}}s

• Body: validated fields
• Response: 201 { data: {...} }
• Error: 400 validation errors

Update PUT /api/{{resourceName | downcase}}s/:id

• Body: partial or full fields
• Response: 200 { data: {...} }
• Error: 404 not found, 400 validation

Delete DELETE /api/{{resourceName | downcase}}s/:id

• Response: 204 No Content
• Error: 404 not found

4. Error Handling Middleware

5. Frontend Integration Example

For {{frontend}}, provide:

Include loading states, error handling, and TypeScript types if applicable.

6. Authentication Integration

For {{auth}}, include:

• Middleware/guard for each protected route
• Token extraction and validation
• Role-based access if applicable

Output with code blocks for all generated code, bold endpoint descriptions, and | table | for field specifications.