constructive

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

CLI tool (csdk) for the infra API — provides CRUD commands for 10 tables and 4 custom operations

CLI tool (csdk) for the modules API — provides CRUD commands for 68 tables and 12 custom operations

CLI tool (csdk) for the objects API — provides CRUD commands for 5 tables and 4 custom operations

React Query hooks for the api API — provides typed query and mutation hooks for 47 tables and 9 custom operations

React Query hooks for the compute API — provides typed query and mutation hooks for 65 tables and 29 custom operations

React Query hooks for the infra API — provides typed query and mutation hooks for 10 tables and 4 custom operations

React Query hooks for the modules API — provides typed query and mutation hooks for 68 tables and 12 custom operations

React Query hooks for the objects API — provides typed query and mutation hooks for 5 tables and 4 custom operations

ORM client for the api API — provides typed CRUD operations for 47 tables and 9 custom operations

ORM client for the compute API — provides typed CRUD operations for 65 tables and 29 custom operations

ORM client for the infra API — provides typed CRUD operations for 10 tables and 4 custom operations

ORM client for the modules API — provides typed CRUD operations for 68 tables and 12 custom operations

ORM client for the objects API — provides typed CRUD operations for 5 tables and 4 custom operations

AST-backed PostgreSQL query builder — fluent API for SELECT/INSERT/UPDATE/DELETE with SDK-style JSON where filters, expression helpers, JOINs, CTEs, ON CONFLICT, RETURNING, parameterized values. Uses pg-ast + pgsql-deparser. Use when building parameterized SQL queries, writing test helpers, or working with TableClient in constructive-test.

Ephemeral pgpm fixture modules — install real published @pgpm/* modules into the gitignored root extensions/ directory and deploy them into test databases with seed.pgpm, instead of hand-maintaining copies of production DDL. Use when running or writing integration tests that need metaschema/services/module schemas, when tests fail with 'no pgpm module or workspace found', or when bumping fixture module versions.

PostgreSQL Package Manager — deterministic, plan-driven database migrations with dependency management. Use when asked to "deploy database", "run migrations", "manage pgpm modules", "add a table", "create a function", "add a migration", "write database changes", "create a workspace", "set up pgpm", "manage dependencies", "revert a migration", "verify deployments", "tag a release", "start postgres", "run database locally", "set up database environment", "load env vars", "add an extension", "install a module", "publish pgpm module", "test database", "write integration tests", "troubleshoot pgpm", or when working with PostgreSQL package management, .control files, pgpm.plan, or SQL migration scripts.

Scaffold new Constructive projects with pgpm init — workspace/module templates (PGPM and PNPM variants), the Next.js app boilerplate, custom template repositories, and boilerplate authoring. Use when asked to "create a new project", "scaffold a workspace", "scaffold a module", "create a starter kit", "start a boilerplate", "set up a Next.js app", "author a custom boilerplate template", "create a template repository", or "run pgpm init non-interactively in CI".

CLI tool (csdk) for the admin API — provides CRUD commands for 30 tables and 12 custom operations

CLI tool (csdk) for the agent API — provides CRUD commands for 9 tables and 1 custom operations

CLI tool (csdk) for the usage API — provides CRUD commands for 18 tables and 5 custom operations

React Query hooks for the admin API — provides typed query and mutation hooks for 30 tables and 12 custom operations

React Query hooks for the agent API — provides typed query and mutation hooks for 9 tables and 1 custom operations

React Query hooks for the auth API — provides typed query and mutation hooks for 13 tables and 35 custom operations

React Query hooks for the config API — provides typed query and mutation hooks for 5 tables and 13 custom operations

React Query hooks for the usage API — provides typed query and mutation hooks for 18 tables and 5 custom operations

ORM client for the admin API — provides typed CRUD operations for 30 tables and 12 custom operations

ORM client for the agent API — provides typed CRUD operations for 9 tables and 1 custom operations

ORM client for the auth API — provides typed CRUD operations for 13 tables and 35 custom operations

ORM client for the config API — provides typed CRUD operations for 5 tables and 13 custom operations

ORM client for the usage API — provides typed CRUD operations for 18 tables and 5 custom operations

Principal identity system at the application layer — ORM, CLI, and hooks usage for creating/managing principals (scoped sub-identities). Covers the dual-claim JWT model, principal lifecycle via SDK, org scoping with principal_entities, and AuthzHumanOnly enforcement. Use when asked to 'create a principal', 'manage API agents', 'scope an API key', 'use principals', or when building principal management features.

Unified PostGraphile v5 search plugin (graphile-search). Consolidates tsvector, BM25, pg_trgm, and pgvector into a single adapter-based architecture with composite searchScore and unifiedSearch fields. Includes codegen SDK query patterns for all search types. Use when asked to "add search to GraphQL", "expose search in PostGraphile", "configure search adapters", "query search via SDK/codegen", or when building search features on a Constructive or PostGraphile v5 stack.

Generated CLI commands and scaffolding — how the CLI is generated from GraphQL schemas, how to use it, codegen options, multi-target unified CLI, and the CLI reference. Use when asked to 'generate a CLI', 'create CLI commands', 'build a command-line client', 'run generated CLI', or when working with @constructive-io/graphql-codegen CLI output.

PNPM workspace management — monorepo configuration, dist-folder publishing with makage/lerna, dependency management, deep nested imports, and anti-patterns to avoid. Use when configuring pnpm workspaces, publishing packages to npm, managing monorepo dependencies, or setting up new TypeScript packages.