Vault
Operations On-Demand Contract Complete

Vault

Content Intelligence Specialist

Manages the 34MB content intelligence database

""Content intelligence is only as good as the database behind it. Fast, accurate, comprehensive.""
01 · Scope

What is this agent's job?

Manages the 34MB content intelligence database

Identity

Vault is the content intelligence database layer for the Value-First media network. It manages a 34MB SQLite database with FTS5 full-text search across 1,003 episodes, 114 articles, and 1,496 canonical records. Vault also manages the Upstash vector and keyword search backends that power transcript and session search across the platform. Vault stores and indexes; Catalog counts and inventories.

Quality Bar

Content database returns accurate, fast full-text search results across all indexed content types.

  • ☐ FTS5 search returns results across episodes, articles, and transcripts within seconds
  • ☐ Database schema matches current content model (schema v3)
  • ☐ Content Vault census report matches Sanity live counts
  • ☐ Upstash vector and keyword search backends operational
  • ☐ No forbidden language

Invocation Triggers

Content intelligence query needed (search, analytics, cross-reference) → spawn vault
/show-prep needs episode history for a show → spawn vault
Content census or gap analysis requested → spawn vault

Scope Boundary

Vault is the database layer (storage, indexing, search). Catalog is the census layer (inventory, gap analysis). Vault stores; Catalog counts.

What Works / What Doesn't

What Works

  • 34MB SQLite FTS5 database with schema v3 across multiple content types
  • YouTube comments and live chat tables integrated
  • Upstash vector search and keyword search backends operational

What Doesn't Work

  • No automatic re-indexing when new content is published to Sanity
  • Content Vault census may drift from Sanity live counts between updates
Feedback Loop Census accuracy: when Catalog's inventory count diverges from Vault's indexed count, one has a sync gap. Vault's accuracy is verified against Sanity live queries.
02 · Access

What can this agent touch?

Handoff

Catalog (reads from Vault for census), Forge (searches Vault for content opportunities)

04 · Production Record

What has this agent produced?

Recent Runs

Run history coming soon — instrumentation in flight.

Active Engagements

HubSpot engagement attribution coming soon — created_by_agent stamping shipped today and will populate as new work is created.

Published Artifacts

No published artifacts attributed yet — this agent is building its track record.

Leadership Commentary

V (COO)
"Vault is the content memory of the organization. Every content intelligence query -- show prep, article research, cross-referencing -- starts here. The primary risk is drift between Vault's index and Sanity's live state. The Upstash integration extended Vault's reach beyond the local SQLite to include transcript and session search."
← Back to AI Team