# Constructive Blueprints

> Define 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.

- Skill: `constructive-io/constructive-blueprints` (Agent Skill, multi-file: 5 files)
- Install (CLI): `npx skillmds@latest add constructive-io/constructive-blueprints`
- Raw SKILL.md: https://api.skillmd.com/api/skills/constructive-io/constructive-blueprints/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: constructive-io (https://skillmd.com/u/constructive-io)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/constructive-io/constructive-blueprints

---


# Constructive Blueprints

Declarative schema provisioning — define complete domain schemas as portable JSONB documents that compile into PostgreSQL tables, relations, security policies, and modules.

## When to Apply

Use this skill when:
- Defining a blueprint (tables, fields, relations, policies, entity types)
- Working with blueprint templates and the template marketplace
- Choosing a current backend module preset (`auth:hardened`, `b2b:storage`, or `full`)
- Understanding Merkle-style definition hashing for deduplication and provenance
- Using `construct_blueprint()` or `copy_template_to_blueprint()`

## Core Concepts

### Two-Layer Model

- **`blueprint_template`** — shareable marketplace recipe. Immutable definition + metadata.
- **`blueprint`** — owned, executable instance scoped to a database. Created from a template via `copy_template_to_blueprint()` or authored directly.

### Blueprint Definition Format

The `definition` JSONB contains:
- `entity_types[]` — Phase 0 entity provisioning (channels, teams, data rooms)
- `storage` — Phase 0.5 app-level storage config
- `tables[]` with `nodes[]`, `fields[]`, `policies[]` (using `$type` discriminators)
- `relations[]` — inter-table relationships
- `achievements[]` — gamification levels and rewards
- `limit_caps_defaults` — per-scope default caps
- `membership_types[]` — scope configurations (app, org, custom)

See [blueprint-definition-format.md](./references/blueprint-definition-format.md) for the full spec.

### Construction Lifecycle

```
blueprint.definition (JSONB)
  → construct_blueprint()
    → Phase 0: entity_type_provision (entity_types[])
    → Phase 0.5: storage provisioning
    → Phase 1: secure_table_provision (tables[] with nodes/fields/policies)
    → Phase 2: relation_provision (relations[])
    → Phase 3: post-processing (achievements, limits, jobs)
```

### Merkle Hashing

- `definition_hash` — Merkle root of the entire blueprint definition
- `table_hashes` — per-table UUIDv5 hashes for structural comparison
- Backend-computed via trigger using `uuid_generate_v5(uuid_ns_url(), jsonb::text)`
- Enables deduplication, provenance tracking, and structural diffing

### Module Presets

Constructive DB owns the backend module arrays for three supported presets. Resolve the current preset through its provisioning mechanism; do not copy module closure into a skill or application brief.

| Preset | Shape |
|--------|-------|
| `auth:hardened` | Hardened authentication and app access |
| `b2b:storage` | Hardened auth plus organizations and storage infrastructure |
| `full` | Complete reference capability set |

The canonical source lives in `constructive-db/packages/node-type-registry/src/module-presets/`. Blocks maps these backend profiles to frontend preset roots, but frontend installation remains a separate decision owned by [`constructive-blocks`](../constructive-blocks/SKILL.md).

A preset names the *modules* a database installs. The *content* seeded into them — a trust ladder, a limit baseline — is requested separately as an option on a module entry (`["events_module", { "trust_ladder": "humanity" }]`), and no shipped preset requests one today.

See [module-presets.md](./references/module-presets.md) for the full preset catalog and the content presets.

### Node Type Registry

The node type registry defines all node types available in blueprint definitions:

- **Data nodes** — field generators: `DataId`, `DataTimestamps`, `DataDirectOwner`, `DataEntityMembership`, `DataOwnershipInEntity`, `DataMemberOwner`, `DataI18n`, `DataPublishable`, `DataGenerated` (stored or PG18 virtual generated columns via `generation_type`)
- **Search nodes** — `SearchUnified`, `SearchVector`, `SearchFullText`
- **Process nodes** — `ProcessFileEmbedding`, `ProcessImageEmbedding`, `ProcessChunks`
- **Job nodes** — `JobTrigger`
- **Event nodes** — `EventTracker`, `EventReferral`
- **Guard nodes** — `GuardStepUp`
- **Limit nodes** — eight enforce, track, and warning nodes, including `LimitEnforceCounter`, `LimitTrackUsage`, and `LimitWarningRate`
- **Security nodes** — 25 registry-selectable Authz nodes, including the `AuthzColumnSecurity` write guard; the platform-applied `AuthzHumanOnly` mechanism is documented separately (see `constructive-security`)

See [node-type-registry.md](./references/node-type-registry.md) for the full catalog.

## References

| File | Content |
|------|---------|
| [blueprint-definition-format.md](./references/blueprint-definition-format.md) | Full definition spec with examples |
| [blueprints.md](./references/blueprints.md) | System reference — templates, construction, hashing |
| [module-presets.md](./references/module-presets.md) | Preset catalog, shape, and per-module rationale |
| [node-type-registry.md](./references/node-type-registry.md) | All node type families and their config shapes |

## Cross-References

- **Security policies on tables:** [`constructive-security`](../constructive-security/SKILL.md)
- **Entity types in blueprints:** [`constructive-entities`](../constructive-entities/SKILL.md)
- **Data modeling (tables, fields, relations):** [`constructive-data-modeling`](../constructive-data-modeling/SKILL.md)
- **Search nodes detail:** [`constructive-search`](../constructive-search/SKILL.md)
- **Job nodes detail:** [`constructive-jobs`](../constructive-jobs/SKILL.md)
- **Event nodes detail:** [`constructive-events`](../constructive-events/SKILL.md)
- **Frontend preset and feature-pack installation:** [`constructive-blocks`](../constructive-blocks/SKILL.md)