labspangaea Skill: create-elysia-repository
Generate domain + port + Drizzle repository + Drizzle schema + apperr for one entity.
Parameters
| Parameter | Required | Default | Values |
|---|---|---|---|
database |
no | drizzle-postgres |
drizzle-postgres · drizzle-mysql · none |
cache |
no | none |
none · redis · memory · couchbase |
Prerequisites
| Item | Action if missing |
|---|---|
package.json + tsconfig.json in cwd |
Tell the user this skill works inside an existing Bun project; suggest /create-elysia-app to start fresh |
@labspangaea/ts-lib installed |
bun install first; it is a public npm package, fetched from the public registry |
| Entity schema OR existing domain file | Ask — see Mode selection |
Step 1 — Choose mode
AskUserQuestion({
question: "How should we source the entity for this repository?",
header: "Mode",
options: [
{ label: "New schema (Recommended)", description: "Paste JSON / SQL / OpenAPI / Postman — generate domain + port + repository + schema + apperr from scratch" },
{ label: "Existing domain", description: "Reuse an existing src/domain/*.ts file — generate only port + repository + schema + apperr" }
]
})
Mode A — New schema: user provides the entity schema (JSON example / SQL CREATE TABLE / OpenAPI properties: / Postman body).
Mode B — Existing domain: find src/domain -name '*.ts' -not -name '*.test.ts', surface the pick (≤4 → AskUserQuestion, one option per file; >4 → numbered text prompt). Read the interface to extract fields; skip domain generation.
Step 2 — Database & cache
Ask database then (if database != none) cache via AskUserQuestion (same option lists as /create-elysia-app Steps 3–4). Map labels → drizzle-postgres/drizzle-mysql/none and none/redis/memory/couchbase.
Step 3 — Schema parsing (the canonical rules other skills delegate to)
Parse the schema into Fields. Always strip system fields (id, created_at/createdAt, updated_at/updatedAt) — they are injected.
Type mapping (SQL / JSON / OAS → TS domain · TypeBox · Drizzle column):
| Source | TS type | TypeBox | Drizzle |
|---|---|---|---|
| VARCHAR/TEXT/CHAR/string | string |
t.String() |
varchar/text |
| INT/INTEGER/number(int) | number |
t.Integer() |
integer |
| BIGINT | number |
t.Integer() |
bigint({mode:'number'}) |
| FLOAT/DOUBLE/DECIMAL/number(float) | number |
t.Number() |
doublePrecision |
| BOOLEAN/BOOL/TINYINT(1) | boolean |
t.Boolean() |
boolean |
| TIMESTAMP/DATETIME/date-time | Date |
t.String({format:'date-time'}) |
bigint({mode:'number'}) |
| UUID | string |
t.String({format:'uuid'}) |
varchar |
Nullable (NULL / nullable:true / not in required): TS type T | null; Drizzle drops .notNull().
FieldDef (used by the templates): .Name (camelCase), .GoType (TS type string incl. | null), .JSONName (snake_case wire), .DBColumn (snake_case), .Validate (required / required,max=N / ``). The name GoType is kept so the Params shape matches the renderer's FieldDef.
System fields (always injected): id (string, varchar(36) PK), createdAt/updatedAt (Date domain, bigint epoch-ms column). The repository maps bigint(string from driver) → Number → Date.
Step 4 — Apperr base offset
Before generating src/apperr/{entityLower}.ts, scan existing src/apperr/*.ts for BASE = N. Set ApperrBase = highest N + 1000, default 1000. Prevents code collisions.
Step 5 — Render
Build the Params JSON (see /create-elysia-app "Template Rendering") and render via bun ${CLAUDE_SKILL_DIR}/../../tools/render-file/index.ts. Templates live at ${CLAUDE_SKILL_DIR}/../create-elysia-app/references/.
| Mode | Templates → output |
|---|---|
| A | domain.ts.tmpl → src/domain/{e}.ts; port.ts.tmpl → src/port/{e}.ts; apperr.ts.tmpl → src/apperr/{e}.ts; schema.ts.tmpl → src/db/schema/{e}.ts (skip if database=none); repository.ts.tmpl → src/adapter/outbound/repository/{e}.ts (skip if database=none) |
| B | same as A minus domain.ts.tmpl |
If an output file exists, ask before overwriting.
Key patterns enforced by the templates
- The repository implements the domain-typed
port.{Entity}Repository, internally wrappingrepo.BaseRepo/CachedRepoover a snake_case{Entity}Row+ aModelMeta(Drizzle 0.38 has no runtime reflection). toDomain/toRowmap row↔domain; Date fields coercenew Date(Number(col))(Postgres bigint arrives as a string).mapRepoErrmapsrepo.ErrNotFound→new ApiError(Err{Entity}NotFound).updatepasses an explicit column list (never clobbersid/created_at).newCached{Entity}Repositoryis emitted only whencache != none; the key prefix is owned bymakeCachedRepository(no double-prefix on the backend).
Step 6 — Verify
mcp__ts-lsp__ts_diagnoseon each generated.ts. Fix all errors.bunx tsc --noEmitfrom the project root. Fix all errors.- Do not report done until both pass clean.