constructive
Constructive Platform
Consolidated reference for the Constructive platform's core architecture: blueprints, authorization, services, deployment, server configuration, cloud functions, environment configuration, and the CLI execution engine.
Blueprints
- Declarative schema provisioning system — define complete domain schemas as portable JSONB documents
- Two-layer model:
blueprint_template(shareable marketplace recipe) andblueprint(owned, executable instance scoped to a database) - Definition format:
entity_types[](Phase 0 entity provisioning),storage(Phase 0.5 app-level storage),tables[]withnodes[],fields[],policies[](using$typediscriminators), andrelations[] construct_blueprint()executes a draft blueprint, provisioning real tables and relations viasecure_table_provision+relation_provisioncopy_template_to_blueprint()copies a template to a new blueprint with visibility checks and copy_count tracking- Merkle-style content-addressable hashing:
definition_hash(Merkle root) andtable_hashes(per-table UUIDv5 hashes) for deduplication, provenance tracking, and structural comparison - Hashes are backend-computed via trigger using
uuid_generate_v5(uuid_ns_url(), jsonb::text)— same pattern asobject_store.object_hash_uuid()
Triggers: "create a blueprint", "blueprint template", "construct blueprint", "copy template", "blueprint definition", "definition hash", "table hashes", "schema marketplace", "blueprint provisioning"
See blueprints.md for the full system reference.
Sub-references:
More from constructive-io/constructive-skills
drizzle-orm
Drizzle ORM patterns for PostgreSQL schema design and queries. Use when asked to "design Drizzle schema", "write Drizzle queries", "set up Drizzle ORM", or when building type-safe database layers.
21planning-blueprinting
In-repo planning and specification system for software projects. Use when asked to "create a plan", "write a spec", "document a proposal", "blueprint a feature", or when doing architectural planning work.
20pgsql-parser-testing
Test the pgsql-parser repository (SQL parser/deparser). Use when working in the pgsql-parser repo, fixing deparser issues, running parser tests, or validating SQL round-trips. Scoped specifically to the constructive-io/pgsql-parser repository.
18constructive-graphql-codegen
Generate type-safe React Query hooks, Prisma-like ORM client, or inquirerer-based CLI from GraphQL endpoints, schema files/directories, databases, or PGPM modules using @constructive-io/graphql-codegen. Also generates documentation (README, AGENTS.md, skills/, mcp.json). Use when asked to "generate GraphQL hooks", "generate ORM", "generate CLI", "set up codegen", "generate docs", "generate skills", "export schema", or when implementing data fetching for a PostGraphile backend.
17constructive-server-config
Configure and run the Constructive GraphQL server (cnc server), GraphiQL explorer (cnc explorer), and code generation (cnc codegen). Use when asked to "start the server", "run cnc server", "start GraphQL API", "run GraphiQL", "configure API routing", "generate types", or when working with the Constructive CLI and PostGraphile.
17constructive-boilerplate-nextjs-app
Set up and develop with the Constructive App frontend boilerplate — a Next.js application with authentication, organization management, invites, members, and a GraphQL SDK. Use when scaffolding a new Constructive frontend application from the boilerplate.
17