Live analytics
User Context
Rolling summaries, key facts, mood patterns and summary freshness.
Table metadata
Rows: 5Page: 1 / 1Page size: 100Mode: read-write
Columns
| name | type | primary_key | not_null | default_value |
|---|---|---|---|---|
| id | TEXT | 1 | 0 | — |
| user_id | TEXT | 0 | 1 | — |
| summary | TEXT | 0 | 1 | '' |
| key_facts | TEXT | 0 | 1 | '[]' |
| mood_pattern | TEXT | 0 | 1 | '' |
| messages_since_update | INTEGER | 0 | 1 | 0 |
| updated_at | TEXT | 0 | 0 | datetime('now') |
Rows
Manage rows
Create, edit, and delete live rows directly from the SQLite database.
| __rowid__ | id | user_id | summary | key_facts | mood_pattern | messages_since_update | updated_at | Actions |
|---|---|---|---|---|---|---|---|---|
| 8 | 72747408-8384-429e-a4e0-7b512b6b9a96 | 965ca4fb-4144-4b05-b438-36e38d3ca019 | — | [] | — | 1 | 2026-04-18 20:22:51 | |
| 7 | ddc99920-082b-47fe-a16c-73f54d075bc6 | 44621a1c-e86d-4db9-bc6d-dcc6e135b6a1 | — | [] | — | 9 | 2026-04-14 06:47:53 | |
| 6 | dac2ea04-2a79-420a-ba7a-cffd1b0e7e4f | 9b16341f-5923-4110-af9e-996e5d859748 | — | [] | — | 1 | 2026-04-10 12:05:08 | |
| 5 | 592db5f7-3c95-4791-948b-2cdafd3f6c53 | 2cc17424-c6f7-471e-861f-443267285a6c | — | [] | — | 20 | 2026-04-09 04:53:20 | |
| 3 | 0b0b2aa8-e1ed-4485-bda7-2371fc7ef0df | 0853414f-c5bc-4260-ba19-b60991c6232f | — | [] | — | 3 | 2026-04-04 17:43:21 |