Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_memory
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 60352 in events
seq
Primary key.
INTEGER
id
evt_880dbc16ccdc
TEXT NOT NULL
kind
cognition_proposal
TEXT NOT NULL
ts
2026-04-16T22:23:27.670297+00:00
TEXT NOT NULL
actor
cognition
TEXT
subject_entity_ids
[]
TEXT
payload
{"context_ref":{"dedupe_key":"ctx:35e9e6d972af","event_id":"evt_e7e254aa7c1f","kind":"episode_context_built"},"episode_id":"ep_d555d9db5256","model":"gpt-5.4-nano","prompt_version":"v9_agentic","proposal":{"assistant_reply":"Perfect\u2014I'll run `opia_query` for the rolling last 7\u00d724 hours (America/New_York) and summarize all agent runs/actions from that window.","confidence":0.86,"response_mode":"action_plan","workflow_goal":"Execute the missing internal step: query the DB for the user\u2019s action history for the specified rolling 7-day window, then summarize it.","workflow_steps":[{"action_type":"start_agent_run","blocking":false,"depends_on":[],"followup":null,"params":{"brief":{"context_summary":"User wants a summary list of all their actions executed in the last 7 days, using `opia_query` to pull from the DB. They selected option 1 (rolling back 7\u00d724 hours from now). Prior conversation indicates the relevant action category is `agent_runs` (user said 'agent_runs' and then 'all actions' earlier).","delivery_instructions":"Deliver to the user a concise summary list of all agent runs/actions found in the last 7\u00d724 hours window (America/New_York), including timestamps and any key identifiers/details available.","user_identity":null,"user_request":"1"},"budget_seconds":600,"goal":"Pull the user\u2019s action history from the DB for the rolling last 7\u00d724 hours (America/New_York) and summarize all agent runs/actions in that window.","max_outer_steps":8,"rationale":"An agent run is needed to execute the DB query via `opia_query` and compile a readable summary from the results."},"rationale":"Use start_agent_run to perform the DB query and summarization over multiple tool calls.","step_id":"step_1","success_criteria":"The agent returns a list of all matching agent runs/actions within the last 7\u00d724 hours (America/New_York), summarized for the user.","tier":"T2"}]},"reasoning_trace":{"steps":[{"decision":"finalize","finalize_reason":"Need the actual user intent/question to proceed. Please provide what you want to understand or decide next.","iteration":1,"missing_facts":[],"reasoning":"No actionable user request or missing-fact question is present yet. The provided user_text is just \"1\" and there is no objective beyond setting up an investigation session.","tool_name":""}],"terminated_reason":"finalized","tool_calls":[]},"selection":{"confidence":0.86,"intent_summary":"User wants a summary list of all their actions executed in the last 7 days, using `opia_query` to pull from the DB. They selected option 1 (rolling back 7\u00d724 hours from now).","needs_action":true,"reasoning_brief":"No actionable user request or missing-fact question is present yet. The provided user_text is just \"1\" and there is no objective beyond setting up an investigation session.","response_mode":"action_plan","selected_action_types":["start_agent_run"]},"temperature":0.15,"thread_id":"thr_a6a33a03e31885a676","trigger_event_id":"evt_74674b9ae7e4","turn_id":"turn_evt_74674b9ae7e4","user_text":"1"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
cognition_proposal:prop_757ff093aecc4480fe633549
TEXT
episode_id
ep_d555d9db5256
TEXT
created_at
2026-04-16T22:23:34.558138+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel