constructive-io
- 33 skills
- 0 followers
- 1 week ago last updated
- ▌ Constructive Platform · constructive-io bundlePlatform core — services/schemas, deployment, server config, cloud functions, environment configuration, and the cnc CLI execution engine. Use when asked to 'deploy constructive', 'start the server', 'cnc server', 'GraphQL API', 'configure domains', 'cloud functions', 'Knative', 'env config', 'cnc execute', 'docker compose', 'set up service', 'API routing', 'services_public', or when working with server deployment or environment configuration.
- ▌ Constructive Realtime · constructive-io bundleSubscriptions, notifications, change_log, CursorTracker, ephemeral realtime — real-time data via GraphQL subscriptions, PostGraphile live queries, change tracking, and ephemeral pg_notify delivery. Use when asked to 'add subscriptions', 'real-time updates', 'live queries', 'notifications', 'change_log', 'CursorTracker', 'websocket', 'ephemeral realtime', 'pg_notify', 'high-frequency signals', or when working with real-time features in Constructive.
- ▌ Constructive Security · constructive-io bundleAuthorization with Constructive Authz, 25 registry Authz nodes plus platform-applied AuthzHumanOnly, RLS, grants, capabilities, GuardStepUp, read-only access, storage policies, secureTableProvision, and owning the security of a module-generated table. Use for RLS, grants, policies, AuthzAppMemberOwner, AuthzRelatedMemberOwner, AuthzColumnSecurity, AuthzComposite, system-only or human-only operations, column write guards, storage security, capability defaults, step-up auth, replacing a module's default grants or policies (registries, images, repositories, machines), blueprint provisions overrides, or authorization in blueprints and the ORM.
- ▌ Constructive Functions · constructive-io bundleCustomer-authored database functions and trigger attachments through the SDK ORM — `db.function` rows (kind `sql` | `plpgsql` | `trigger`) with a validated AST body, `apiExposed` opt-in to the generated GraphQL API, and `db.trigger` rows (kind `attachment`) that fire a customer trigger function AFTER INSERT/UPDATE/DELETE FOR EACH ROW with an optional `whenAst`. Use when asked to 'add a database function', 'write a PL/pgSQL function', 'custom SQL function', 'expose a function in the API', 'add a trigger', 'attach a trigger function', 'run code when a row changes', 'bodyAst', 'whenAst', 'apiExposed', 'FUNCTION_NAME_CONFLICT', 'FUNCTION_SCHEMA_NOT_EXPOSABLE', 'TRIGGER_ATTACHMENT_FUNCTION_NOT_A_TRIGGER', or 'FUNCTION_ENVELOPE_VIOLATION'.
- ▌ Constructive Blueprints · constructive-io bundleDefine Constructive schemas declaratively with blueprints, templates, node types, definition hashes, and current backend module presets. Use when creating or copying a blueprint, choosing auth:hardened, b2b:storage, or full backend provisioning, or working with blueprint definitions and the node type registry.
- ▌ Constructive Principals · constructive-io bundlePrincipals — scoped sub-identities for API keys and agents: short-lived access tokens with rotating refresh (mintAccessToken/refreshAccessToken), narrow-only child principals (createChildPrincipal), principal presets (createPrincipalFromPreset), API-key TTL caps, cascade revocation, the intent claim, trust-ladder unlocks and the agent ladder, refusal events recorded under their error code, and limit_refusals. Use when asked to 'create an API key', 'issue an agent credential', 'mint an access token', 'refresh token', 'REFRESH_TOKEN_REUSED', 'delegate to a child principal', 'PRINCIPAL_CHILD_WIDENS', 'deploy-bot preset', 'read-only-analyst', 'agent trust ladder', 'unlock a capability', 'scope an agent to an org', 'entity-scoped API key', 'read-only API key', 'revoke an API key', 'revoke a session', 'create a principal', 'org API key', 'service account', 'machine identity', 'agent identity', 'bypass step-up for a bot', 'STEP_UP_REQUIRED', 'principalEntity', 'principalScopeOverride', 'limit_refusals', or when mana
- ▌ Constructive Flow Graphs · constructive-io bundleGraph module and merkle store — SDK-authorable graph infrastructure (graphs, executions, outputs) with entity scoping, content-addressed merkle state tracking (objects, stores, commits, refs), and FBP integration. Use when asked to 'create a graph', 'graph module', 'merkle store', 'content-addressed storage', 'flow-based programming', 'graph executions', 'FBP', or when working with graph_module or merkle_store_module in blueprints.
- ▌ Constructive Architecture · constructive-ioConstructive platform architecture: core model, platform baseline, endpoint map, control plane vs data plane tokens, provisioning flow, data-module/policy pairing, and Authz policy types. Load for the platform mental model before schema or provisioning decisions.
- ▌ Constructive Data Modeling · constructive-io bundleModel Constructive application data through the SDK: tables, fields, relations, constraints, indexes, enums, views, identity columns, temporal and exclusion constraints, and database provisioning inputs. Use when creating or changing a schema, defining keys and referential actions, configuring view security, or working with metaschema operations.
- ▌ Constructive Notifications · constructive-io bundleNotification system — inbox, delivery, channels, preferences, bounce/complaint handling, suppression list, and digest batching. Use when asked to 'add notifications', 'notification preferences', 'bounce handling', 'complaint handling', 'suppression list', 'delivery log', 'notification channels', 'digest batching', 'quiet hours', 'webhook ingestion', 'SES bounces', 'SendGrid webhooks', 'channel deactivation', or when working with notifications_module in blueprints.
- ▌ Constructive Access Control · constructive-io bundleAccess control — roles, capabilities, profiles, grants, membership access, and entity-scoped authorization. Use when asked to 'assign capabilities', 'create roles', 'set up profiles', 'grant access', 'capability defaults', 'admin vs owner', 'membership capabilities', 'effective capabilities', 'revoke access', 'role hierarchy', 'custom roles', 'profile bundles', 'default profile', 'entity-scoped capabilities', 'org capabilities', 'app capabilities', 'capability resolution', 'trust levels', 'do owners get everything', or when working with the access control model in blueprints or the ORM.
- ▌ Constructive Secrets Config · constructive-io bundleMap of Constructive secrets and config plumbing: which of the four durable stores a value belongs in (secret vs config, internal vs namespace-backed infra) and why secret values are never readable through the SDK/ORM, site-domain provisioning, email-services topology, secrets/KMS/API-key surface, realms (the nullable discriminator that lets one name hold many values and lets a consumer pick one), and the hub .env keys that matter. Load for email, secrets, realm, or env/config issues.
- ▌ Constructive Troubleshooting · constructive-ioConstructive platform failure recipes: exact error strings mapped to root causes and fixes across provisioning, blueprints, RLS, auth, codegen, and frontend. Load when a build step or verify fails.
- ▌ Constructive Events · constructive-io bundleEventTracker, achievements, trust ladders, referrals, invite virality — EventTracker blueprint node for recording events on row changes, achievements[] for levels with credit rewards, the humanity and metered trust ladders that turn evidence into capability bits, EventReferral for multi-level referral chains, period-aware counting. Use when asked to 'add analytics', 'track events', 'add achievements', 'gamification', 'progressive trust', 'trust ladder', 'humanity', 'verify a human', 'levels', 'EventTracker', 'level requirements', 'achievement rewards', 'invite virality', 'referral credits', 'EventReferral', 'max_depth', 'multi-level referral', or when working with events_module in blueprints.
- ▌ Constructive Search · constructive-io bundleAll search strategies — tsvector full-text, BM25, trigram, pgvector semantic, PostGIS spatial, unified composite search, and RAG patterns. Use when asked to 'add search', 'full-text search', 'tsvector', 'BM25', 'trigram', 'pgvector', 'PostGIS', 'unified search', 'searchScore', 'unifiedSearch', 'semantic search', 'vector search', 'spatial search', 'RAG search', or when working with Search* blueprint nodes or graphile-search adapters.
- ▌ Constructive Billing · constructive-io bundleBilling, limits, plans, credits, feature flags, meters, usage tracking, rate enforcement, and threshold warnings. Use for billing setup, meters, quota checks, universal credits, cap tables, LimitEnforceCounter, LimitEnforceAggregate, LimitEnforceFeature, LimitEnforceRate, LimitTrackUsage, LimitWarningCounter, LimitWarningAggregate, LimitWarningRate, plan application, credit expiration, rollover credits, or billing and limits in blueprints.
- ▌ Constructive Builder · constructive-io bundleAssemble and verify a Constructive tenant frontend from an already-provisioned tenant database using the current Blocks feature packs and Console Kit. Use when an agent must choose a strict Blocks composition, bind a secret-free tenant descriptor and session, install current roots, add application-owned metadata-driven routes, resume a journaled run, or prove capability, auth, CRUD, RLS, responsive, and visual behavior end to end.
- ▌ Constructive Codegen · constructive-io bundleGenerate optional typed TypeScript clients, ORM models, React Query hooks, CLIs, and schema artifacts from a stable GraphQL schema. Use when compile-time domain types justify a regeneration workflow or when configuring @constructive-io/graphql-codegen. Do not use codegen as a prerequisite for Constructive feature packs or Console Kit.
- ▌ Constructive Gotchas · constructive-ioConstructive platform gotchas with stable rule IDs (CODEGEN-001, TS-001, SERVER-001, PGPM-001, …). Re-read before each new build feature; verify failures and tool block messages cite these IDs.
- ▌ Constructive Harness · constructive-io bundleThe Constructive harness workflow — building an app under the harness host (desktop, CLI, or other adapters of @agentic-kit/harness). Covers project init (.constructive/ bootstrap), brief intake (BRIEF.md + feature_list.json), the build-orchestrator state machine, and the typed database/schema/codegen tools (provision_database, provision_blueprint, add_relation, add_policies, run_codegen, run_preflight, field/template/record tools). Load when working in a harness-driven Constructive project — at session start, when .constructive/ is missing or the brief is empty, when choosing the next build step, or before any database, schema, or codegen action.
- ▌ Constructive History · constructive-ioRow history / temporal versioning — the DataHistory blueprint node (append-only <table>_history companion recorded by AFTER triggers), optional pg_partman range partitioning with a retention window, and the graphile-history plugin that adds history, versionAt, versionsBetween, and restore<Table>Version to the GraphQL API. Use when asked to 'add row history', 'audit log', 'track changes to a table', 'version history', 'point-in-time query', 'time-travel', 'as-of query', 'restore a previous version', 'roll back a row', 'DataHistory', 'versionAt', 'versionsBetween', 'restoreVersion', 'history retention', or when working with history/versioning in blueprints or the SDK.
- ▌ Constructive Storage · constructive-io bundleUploads, buckets, presigned URLs, file lifecycle — presigned URL flow (requestUploadUrl → PUT → downloadUrl), bucket provisioning, upload-client, public/private/entity-scoped buckets, MIME type restrictions, file size limits, and deduplication. Use when asked to 'upload files', 'add file uploads', 'configure storage', 'set up MinIO', 'presigned URLs', 'download URLs', 'bucket provisioning', or when working with storage plugins.
- ▌ Constructive Entities · constructive-io bundleMulti-tenancy, memberships, invites, entity types, entity-scoped storage, agent modules, and namespace modules. Use when asked to 'create entity types', 'add channels/teams/data rooms', 'provision entity storage', 'entity-scoped buckets', 'agent_module', 'namespace_module', 'invite users', 'profile assignment', 'memberships', 'multi-tenancy', 'org-scope', 'app-scope', or when working with entity_types in blueprints.
- ▌ Constructive Features · constructive-ioRoute Constructive application capabilities to the correct Blocks feature pack and authoritative domain skill. Use when asked what Constructive supports, which feature pack provides data, auth, users, organizations, storage, billing, or notifications, whether to use Console Kit or a standalone pack, or which skill owns an application capability.
- ▌ Constructive Frontend · constructive-io bundleBuild polished Constructive application UI with Constructive primitives, Tailwind CSS v4, app shell and app bar composition, CRUD Stack cards, and custom domain views. Use for visual composition, forms, overlays, layout, theming, accessibility, or bespoke domain UI. Use constructive-blocks for feature-pack and Console Kit installation/runtime work.
- ▌ Constructive Orm · constructive-io bundleUse the optional generated Constructive ORM for typed queries, mutations, relations, pagination, and custom-domain server workflows against a stable GraphQL schema. Use when asked about findMany, findOne, create, update, delete, relations, or pagination in generated ORM code. Use Blocks runtime for dynamic tenant consoles and generic _meta CRUD.
- ▌ Constructive Auth · constructive-io bundleConfigure Constructive identity, sign-up, sign-in, recovery, sessions, MFA, devices, identity linking, CAPTCHA, rate limits, cookie auth, and service-level authentication behavior (databaseSetting/apiSetting feature flags and request-protection bounds, webauthnSetting). Use for auth policy and backend capability questions, or when asked to 'disable introspection', 'set a rate limit', 'statement timeout', 'maxQueryDepth', 'enableBilling', 'link identity', 'passkeys'. Use constructive-blocks for installing the Authentication feature pack or Console Kit auth module.
- ▌ Constructive I18N · constructive-ioInternationalization — DataI18n translation tables, multilingual tsvector search with per-row language stemming (30+ languages), i18n_module for app-level language config, lang_column dynamic stemming, and graphile-i18n plugin for Accept-Language negotiation. Use when asked to 'add translations', 'make fields translatable', 'multilingual search', 'i18n', 'DataI18n', 'i18n_module', 'lang_column', 'per-language stemming', 'translation tables', 'locale strings', 'Accept-Language', or when working with i18n in blueprints.
- ▌ Constructive Jobs · constructive-io bundleBackground job system — JobTrigger blueprint node for enqueuing jobs on row changes (with compound conditions support: AND/OR/NOT combinators, column-aware type resolution), ProcessFileEmbedding/ProcessImageEmbedding/ProcessChunks composition wrappers, payload strategies, the Knative worker pipeline, scheduled jobs, and the app_jobs database extension. Use when asked to 'trigger a job', 'enqueue a background task', 'add a job trigger', 'run a function on row change', 'schedule a job', 'compound conditions', 'file embedding trigger', 'image embedding trigger', 'multi-modal embedding', or when working with JobTrigger/ProcessFileEmbedding/ProcessImageEmbedding/ProcessChunks in blueprints.
- ▌ Constructive Hooks · constructive-io bundleUse optional generated React Query hooks for a stable custom-domain schema and fixed endpoint, including query keys, invalidation, optimistic updates, and pagination. Use when a project deliberately generated hooks. Do not use generated hooks as a Console Kit or feature-pack runtime, or with process-wide mutable tenant configuration.
- ▌ Constructive Sites · constructive-io bundleSites — provision and serve web properties through the SDK ORM: one-call bucket-backed static sites (sitesProvisionStaticSite), immutable release manifests and rollback (siteRelease, activeCommitId, getSiteReleaseManifest), named preview hostnames (provisionSitePreview, setSitePreview, getSitePreviewCommit, deleteSitePreview), Merkle-versioned pages (db.page, pagePublished), Mantra auth/legal pages (sitesInstallMantra), content presets (sitesInstallContentPreset — pages:legal, robots:no-ai), mobile app links and /l/ deep links (siteAppLink, siteDeepLink, resolveSiteAppLinks, sitesDeepLinkUrl), and the tenant-vs-platform naming rule (db.site vs db.platformSite). Use when asked to 'provision a static site', 'deploy a static build', 'release manifest', 'roll back a site', 'preview URL', 'provisionSitePreview', 'setSitePreview', 'time travel a release', 'publish a page version', 'install mantra', 'add login pages to a site', 'install legal pages', 'robots preset', 'content preset', 'universal links', 'assetlinks'
- ▌ Constructive Agents · constructive-io bundleAI — agent module, LLM providers, RAG pipelines, embeddings, agentic-kit multi-provider client, Search* blueprint nodes (SearchUnified, SearchVector), ProcessFileEmbedding/ProcessImageEmbedding/ProcessChunks. Use when asked to 'add AI search', 'build RAG pipeline', 'embedding worker', 'agentic-kit', 'LLM integration', 'Ollama', 'Anthropic', 'OpenAI', 'file embedding', 'image embedding', 'chunking', 'SearchUnified', 'SearchVector', 'multiplayer agents', 'shared agents', 'multi-agent', 'agent_id', or when working with AI features in blueprints.
- ▌ Constructive Blocks · constructive-io bundleSelect, install, compose, integrate, and verify the complete Constructive Blocks registry, its standalone feature packs, and Console Kit. Use when adding Constructive UI primitives, app shell or app bar, billing blocks, standalone feature-pack views, Console modules, backend-aligned presets, a custom tenant console, or the full Next.js Console Kit; when wiring explicit tenant endpoints, sessions, _meta capability evidence, or modular Zustand state; and when diagnosing registry, release, capability, or RLS boundaries.