메뉴
用 jen (github.com/LingoJack/model_infrax) 把 MySQL 建表 SQL 生成一整套 Go 代码（PO/entity、查询 DTO、视图 VO、DAO），支持 itea-go 与 gorm 两种框架。触发场景：用户提供 CREATE TABLE 语句要生成 Go model/DAO；用户说"根据这张表生成结构体/DAO/CRUD"；用户想搭建 gorm 项目的数据访问层；`.model_infrax/` 目录存在或被提及。不要用在非 MySQL、非 gorm 体系的场景。
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
j-cli (work-copilot) command-line tool for daily workflow automation. TRIGGER when user wants to: (1) manage daily/weekly reports (日报/周报/report), (2) manage todo items (待办/todo), (3) open apps or URLs via aliases, (4) register/manage app aliases (别名), (5) create or run preset scripts (脚本/concat), (6) install or check j-cli availability. DO NOT TRIGGER for general shell commands unrelated to j-cli.
j-cli (j) 项目开发者入门指南。当开发者需要了解 jcli 项目结构、各模块职责、开发流程，或者需要完成常见开发任务（添加新命令、新工具、修改 Chat 模块、调整 Hook/Permission 系统等）时使用此 skill。适用场景：新成员上手、代码导航、功能开发 checklist 查询。
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Codex's capabilities with specialized knowledge, workflows, or tool integrations.
HTML PPT Studio — author professional static HTML presentations in many styles, layouts, and animations, all driven by templates. Use when the user asks for a presentation, PPT, slides, keynote, deck, slideshow, "幻灯片", "演讲稿", "做一份 PPT", "做一份 slides", a reveal-style HTML deck, a 小红书 图文, or any kind of multi-slide pitch/report/sharing document that should look tasteful and be usable with keyboard navigation. Triggers include keywords like "presentation", "ppt", "slides", "deck", "keynote", "reveal", "slideshow", "幻灯片", "演讲稿", "分享稿", "小红书图文", "talk slides", "pitch deck", "tech sharing", "technical presentation".
完整前后台 Web 应用生成技能包；1. 当用户需要快速生成一个 Web 应用时，触发此技能
HTML PPT Studio — author professional static HTML presentations in many styles, layouts, and animations, all driven by templates. Use when the user asks for a presentation, PPT, slides, keynote, deck, slideshow, "幻灯片", "演讲稿", "做一份 PPT", "做一份 slides", a reveal-style HTML deck, a 小红书 图文, or any kind of multi-slide pitch/report/sharing document that should look tasteful and be usable with keyboard navigation. Triggers include keywords like "presentation", "ppt", "slides", "deck", "keynote", "reveal", "slideshow", "幻灯片", "演讲稿", "分享稿", "小红书图文", "talk slides", "pitch deck", "tech sharing", "technical presentation".
| name | sql-to-go-struct-and-dao |
| description | 用 jen (github.com/LingoJack/model_infrax) 把 MySQL 建表 SQL 生成一整套 Go 代码（PO/entity、查询 DTO、视图 VO、DAO），支持 itea-go 与 gorm 两种框架。触发场景：用户提供 CREATE TABLE 语句要生成 Go model/DAO；用户说"根据这张表生成结构体/DAO/CRUD"；用户想搭建 gorm 项目的数据访问层；`.model_infrax/` 目录存在或被提及。不要用在非 MySQL、非 gorm 体系的场景。 |
command -v jen >/dev/null || go install github.com/LingoJack/model_infrax/cmd/jen@latest
在项目根目录执行：
jen init
生成 .model_infrax/{config.yml, schema.sql}。如果已存在会询问是否覆盖。
CREATE TABLE ... 贴到 .model_infrax/schema.sql.model_infrax/config.yml，必须确认：
output_path — 输出目录，相对项目根。默认 target/jen，几乎总要改成项目真实代码目录（如 internal/gen），不然生成完还要搬use_framework — itea-go（依赖腾讯内网 git.woa.com/... 的 igorm.BaseDao）或 gorm（纯 gorm）package — 5 个子包路径，必须和 output_path 下真实目录层级一致，否则跨包 import 会断字段全量说明与人工处理清单见 references/config.md。
jen # 读 .model_infrax/config.yml
jen -c <path> # 或指定配置
以表 t_example 为例，<output_path>/ 下得到：
model/entity/t_example.go # PO + Builder + Jsonify
model/query/t_example_dto.go # 查询 DTO + Builder
model/view/t_example_vo.go # VO
dao/t_example_dao.go # CRUD + 事务 + 原生 SQL
tool/*.go # 一整套通用工具（整个项目只需一份）
调用方式、DTO 字段约定（Fuzzy/List/Start/End/OrderBy/Page）、零值覆盖语义、事务写法见 references/generated-code.md。修改数据时零值语义易错，首次使用务必读这个文件。
func (dao *XxxDao) Database() string 默认返回 "@database_name"，改成真实逻辑库名use_framework: itea-go 时确认能拉到 git.woa.com/tencent-cloud-platform/go-module/itea-gorm；拉不到就切 gormgo build ./... 验证 import 路径（output_path + package 配对是否正确）tool/ 工具包，跟生成的 tool/ 去重