Where data is stored
Video files and information about those videos are stored separately. When investigating a problem, first identify which kind of data you need to inspect.
From video to search data
videos stores the title, owner, file reference, transcript, processing state, and related metadata. The file itself is not stored in a DB row.
scene_embeddings enables semantic search of transcript segments. The API converts questions into numeric search vectors and finds similar scenes within permitted videos.
Questions and answers
Chat records and answer evaluations use separate tables. Returning an answer and completing its evaluation are separate events.
Other storage locations
| Data | Storage or management |
|---|---|
| Browser login state | Better Auth session and browser cookies |
| External API keys saved by users | Encrypted in the database |
| MCP API keys and OAuth | apikey, oauth_*, and related tables |
| Undelivered jobs | external_tasks |
| Worker execution records | job_executions |
| Temporary study mode state | STUDY_SESSION Durable Object |
Related: Data dictionary, ER diagrams, Job delivery and recovery.