Skip to main content

Source: docs/manual/migrations.md

This page is generated by site/scripts/sync-manual-docs.mjs.

Data Schema and Migrations

Cruvero uses sequential SQL migrations to manage the Postgres schema. Each migration is a pair of .up.sql and .down.sql files in the migrations/ directory. Migrations are applied via the cmd/migrate CLI and are tracked in the schema_migrations table.

Source: migrations/*

Baseline Migrations​

0001_init​

  • tool_registries (immutable registries)
  • kv_store (generic JSON key/value)

0002_memory​

  • memory_episodes
  • memory_facts
  • memory_procedures

0003_memory_metadata​

  • Adds source_tool, source_step, source_run_id metadata

0004_traces​

  • agent_traces (per-step causal traces)

0005_retry_stats​

  • tool_retry_stats (adaptive retry learning)

0006_models​

  • model_catalog (OpenRouter + Azure model metadata)

0007_agent_versions​

  • agent_versions (semver + changelog)

0008_model_provider​

  • Adds provider and context normalization updates to model catalog

0012_embedding_cache​

  • embedding_cache for deduplicated embedding storage with TTL cleanup support

0013_tenants​

  • Multi-tenant core tables and row-level security policies

0014_tenant_usage_daily​

  • Daily tenant usage snapshots for quota enforcement

0015_quotas​

  • Quota override/policy tables for request/token/cost controls

0016_audit_log​

  • audit_log hash-chained event storage and supporting indexes/policies

Phase 10 Migrations​

0018_memory_salience​

Purpose: salience-aware retrieval and ranking inputs.

Adds to memory_facts:

  • source_type
  • retrieval_count
  • last_retrieved_at

0019_memory_decay​

Purpose: temporal reasoning over fact freshness/staleness.

Adds to memory_facts:

  • freshness_half_life
  • last_verified_at
  • fact_type

0020_immune​

Purpose: anomaly tracking and tool quarantine lifecycle.

Creates:

  • anomaly_signatures
  • tool_quarantine

0021_trust​

Purpose: trust-based delegation and accountability.

Creates:

  • agent_capabilities
  • agent_trust_scores
  • delegation_chain

0022_provenance​

Purpose: execution provenance DAG persistence and traversal.

Creates:

  • provenance_nodes
  • provenance_edges

Indexes include run/step/type/hash optimization for subgraph and diff queries.

Notes​

  • Migration 0017 is intentionally reserved.
  • Tenant-scoped tables use tenant keys and RLS policies where applicable.
  • Run migrations with cmd/migrate.