Vault
Content Intelligence Specialist
Manages the 34MB content intelligence database
“"Content intelligence is only as good as the database behind it. Fast, accurate, comprehensive."”
Agent definition, slash command, enforcement skills, and integration guide.
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.
Current State
An honest assessment of where this agent stands today.
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
Portfolio
Content attributed to this agent in Sanity.
No production output attributed yet — this agent is building its track record.
Leadership Commentary
“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.”
Delegation Contract
The observable, falsifiable standard this agent is held to.
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
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.
Handoff
Catalog (reads from Vault for census), Forge (searches Vault for content opportunities)
Scope Boundary
Vault is the database layer (storage, indexing, search). Catalog is the census layer (inventory, gap analysis). Vault stores; Catalog counts.