forge_admin/.agents/skills/forge-codegen-crud/SKILL.md

---

name: forge-codegen-crud

description: Generate or review Forge project code-generation output for CRUD modules. Use when creating single-table CRUD, master-detail CRUD, left-tree-right-table pages, or generated Forge backend/frontend/SQL artifacts covering list/detail/add/update/delete, batch delete, import/export, dictionary translation, API encryption/decryption, Flyway migrations, logical-delete fields and active-only unique indexes, sys_dict_type/sys_dict_data inserts, sys_excel_export_config/sys_excel_column_config inserts, and sys_resource menu or permission inserts.

Forge Codegen CRUD

Purpose

Generate Forge-compliant CRUD artifacts from business requirements without re-discovering project rules. Treat AGENTS.md as the highest priority source; this skill only codifies the repeatable codegen workflow.

Workflow

1. Read AGENTS.md, code-copilot/memory/pitfalls.md, code-copilot/memory/decisions.md, and code-copilot/memory/preferences.md before generating code.
2. Identify the page pattern: single-table, master-detail, or left-tree-right-table.
3. Before generating or reviewing any table or Flyway migration, read references/sql-seeds.md and references/validation-checklist.md. For single-table CRUD, also read references/single-table-crud.md.
4. If the request involves master-detail or left-tree-right-table, enforce the same schema, logical-delete, dictionary, Excel, resource, tenant, encryption, and validation rules, then inspect existing page-template components before implementation.
5. Generate Flyway SQL first, then backend files, frontend files, and menu/resource seed SQL.
6. Verify generated code against the checklist before reporting completion.

Non-Negotiable Rules

• Use Flyway scripts under forge/db/migration/ for all schema and built-in data changes.
• Use tenant_id = 1 for all built-in business data, dictionaries, and resources. Do not seed tenant 0.
• Add del_flag and an explicit @TableLogic to logical-delete business/configuration/design tables. For active-only business uniqueness with a numeric primary key, use BIGINT/Long del_flag, UNIQUE (..., del_flag), and @TableLogic(value = "0", delval = "<primary-key-column>"); custom deletes must write the row primary key. Never generate logic_delete_active, generated/function/partial indexes, (business_key, deleted_at) with active rows stored as NULL, or a fixed delete value of 1 for tombstone-indexed tables. Follow references/sql-seeds.md for the decision rules and string-primary-key exception.
• Put query SQL in Mapper XML. Do not generate Service-layer LambdaQueryWrapper query chains except MyBatis-Plus built-in selectById, insert, updateById, and deleteById style operations.
• Use pageNum and pageSize; never generate backend page as the page parameter.
• Use AiCrudPage URL placeholders with :id or :${rowKey}. Do not generate {id} placeholders.
• Generated CRUD controllers and frontend API configs must use Forge's POST-safe codegen contract for detail, create, update, and delete:
  • detail: POST /getById
  • create: POST /add
  • update: POST /edit
  • delete: POST /remove/{id} and post@.../remove/:id Do not generate PUT or DELETE endpoints for generated CRUD modules.
• Use DictSelect, DictTag, and useDict() for dictionary fields. Do not hardcode frontend options or status label maps.
• Generate sys_dict_type and sys_dict_data seed SQL for new dictionaries, or explicitly reuse an existing dictionary type discovered in migrations.
• Generate sys_excel_export_config and sys_excel_column_config seed SQL when import/export is enabled.
• Generate sys_resource seed SQL for menus and permissions after the page/API contract is known.
• Add @ApiDecrypt and @ApiEncrypt for sensitive or encrypted endpoints, and use encrypted frontend request modes consistently.

Required References

• references/single-table-crud.md: generated file layout, backend/frontend CRUD contract, batch delete, import/export endpoint shape.
• references/sql-seeds.md: table DDL, dictionary inserts, Excel config inserts, resource/menu inserts.
• references/validation-checklist.md: final review checklist for generated artifacts.

Output Expectations

When generating a CRUD module, provide:

• Backend Java artifacts: entity, DTO/query DTO, VO, Mapper, Mapper XML, Service, Service impl, Controller.
• Frontend artifacts: API module if the page needs it, Vue page using AiCrudPage, dictionary bindings, import/export options.
• Flyway SQL: table DDL, indexes, dictionaries, Excel config, resources, and optional API resources.
• Verification notes: compile/build commands attempted and any commands not run.