Imported from AVIDS2/seat-reserver (api/.claude/skills/generate/SKILL.md). Install upstream with npx skills add AVIDS2/seat-reserver --skill generate. Copyright stays with the author.

Generate Entities and Properties

Detect the database variant

Before running any command, grep package.json scripts to determine {db}:

• generate:resource:all-db present → {db} = all-db (PostgreSQL + MongoDB).
• generate:resource:relational present (and no all-db) → {db} = relational (PostgreSQL/TypeORM).
• generate:resource:document present (and no all-db) → {db} = document (MongoDB).

Do not ask the user — whichever generate:resource:* and add:property:to-* scripts remain in package.json are exactly the right ones to run.

Add an entity/schema

Rules:

• Never generate User or File entities — they already exist. You can reference them in relationships.
• Entity names must be PascalCase and singular (e.g., Post, Category, BlogComment).

Command:

npm run generate:resource:{db} -- --name {EntityName}

{db} comes from the detection section above.

Run sequentially, one entity at a time.

Add a property to an entity/schema

Rules:

• Never add id, createdAt, or updatedAt — these are predefined for all entities.
• Property names must be camelCase (e.g., firstName, isActive).

Property kinds:

• primitive — basic types: string, number, boolean, Date
• reference — relationship to another entity
• denormalized — denormalized copy of another entity's data (stored inline instead of referenced)

Relationship rules:

• When creating a property with referenceType: "oneToMany", do NOT create the corresponding manyToOne in the referenced entity — the generator creates it automatically.
• Do NOT create oneToMany if the propertyInReference could have many items. Instead, create a manyToOne on the child entity only.
• For File relations, use only oneToOne or manyToMany.
• propertyInReference is only required when referenceType is oneToMany.

Command:

npm run add:property:to-{db} -- --name {EntityName} --property {propertyName} --kind {kind} --type {type} --referenceType {referenceType} --propertyInReference {propertyInReference} --isAddToDto {isAddToDto} --isOptional {isOptional} --isNullable {isNullable} --shouldAutoLoad {shouldAutoLoad}

Argument rules:

• --name (required): Entity name, PascalCase
• --property (required): Property name, camelCase
• --kind (required): primitive | reference | denormalized
• --type (required): For primitive: string | number | boolean | Date. For reference/denormalized: the referenced entity name (e.g., User, File, Category)
• --referenceType: Only for reference/denormalized kind. Values: oneToOne | oneToMany | manyToOne | manyToMany
• --propertyInReference: Only when referenceType is oneToMany. The property name on the referenced entity.
• --isAddToDto: true | false — whether the property can be set via HTTP request
• --isOptional: true | false
• --isNullable: true | false — only meaningful when isOptional is true
• --shouldAutoLoad: true (default) | false. Only meaningful for kind=reference. true emits eager: true (TypeORM) and autopopulate: true (Mongoose). false stores only the related entity's id (Mongoose: string field + ObjectId; TypeORM: eager: false). No effect for primitive/denormalized.

Omit arguments that don't apply (e.g., omit --referenceType for primitive properties, omit --propertyInReference unless referenceType is oneToMany).

Run sequentially, one property at a time.