sql-to-go-struct-and-dao

What problem does it solve?

This Skill eliminates the repetitive, error-prone work of manually writing Go models, query/DTO types, view VO types, and DAO CRUD code from existing MySQL CREATE TABLE statements.

Core Features & Use Cases

• Generate full Go data access layers from SQL: Produces entity/PO, query DTO, view VO, and DAO CRUD code (with transactions and raw SQL) from your table schema.
• Support itea-go and gorm frameworks: Lets you choose the generated DAO style for either itea-go (BaseDao) or pure gorm in a consistent workflow.
• Schema-driven code consistency with DTO semantics: Applies conventions for DTO fields (Fuzzy/List/Start/End/OrderBy/Page) and the zero-value update semantics described in the references.

Quick Start

Tell the AI to generate Go code for your MySQL table by providing the CREATE TABLE SQL and configuring the output_path/package mapping under the .model_infrax directory for your project, then run jen to produce the model and DAO files.