`opencode.migrations`

pass

Applied schema migrations recorded by opencode, with the timestamp each completed at.

SELECT id, time_completed

no filters captured 2026-09-01 12:16:26Zmedian 14724 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	9036 ms	14724 ms	16068 ms	[1, 1, 1]
order	3	9856 ms	11022 ms	12777 ms	[25, 25, 25]
aggregate	3	6491 ms	7228 ms	11501 ms	[1, 1, 1]

Latency per trial

minimalmedian 14724ms

scale: 0–16068 ms

ordermedian 11022ms

scale: 0–12777 ms

aggregatemedian 7228ms

scale: 0–11501 ms

Probe variants — every command + output

minimal3 trials

min 9036ms · median 14724ms · max 16068ms · rows 1,1,1

smallest query

Command

SELECT id, time_completed FROM opencode.migrations LIMIT 1

Trials + output

trial 1·9036ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "20260127222353_familiar_lady_ursula",
  "time_completed": "1782151644434"
}

columns (2)

idtime_completed

trial 2·14724ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "20260127222353_familiar_lady_ursula",
  "time_completed": "1782151644434"
}

columns (2)

idtime_completed

trial 3·16068ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "20260127222353_familiar_lady_ursula",
  "time_completed": "1782151644434"
}

columns (2)

idtime_completed

order3 trials

min 9856ms · median 11022ms · max 12777ms · rows 25,25,25

migrations in completion order

Command

SELECT id, time_completed FROM opencode.migrations ORDER BY time_completed ASC LIMIT 25

Trials + output

trial 1·12777ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "20260225215848_workspace",
  "time_completed": "1782151644434"
}

columns (2)

idtime_completed

trial 2·9856ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "20260225215848_workspace",
  "time_completed": "1782151644434"
}

columns (2)

idtime_completed

trial 3·11022ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "20260225215848_workspace",
  "time_completed": "1782151644434"
}

columns (2)

idtime_completed

aggregate3 trials

min 6491ms · median 7228ms · max 11501ms · rows 1,1,1

migration totals

Command

SELECT COUNT(*) AS n, MAX(time_completed) AS latest FROM opencode.migrations

Trials + output

trial 1·11501ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "38",
  "latest": "1782493950018"
}

columns (2)

nlatest

trial 2·7228ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "38",
  "latest": "1782493950018"
}

columns (2)

nlatest

trial 3·6491ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "38",
  "latest": "1782493950018"
}

columns (2)

nlatest

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

108 rows stored · 108 returned · page 1/5


0	0	20260127222353_familiar_lady_ursula	1782151644434	—	—
1	1	20260127222353_familiar_lady_ursula	1782151644434	—	—
2	2	20260127222353_familiar_lady_ursula	1782151644434	—	—
3	3	20260127222353_familiar_lady_ursula	1782151644434	—	—
0	4	20260225215848_workspace	1782151644434	—	—
0	5	20260227213759_add_session_workspace_id	1782151644434	—	—
0	6	20260211171708_add_project_commands	1782151644434	—	—
0	7	20260127222353_familiar_lady_ursula	1782151644434	—	—
0	8	20260228203230_blue_harpoon	1782151644434	—	—
0	9	20260213144116_wakeful_the_professor	1782151644434	—	—
0	10	20260303231226_add_workspace_fields	1782151644434	—	—
0	11	20260312043431_session_message_cursor	1782151644435	—	—
0	12	20260309230000_move_org_to_state	1782151644435	—	—
0	13	20260410174513_workspace-name	1782151644435	—	—
0	14	20260413175956_chief_energizer	1782151644435	—	—
0	15	20260323234822_events	1782151644435	—	—
0	16	20260507164347_add_workspace_time	1782151644436	—	—
0	17	20260504145000_add_sync_owner	1782151644436	—	—
0	18	20260511173437_session-metadata	1782151644436	—	—
0	19	20260601010001_normalize_storage_paths	1782151644436	—	—
0	20	20260511000411_data_migration_state	1782151644436	—	—
0	21	20260510033149_session_usage	1782151644436	—	—
0	22	20260501142318_next_venus	1782151644436	—	—
0	23	20260602182828_add_project_directories	1782151644436	—	—
0	24	20260602002951_lowly_union_jack	1782151644436	—	—

Column profile

2 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	8	4	`"20260127222353_familiar_lady_ursula""20260225215848_workspace"`
2	time_completed	string	8	4	`"1782151644434"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	9036ms	1	ok	id, time_completed
minimal	t2	14724ms	1	ok	id, time_completed
minimal	t3	16068ms	1	ok	id, time_completed
order	t1	12777ms	25	ok	id, time_completed
order	t2	9856ms	25	ok	id, time_completed
order	t3	11022ms	25	ok	id, time_completed
aggregate	t1	11501ms	1	ok	n, latest
aggregate	t2	7228ms	1	ok	n, latest
aggregate	t3	6491ms	1	ok	n, latest

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

SELECT id, time_completed

Columns coral returned (2)

idtime_completed

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T12:16:26Z

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

first_run_at: 2026-09-01T12:16:26Z

last_retried_at: 2026-09-01T12:16:26Z

retry_count: 1

View version history →