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 60353 in events
seq
Primary key.
INTEGER
id
evt_0d322d840c3d
TEXT NOT NULL
kind
proposal_created
TEXT NOT NULL
ts
2026-04-16T22:23:27.670297+00:00
TEXT NOT NULL
actor
cognition
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-16T22:23:27.670297+00:00","episode_id":"ep_d555d9db5256","event_id":"evt_e7e254aa7c1f","kind":"cognition","model":"gpt-5.4-nano","payload":{"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,"context_ref":{"dedupe_key":"ctx:35e9e6d972af","event_id":"evt_e7e254aa7c1f","kind":"episode_context_built"},"meta":{"episode_id":"ep_d555d9db5256","model":"gpt-5.4-nano","prompt_version":"v9_agentic","response_mode":"action_plan","selected_action_types":["start_agent_run"],"selection_confidence":0.86,"temperature":0.15,"thread_id":"thr_a6a33a03e31885a676","trace_id":"trace:thr_a6a33a03e31885a676:evt_74674b9ae7e4","trigger_event_id":"evt_74674b9ae7e4","turn_id":"turn_evt_74674b9ae7e4","user_text":"1"},"notes":["investigation_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).","reasoning_terminated=finalized"],"proposed_actions":[{"blocking":false,"depends_on":[],"evidence_event_ids":[],"fallback_step_id":null,"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.","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","type":"start_agent_run","workflow_step_id":"step_1"}],"proposed_links":[],"questions":[],"response_mode":"action_plan","summary":"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_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"}]},"prompt_fp":"cognition:v9_agentic","proposal_fp":"cog:ep_d555d9db5256:ctx:35e9e6d972af","proposal_id":"prop_757ff093aecc4480fe633549","rationale":null,"risk":null,"summary":"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."}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
proposal_created:cog:ep_d555d9db5256:ctx:35e9e6d972af
TEXT
episode_id
ep_d555d9db5256
TEXT
created_at
2026-04-16T22:23:34.565442+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel