Menu
ORM client for the infra API — provides typed CRUD operations for 10 tables and 4 custom operations
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Build interactive CLI tools with the Constructive CLI SDK. Use when asked to "create a CLI", "build a command-line tool", "add CLI prompts", "create interactive prompts", "store CLI config", "add terminal colors", or when building any CLI application in a Constructive project. This package provides runtime utilities for type coercion, config management, display formatting, and command handler patterns used by generated and custom CLIs.
The _meta schema-introspection plugin for PostGraphile v5 (MetaSchemaPlugin / MetaSchemaPreset in graphile-settings). Exposes a single _meta root query describing every table's fields, indexes, constraints, relations, inflection names, root query/mutation names, and smart-tag-derived metadata (storage, search, i18n, realtime). Use when asked to "expose database metadata in GraphQL", "add a field to _meta", "understand the _meta query", "drive codegen from _meta", or when adding a new smart-tag-detected metadata builder to the meta-schema plugin.
CLI tool (csdk) for the api API — provides CRUD commands for 47 tables and 9 custom operations
CLI tool (csdk) for the auth API — provides CRUD commands for 13 tables and 35 custom operations
CLI tool (csdk) for the compute API — provides CRUD commands for 65 tables and 29 custom operations
CLI tool (csdk) for the config API — provides CRUD commands for 5 tables and 13 custom operations
| name | orm-infra |
| description | ORM client for the infra API — provides typed CRUD operations for 10 tables and 4 custom operations |
ORM client for the infra API — provides typed CRUD operations for 10 tables and 4 custom operations
// Import the ORM client
import { db } from './orm';
// Available models: dbPreset, namespace, namespaceEvent, platformInfraCommit, platformInfraGetAllTreeNodesRecord, platformInfraObject, platformInfraRef, platformInfraStore, ...
db.<model>.findMany({ select: { id: true } }).execute()
db.<model>.findOne({ id: '<UUID>', select: { id: true } }).execute()
db.<model>.create({ data: { ... }, select: { id: true } }).execute()
db.<model>.update({ where: { id: '<UUID>' }, data: { ... }, select: { id: true } }).execute()
db.<model>.delete({ where: { id: '<UUID>' } }).execute()
const items = await db.dbPreset.findMany({
select: { id: true }
}).execute();
See the references/ directory for detailed per-entity API documentation: