SQLite Web: event

thread_id

Primary key. TEXT

last_turn_id

TEXT

last_source_event_id

TEXT

open_loops

TEXT

intents

TEXT

state_blob

{"cognition_state_v1":{"known_slots":[],"last_intent_summary":"User asks for their girlfriend\u2019s name.","last_reasoning_mode":"conversation","notes":["No stored memory/thread context contained the girlfriend\u2019s name."],"recent_tool_calls":[{"at":"2026-04-09T00:01:09.761700+00:00","cached":false,"ok":true,"tool":"search_memory"}],"updated_at":"2026-04-09T00:01:09.761700+00:00"},"followup_pending":{},"intents":["followup","question"],"last_event_kind":"conversation_turn_recorded","last_source_event_id":"evt_d91a32ede467","last_user_text":"do you what's my girlfriend\u2019s name?","open_loop_count":0,"resolver_semantic_capture":{"capture_event_id":"idlecap_dcc862f14e072c17","captured_at":"2026-04-09T00:01:03.963650+00:00","last_capture_mode":"thread_idle","last_idle_source_event_ids":["evt_860b8b588b92"],"last_idle_user_source_event_id":"evt_860b8b588b92","last_idle_user_turn_id":"turn_evt_860b8b588b92","last_inline_capture_event_id":"evt_860b8b588b92","last_inline_source_event_ids":["evt_860b8b588b92"],"last_inline_user_source_event_id":"evt_860b8b588b92","last_user_source_event_id":"evt_860b8b588b92","last_user_turn_id":"turn_evt_860b8b588b92","source_event_ids":["evt_860b8b588b92"]}}

TEXT

salience

REAL (default 0.0

updated_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — conversation_state

Update row thr_c5eddb795f7e33b0c0 in conversation_state