What problem does it solve? Backend models need consistent PostgreSQL functions for list, get, save, delete, and lookup operations, but hand-writing them leads to inconsistent signatures, drifting response shapes, and duplicated SQL. This Skill standardizes the function contract so every model command accepts a user id plus a JSONB payload and returns a stable JSONB envelope. ## Core Features & Use Cases - Standard command contract: Defines naming ({schema}.{model}_{command}), signatures, and a fixed response envelope with item, rows, options, totals, extra, messages, and meta keys. - Generated CRUD workflow: Standard list/get/save/delete/lookup functions are generated from the model's TypeBox schema and manifest via deno task sql:gen, with per-function overrides in db/<model>.custom.sql. - Document and register semantics: Covers posting/unposting, soft-delete marking, related-document trees, compound and off-balance journal entries, and localized user-facing messages via @[key] markers. - Use Case: When adding a new catalog or document model, use this Skill to write only the schema, manifest, and DDL, then generate the five standard functions and add custom SQL only for non-standard logic. ## Quick Start Describe the model and the shape of its list, item, options, and save data so the Skill can define the PostgreSQL function contract for it.
