`opencode.messages`

pass

All messages stored in the local OpenCode database, in session order. Each row exposes the message id, parent session, timestamps, and the full message payload as a JSON column.

Run the converter first to populate the JSONL files:

no filters captured 2026-09-01 11:48:10Zmedian 12734 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	11304 ms	12734 ms	12941 ms	[1, 1, 1]
by-session	3	8024 ms	11063 ms	12905 ms	[25, 25, 25]
json-extract	3	12081 ms	12380 ms	13434 ms	[25, 25, 25]
group-by	3	12984 ms	13412 ms	18056 ms	[2, 2, 2]
aggregate	3	9182 ms	9731 ms	26607 ms	[1, 1, 1]
edge	3	8221 ms	8476 ms	8561 ms	[200, 200, 200]

Latency per trial

minimalmedian 12734ms

scale: 0–12941 ms

by-sessionmedian 11063ms

scale: 0–12905 ms

json-extractmedian 12380ms

scale: 0–13434 ms

group-bymedian 13412ms

scale: 0–18056 ms

aggregatemedian 9731ms

scale: 0–26607 ms

edgemedian 8476ms

scale: 0–8561 ms

Probe variants — every command + output

minimal3 trials

min 11304ms · median 12734ms · max 12941ms · rows 1,1,1

smallest query

Command

SELECT id, session_id, time_created FROM opencode.messages LIMIT 1

Trials + output

trial 1·12941ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_056853cf0002jholAyxAYx9ywh",
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3",
  "time_created": "1788157967600"
}

columns (3)

idsession_idtime_created

trial 2·11304ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_056853cf0002jholAyxAYx9ywh",
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3",
  "time_created": "1788157967600"
}

columns (3)

idsession_idtime_created

trial 3·12734ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_056853cf0002jholAyxAYx9ywh",
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3",
  "time_created": "1788157967600"
}

columns (3)

idsession_idtime_created

by-session3 trials

min 8024ms · median 11063ms · max 12905ms · rows 25,25,25

messages for one session

Command

SELECT id, session_id, time_created FROM opencode.messages WHERE session_id = 'ses_faedde194ffe3SEEUk03dXfiu3' ORDER BY time_created ASC LIMIT 25

Trials + output

trial 1·12905ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "msg_051221e82001HhQEz330rxiFFR",
  "session_id": "ses_faedde194ffe3SEEUk03dXfiu3",
  "time_created": "1788067585666"
}

columns (3)

idsession_idtime_created

trial 2·11063ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "msg_051221e82001HhQEz330rxiFFR",
  "session_id": "ses_faedde194ffe3SEEUk03dXfiu3",
  "time_created": "1788067585666"
}

columns (3)

idsession_idtime_created

trial 3·8024ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "msg_051221e82001HhQEz330rxiFFR",
  "session_id": "ses_faedde194ffe3SEEUk03dXfiu3",
  "time_created": "1788067585666"
}

columns (3)

idsession_idtime_created

json-extract3 trials

min 12081ms · median 12380ms · max 13434ms · rows 25,25,25

extract role from JSON payload

Command

SELECT id, json_as_text(data, 'role') AS role FROM opencode.messages WHERE session_id = 'ses_faedde194ffe3SEEUk03dXfiu3' ORDER BY time_created ASC LIMIT 25

Trials + output

trial 1·13434ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "msg_051221e82001HhQEz330rxiFFR",
  "role": "user"
}

columns (2)

idrole

trial 2·12380ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "msg_051221e82001HhQEz330rxiFFR",
  "role": "user"
}

columns (2)

idrole

trial 3·12081ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "msg_051221e82001HhQEz330rxiFFR",
  "role": "user"
}

columns (2)

idrole

group-by3 trials

min 12984ms · median 13412ms · max 18056ms · rows 2,2,2

messages by role

Command

SELECT json_as_text(data, 'role') AS role, COUNT(*) AS n FROM opencode.messages GROUP BY 1 ORDER BY n DESC LIMIT 10

Trials + output

trial 1·13412ms·rows 2isError=false

First row (click to expand JSON)

{
  "role": "assistant",
  "n": "63007"
}

columns (2)

rolen

trial 2·12984ms·rows 2isError=false

First row (click to expand JSON)

{
  "role": "assistant",
  "n": "63007"
}

columns (2)

rolen

trial 3·18056ms·rows 2isError=false

First row (click to expand JSON)

{
  "role": "assistant",
  "n": "63007"
}

columns (2)

rolen

aggregate3 trials

min 9182ms · median 9731ms · max 26607ms · rows 1,1,1

total message volume

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT session_id) AS sessions FROM opencode.messages

Trials + output

trial 1·26607ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "68331",
  "sessions": "465"
}

columns (2)

nsessions

trial 2·9182ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "68331",
  "sessions": "465"
}

columns (2)

nsessions

trial 3·9731ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "68331",
  "sessions": "465"
}

columns (2)

nsessions

edge3 trials

min 8221ms · median 8476ms · max 8561ms · rows 200,200,200

edge: larger limit

Command

SELECT id, session_id FROM opencode.messages LIMIT 200

Trials + output

trial 1·8221ms·rows 200isError=false

First row (click to expand JSON)

{
  "id": "msg_056853cf0002jholAyxAYx9ywh",
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3"
}

columns (2)

idsession_id

trial 2·8476ms·rows 200isError=false

First row (click to expand JSON)

{
  "id": "msg_056853cf0002jholAyxAYx9ywh",
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3"
}

columns (2)

idsession_id

trial 3·8561ms·rows 200isError=false

First row (click to expand JSON)

{
  "id": "msg_056853cf0002jholAyxAYx9ywh",
  "session_id": "ses_000c159f2ffeOoNzxoUMIfpfD3"
}

columns (2)

idsession_id

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

416 rows stored · 1016 returned · 4 truncated · page 1/17


0	0	msg_056853cf0002jholAyxAYx9ywh	ses_000c159f2ffeOoNzxoUMIfpfD3	1788157967600	—	—	—
1	1	msg_056853cf0002jholAyxAYx9ywh	ses_000c159f2ffeOoNzxoUMIfpfD3	1788157967600	—	—	—
2	2	msg_056853cf0002jholAyxAYx9ywh	ses_000c159f2ffeOoNzxoUMIfpfD3	1788157967600	—	—	—
3	3	msg_056853cf0002jholAyxAYx9ywh	ses_000c159f2ffeOoNzxoUMIfpfD3	1788157967600	—	—	—
0	4	msg_051221e82001HhQEz330rxiFFR	ses_faedde194ffe3SEEUk03dXfiu3	1788067585666	—	—	—
0	5	msg_051221e96001T13GD87z7HDJr2	ses_faedde194ffe3SEEUk03dXfiu3	1788067585686	—	—	—
0	6	msg_05122516d001EMycw3FbKUG8IU	ses_faedde194ffe3SEEUk03dXfiu3	1788067598701	—	—	—
0	7	msg_0512266d40011GlDjmc8YK3FCP	ses_faedde194ffe3SEEUk03dXfiu3	1788067604180	—	—	—
0	8	msg_0512277ed001X28iWE4K1lZUnM	ses_faedde194ffe3SEEUk03dXfiu3	1788067608557	—	—	—
0	9	msg_051228bd4001yXmpnFGAbgSsVk	ses_faedde194ffe3SEEUk03dXfiu3	1788067613652	—	—	—
0	10	msg_051229aab001l5AXKfM1RYesVj	ses_faedde194ffe3SEEUk03dXfiu3	1788067617451	—	—	—
0	11	msg_05122bced001nMkjl9MtA0uovq	ses_faedde194ffe3SEEUk03dXfiu3	1788067626221	—	—	—
0	12	msg_05122d4c100118jEC7Is6h83Ho	ses_faedde194ffe3SEEUk03dXfiu3	1788067632321	—	—	—
0	13	msg_051236ca2001E1w4um2BZE33fd	ses_faedde194ffe3SEEUk03dXfiu3	1788067671202	—	—	—
0	14	msg_05123b4dc001D0WRcrgzdL48EV	ses_faedde194ffe3SEEUk03dXfiu3	1788067689692	—	—	—
0	15	msg_05123e8bb0014TsGdsWAqnshJz	ses_faedde194ffe3SEEUk03dXfiu3	1788067702971	—	—	—
0	16	msg_051242fac001voFb6nirWIm4VY	ses_faedde194ffe3SEEUk03dXfiu3	1788067721132	—	—	—
0	17	msg_051247973001NPhm7JzMLtwKp2	ses_faedde194ffe3SEEUk03dXfiu3	1788067740019	—	—	—
0	18	msg_05124c361001CjdiZwiU2PjjzK	ses_faedde194ffe3SEEUk03dXfiu3	1788067758945	—	—	—
0	19	msg_05124d933001CYjn9qLg0MjBvd	ses_faedde194ffe3SEEUk03dXfiu3	1788067764531	—	—	—
0	20	msg_05124e5a00011ztajUjzxE1Vjl	ses_faedde194ffe3SEEUk03dXfiu3	1788067767712	—	—	—
0	21	msg_051250df0001HuG014U44Iqtm1	ses_faedde194ffe3SEEUk03dXfiu3	1788067778032	—	—	—
0	22	msg_051254875001Ph6au4bMEOiFT8	ses_faedde194ffe3SEEUk03dXfiu3	1788067793013	—	—	—
0	23	msg_051257ec4001jAomb84uHY542A	ses_faedde194ffe3SEEUk03dXfiu3	1788067806916	—	—	—
0	24	msg_051259206001GN0BjxfXBlzkk5	ses_faedde194ffe3SEEUk03dXfiu3	1788067811846	—	—	—

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

3 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	id	string	16	8	`"msg_056853cf0002jholAyxAYx9ywh""msg_051221e82001HhQEz330rxiFFR"`
2	session_id	string	12	12	`"ses_000c159f2ffeOoNzxoUMIfpfD3""ses_faedde194ffe3SEEUk03dXfiu3"`
3	time_created	string	8	16	`"1788157967600""1788067585666"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	12941ms	1	ok	id, session_id, time_created
minimal	t2	11304ms	1	ok	id, session_id, time_created
minimal	t3	12734ms	1	ok	id, session_id, time_created
by-session	t1	12905ms	25	ok	id, session_id, time_created
by-session	t2	11063ms	25	ok	id, session_id, time_created
by-session	t3	8024ms	25	ok	id, session_id, time_created
json-extract	t1	13434ms	25	ok	id, role
json-extract	t2	12380ms	25	ok	id, role
json-extract	t3	12081ms	25	ok	id, role
group-by	t1	13412ms	2	ok	role, n
group-by	t2	12984ms	2	ok	role, n
group-by	t3	18056ms	2	ok	role, n
aggregate	t1	26607ms	1	ok	n, sessions
aggregate	t2	9182ms	1	ok	n, sessions
aggregate	t3	9731ms	1	ok	n, sessions
edge	t1	8221ms	200	ok	id, session_id
edge	t2	8476ms	200	ok	id, session_id
edge	t3	8561ms	200	ok	id, session_id

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Run the converter first to populate the JSONL files:

Columns coral returned (3)

idsession_idtime_created

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T11:48:10Z

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

first_run_at: 2026-09-01T08:41:08Z

last_retried_at: 2026-09-01T11:48:10Z

retry_count: 3

View version history →