Guides Ent ORM schema changes, code regeneration, and Postgres type mappings in Go.
npx skills add https://github.com/openmeterio/openmeter --skill ent
Please help me install this Agent Skill. Skill: ent Source: https://github.com/openmeterio/openmeter/tree/main/.agents/skills/ent Command: npx skills add https://github.com/openmeterio/openmeter --skill ent
Working with Ent ORM in a large Go codebase involves subtle pitfalls: Postgres array columns silently mapping to jsonb, truncated identifier names colliding, upserts that fail to clear nullable fields, and generated code that must never be hand-edited. This Skill encodes those hard-won conventions so schema changes and query work are done correctly the first time.
text[] columns via field.Other with pq.StringArray, char(26) ULID foreign keys, soft-delete unique indexes, and JSONB value scanners.entselectedparse helpers like db.Parse<Entity>FromSelectedValues instead of hand-written row scanners.UpdateNewValues(), SetOrClear<Field> helpers, and pointer GoTypes that lack SetNillable<Field> variants.make generate, and need the upsert path to properly clear the column when the value is absent.Ask the assistant to modify an Ent schema under openmeter/ent/schema and regenerate the code following the ent skill conventions.
High-intent search queries and answers about installing and using this skill.
Use field.Other with pq.StringArray and a SchemaType mapping of text[] for the Postgres dialect, importing github.com/lib/pq. Avoid field.Strings, which creates jsonb or breaks the runtime encode/decode path.
Edit files under openmeter/ent/schema and run make generate to regenerate all generated Go code. For faster local iteration, run go generate ./openmeter/ent/... to regenerate only Ent output.
UpdateNewValues only updates fields set on the create mutation, so unset optional fields keep their old values. Chain the generated Update<Field>() method explicitly after UpdateNewValues to write NULL.
PostgreSQL truncates identifiers at 63 bytes, so long generated names can collide. Shorten them proactively with StorageKey on edges and indexes before generating migrations.
No, files under openmeter/ent/db are generated and must not be edited manually. Make changes in the schema definitions and regenerate the code instead.
ngxtmGenerate Go ORM code for database interactions using the Ent framework.
hiromailyAutomate Atlas schema migrations and SQLC query generation workflows.
dev-five-gitGenerate typed migration plans from declarative JSON database schemas.
galihcittaConvert ORM calls to raw SQL and analyze query performance.