`opencode.todos`

pass

All session todo list entries stored in the local OpenCode database. Each row carries the session id, content, status, priority, and ordering position.

List incomplete todos for one session:

no filters captured 2026-09-01 10:16:57Zmedian 6492 ms

Verdict: TRUE

All variants returned rows on ≥2 of 3 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	3	6473 ms	6492 ms	6513 ms	[3, 3, 3]
by-session	3	6470 ms	6488 ms	6507 ms	[9, 9, 9]
filter-status	3	6508 ms	6510 ms	6573 ms	[23, 23, 23]
group-by	3	6470 ms	6486 ms	6507 ms	[4, 4, 4]
aggregate	3	6487 ms	6505 ms	6512 ms	[9, 9, 9]
edge	3	6477 ms	6482 ms	6520 ms	[200, 200, 200]

Latency per trial

minimalmedian 6492ms

scale: 0–6513 ms

by-sessionmedian 6488ms

scale: 0–6507 ms

filter-statusmedian 6510ms

scale: 0–6573 ms

group-bymedian 6486ms

scale: 0–6507 ms

aggregatemedian 6505ms

scale: 0–6512 ms

edgemedian 6482ms

scale: 0–6520 ms

Probe variants — every command + output

minimal3 trials

min 6473ms · median 6492ms · max 6513ms · rows 3,3,3

smallest query

Command

SELECT session_id, content, status, position FROM opencode.todos LIMIT 3

Trials + output

trial 1·6473ms·rows 3isError=false

First row (click to expand JSON)

{
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3",
  "content": "C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))",
  "status": "completed",
  "position": "0"
}

columns (4)

session_idcontentstatusposition

trial 2·6492ms·rows 3isError=false

First row (click to expand JSON)

{
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3",
  "content": "C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))",
  "status": "completed",
  "position": "0"
}

columns (4)

session_idcontentstatusposition

trial 3·6513ms·rows 3isError=false

First row (click to expand JSON)

{
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3",
  "content": "C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))",
  "status": "completed",
  "position": "0"
}

columns (4)

session_idcontentstatusposition

by-session3 trials

min 6470ms · median 6488ms · max 6507ms · rows 9,9,9

todos for one session

Command

SELECT content, status, priority, position FROM opencode.todos WHERE session_id = 'ses_faedde194ffe3SEEUk03dXfiu3' ORDER BY position ASC LIMIT 25

Trials + output

trial 1·6470ms·rows 9isError=false

First row (click to expand JSON)

{
  "content": "Create dedicated opencode probe script (scripts/probe_opencode.py)",
  "status": "completed",
  "priority": "high",
  "position": "0"
}

columns (4)

contentstatuspriorityposition

trial 2·6507ms·rows 9isError=false

First row (click to expand JSON)

{
  "content": "Create dedicated opencode probe script (scripts/probe_opencode.py)",
  "status": "completed",
  "priority": "high",
  "position": "0"
}

columns (4)

contentstatuspriorityposition

trial 3·6488ms·rows 9isError=false

First row (click to expand JSON)

{
  "content": "Create dedicated opencode probe script (scripts/probe_opencode.py)",
  "status": "completed",
  "priority": "high",
  "position": "0"
}

columns (4)

contentstatuspriorityposition

filter-status3 trials

min 6508ms · median 6510ms · max 6573ms · rows 23,23,23

in-progress todos

Command

SELECT content, status FROM opencode.todos WHERE status = 'in_progress' LIMIT 25

Trials + output

trial 1·6510ms·rows 23isError=false

First row (click to expand JSON)

{
  "content": "Enumerate portal /api/* endpoints: unauthorized responses",
  "status": "in_progress"
}

columns (2)

contentstatus

trial 2·6573ms·rows 23isError=false

First row (click to expand JSON)

{
  "content": "Enumerate portal /api/* endpoints: unauthorized responses",
  "status": "in_progress"
}

columns (2)

contentstatus

trial 3·6508ms·rows 23isError=false

First row (click to expand JSON)

{
  "content": "Enumerate portal /api/* endpoints: unauthorized responses",
  "status": "in_progress"
}

columns (2)

contentstatus

group-by3 trials

min 6470ms · median 6486ms · max 6507ms · rows 4,4,4

todo status distribution

Command

SELECT status, COUNT(*) AS n FROM opencode.todos GROUP BY status ORDER BY n DESC

Trials + output

trial 1·6470ms·rows 4isError=false

First row (click to expand JSON)

{
  "status": "completed",
  "n": "331"
}

columns (2)

statusn

trial 2·6507ms·rows 4isError=false

First row (click to expand JSON)

{
  "status": "completed",
  "n": "331"
}

columns (2)

statusn

trial 3·6486ms·rows 4isError=false

First row (click to expand JSON)

{
  "status": "completed",
  "n": "331"
}

columns (2)

statusn

aggregate3 trials

min 6487ms · median 6505ms · max 6512ms · rows 9,9,9

todo distribution by status + priority

Command

SELECT status, priority, COUNT(*) AS n FROM opencode.todos GROUP BY status, priority ORDER BY n DESC

Trials + output

trial 1·6512ms·rows 9isError=false

First row (click to expand JSON)

{
  "status": "completed",
  "priority": "high",
  "n": "255"
}

columns (3)

statuspriorityn

trial 2·6505ms·rows 9isError=false

First row (click to expand JSON)

{
  "status": "completed",
  "priority": "high",
  "n": "255"
}

columns (3)

statuspriorityn

trial 3·6487ms·rows 9isError=false

First row (click to expand JSON)

{
  "status": "completed",
  "priority": "high",
  "n": "255"
}

columns (3)

statuspriorityn

edge3 trials

min 6477ms · median 6482ms · max 6520ms · rows 200,200,200

edge: larger limit

Command

SELECT content, status FROM opencode.todos LIMIT 200

Trials + output

trial 1·6482ms·rows 200isError=false

First row (click to expand JSON)

{
  "content": "C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))",
  "status": "completed"
}

columns (2)

contentstatus

trial 2·6477ms·rows 200isError=false

First row (click to expand JSON)

{
  "content": "C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))",
  "status": "completed"
}

columns (2)

contentstatus

trial 3·6520ms·rows 200isError=false

First row (click to expand JSON)

{
  "content": "C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))",
  "status": "completed"
}

columns (2)

contentstatus

All returned rowsacross all non-errored trials · filterable · paginated

392 rows stored · 992 returned · 4 truncated · page 1/16


0	0	ses_000c159f2ffeOoNzxoUMIfpfD3	C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))	completed	0	—	—
0	1	ses_000c159f2ffeOoNzxoUMIfpfD3	C2: Fix InlineConversationHint lying — text says 'appears below' but modal opens	completed	1	—	—
0	2	ses_000c159f2ffeOoNzxoUMIfpfD3	C3: Fix HeatmapSection period subtitle using capped recentSessions instead of f…	completed	2	—	—
1	3	ses_000c159f2ffeOoNzxoUMIfpfD3	C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))	completed	0	—	—
1	4	ses_000c159f2ffeOoNzxoUMIfpfD3	C2: Fix InlineConversationHint lying — text says 'appears below' but modal opens	completed	1	—	—
1	5	ses_000c159f2ffeOoNzxoUMIfpfD3	C3: Fix HeatmapSection period subtitle using capped recentSessions instead of f…	completed	2	—	—
2	6	ses_000c159f2ffeOoNzxoUMIfpfD3	C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))	completed	0	—	—
2	7	ses_000c159f2ffeOoNzxoUMIfpfD3	C2: Fix InlineConversationHint lying — text says 'appears below' but modal opens	completed	1	—	—
2	8	ses_000c159f2ffeOoNzxoUMIfpfD3	C3: Fix HeatmapSection period subtitle using capped recentSessions instead of f…	completed	2	—	—
3	9	ses_000c159f2ffeOoNzxoUMIfpfD3	C1: Fix broken Show-first-20 toggle (line 639 calls setShowAllSessions(true))	completed	0	—	—
3	10	ses_000c159f2ffeOoNzxoUMIfpfD3	C2: Fix InlineConversationHint lying — text says 'appears below' but modal opens	completed	1	—	—
3	11	ses_000c159f2ffeOoNzxoUMIfpfD3	C3: Fix HeatmapSection period subtitle using capped recentSessions instead of f…	completed	2	—	—
0	12	—	Create dedicated opencode probe script (scripts/probe_opencode.py)	completed	0	high	—
0	13	—	Probe all 10 opencode tables with real-value filters/JSON/ORDER-BY/aggregates	completed	1	high	—
0	14	—	Fix session_messages probe filter (real session_id) → verified True	completed	2	high	—
0	15	—	Generate opencode snapshots.json via snapshot.py	completed	3	high	—
0	16	—	Generate opencode summary.json via aggregate_summary.py	completed	4	high	—
0	17	—	Build static site at app/out/ (npm run build)	in_progress	5	high	—
0	18	—	Verify opencode renders on /sources/opencode and cross-source /timeline	pending	6	high	—
0	19	—	Serve the static site and report to user	pending	7	medium	—
0	20	—	Commit intended changes to probe/github-reprobe-tooling branch; end coral task …	pending	8	medium	—
1	21	—	Create dedicated opencode probe script (scripts/probe_opencode.py)	completed	0	high	—
1	22	—	Probe all 10 opencode tables with real-value filters/JSON/ORDER-BY/aggregates	completed	1	high	—
1	23	—	Fix session_messages probe filter (real session_id) → verified True	completed	2	high	—
1	24	—	Generate opencode snapshots.json via snapshot.py	completed	3	high	—

Truncated. 4 trials returned more rows than we stored (safety cap = 200/trial). Increase theMAX_ROWS_RETURNED inscripts/probe_table.py and re-probe to capture more.

Column profile

4 columns actually returned by coral. Catalog claims no required filters. Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	session_id	string	4	20	`"ses_000c159f2ffeOoNzxoUMIfpfD3"`
2	content	string	16	8	`"C1: Fix broken Show-first-20 toggle (line 639 calls setShowA""Create dedicated opencode probe script (scripts/probe_openco""Enumerate portal /api/* endpoints: unauthorized responses"`
3	status	string	24	0	`"completed""in_progress"`
4	position	string	8	16	`"0"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6473ms	3	ok	session_id, content, status
minimal	t2	6492ms	3	ok	session_id, content, status
minimal	t3	6513ms	3	ok	session_id, content, status
by-session	t1	6470ms	9	ok	content, status, priority
by-session	t2	6507ms	9	ok	content, status, priority
by-session	t3	6488ms	9	ok	content, status, priority
filter-status	t1	6510ms	23	ok	content, status
filter-status	t2	6573ms	23	ok	content, status
filter-status	t3	6508ms	23	ok	content, status
group-by	t1	6470ms	4	ok	status, n
group-by	t2	6507ms	4	ok	status, n
group-by	t3	6486ms	4	ok	status, n
aggregate	t1	6512ms	9	ok	status, priority, n
aggregate	t2	6505ms	9	ok	status, priority, n
aggregate	t3	6487ms	9	ok	status, priority, n
edge	t1	6482ms	200	ok	content, status
edge	t2	6477ms	200	ok	content, status
edge	t3	6520ms	200	ok	content, status

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

List incomplete todos for one session:

Columns coral returned (4)

session_idcontentstatusposition

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T10:16:57Z

JSON record: reports/opencode/tables/todos.json

first_run_at: 2026-09-01T09:01:30Z

last_retried_at: 2026-09-01T10:16:57Z

retry_count: 2

View version history →