Claude-skill-registry crud-implementation

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.

install

source · Clone the upstream repo

git clone https://github.com/majiayu000/claude-skill-registry

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/crud-implementation" ~/.claude/skills/majiayu000-claude-skill-registry-crud-implementation && rm -rf "$T"

manifest: skills/data/crud-implementation/SKILL.md

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

add-database-table

make migrate.create

then

make migrate.up

add-domain-entity

make generate.mock

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