| name | crud-implementation |
| description | Complete workflow guide for implementing new CRUD entities. Use when adding a new resource, implementing full CRUD operations, or needing an overview of the database-to-API flow. Triggers: "new entity", "add resource", "implement CRUD", "create table and API". Orchestrates add-database-table, add-domain-entity, and add-api-endpoint skills. |
CRUD Implementation Workflow
Entry point for implementing a new entity with full CRUD operations.
Workflow Overview
โโโโโโโโโโโโโโโโโโโโโโโ โโโโโโโโโโโโโโโโโโโโโโโ โโโโโโโโโโโโโโโโโโโโโโโ
โ add-database-table โ --> โ add-domain-entity โ --> โ add-api-endpoint โ
โ โ โ โ โ โ
โ - Migration SQL โ โ - Domain model โ โ - Usecase โ
โ - Constant tables โ โ - Repository โ โ - Proto definition โ
โ - SQLBoiler gen โ โ - Marshaller โ โ - gRPC handler โ
โโโโโโโโโโโโโโโโโโโโโโโ โโโโโโโโโโโโโโโโโโโโโโโ โโโโโโโโโโโโโโโโโโโโโโโ
Quick Start
| Step | Skill | Key Command |
|---|
| 1 | add-database-table | make migrate.create then make migrate.up |
| 2 | add-domain-entity | make generate.mock |
| 3 | add-api-endpoint | make generate.buf |
Before You Start
- Know the entity name and its fields
- Identify relationships to existing entities
- Determine which API actor (admin/public/debug)
Step-by-Step
Step 1: Database Layer
Use the add-database-table skill for:
- Creating migration file with table DDL
- Adding indexes and foreign keys
- Creating constant tables for enum fields
- Running
make migrate.up to generate SQLBoiler
Step 2: Domain Layer
Use the add-domain-entity skill for:
- Domain model with constructor and update methods
- Repository interface with query structs
- Marshaller (DB model <-> domain model)
- Repository implementation
Step 3: API Layer
Use the add-api-endpoint skill for:
- Usecase input/output structs
- Interactor interface and implementation
- Protocol Buffers messages and RPCs
- gRPC handler and marshaller
- DI registration
Final Verification
make lint.go && make test
Related Skills
- code-investigation - Analyze existing patterns before implementation
- review-pr - Self-review before creating PR
- create-pull-request - PR creation with proper format
