`opencode.projects`

pass

All projects stored in the local OpenCode database. Each row carries the project id, worktree, display name, and timestamps.

SELECT id, worktree, name, time_created

no filters captured 2026-09-01 10:06:04Zmedian 10863 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	10015 ms	10863 ms	23475 ms	[3, 3, 3]
order	3	7407 ms	12459 ms	17349 ms	[22, 22, 22]
filter-vcs	3	12424 ms	12894 ms	12901 ms	[21, 21, 21]
filter-by-id	3	8080 ms	8240 ms	8346 ms	[1, 1, 1]
aggregate	3	6427 ms	6473 ms	6597 ms	[2, 2, 2]

Latency per trial

minimalmedian 10863ms

scale: 0–23475 ms

ordermedian 12459ms

scale: 0–17349 ms

filter-vcsmedian 12894ms

scale: 0–12901 ms

filter-by-idmedian 8240ms

scale: 0–8346 ms

aggregatemedian 6473ms

scale: 0–6597 ms

Probe variants — every command + output

minimal3 trials

min 10015ms · median 10863ms · max 23475ms · rows 3,3,3

smallest query

Command

SELECT id, worktree, name, vcs FROM opencode.projects LIMIT 3

Trials + output

trial 1·10863ms·rows 3isError=false

First row (click to expand JSON)

{
  "id": "f7ea95ab6d38fe9ae91fe204fd29d0f24449c712",
  "worktree": "/Users/viclkykumar/video-editor",
  "name": "",
  "vcs": "git"
}

columns (4)

idworktreenamevcs

trial 2·10015ms·rows 3isError=false

First row (click to expand JSON)

{
  "id": "f7ea95ab6d38fe9ae91fe204fd29d0f24449c712",
  "worktree": "/Users/viclkykumar/video-editor",
  "name": "",
  "vcs": "git"
}

columns (4)

idworktreenamevcs

trial 3·23475ms·rows 3isError=false

First row (click to expand JSON)

{
  "id": "f7ea95ab6d38fe9ae91fe204fd29d0f24449c712",
  "worktree": "/Users/viclkykumar/video-editor",
  "name": "",
  "vcs": "git"
}

columns (4)

idworktreenamevcs

order3 trials

min 7407ms · median 12459ms · max 17349ms · rows 22,22,22

recent projects

Command

SELECT id, worktree, vcs, time_created FROM opencode.projects ORDER BY time_updated DESC LIMIT 25

Trials + output

trial 1·17349ms·rows 22isError=false

First row (click to expand JSON)

{
  "id": "846982133a6c33303221dbc166c0a89074f184ac",
  "worktree": "/Users/viclkykumar/Downloads/coral-repo",
  "vcs": "git",
  "time_created": "1785310987900"
}

columns (4)

idworktreevcstime_created

trial 2·7407ms·rows 22isError=false

First row (click to expand JSON)

{
  "id": "846982133a6c33303221dbc166c0a89074f184ac",
  "worktree": "/Users/viclkykumar/Downloads/coral-repo",
  "vcs": "git",
  "time_created": "1785310987900"
}

columns (4)

idworktreevcstime_created

trial 3·12459ms·rows 22isError=false

First row (click to expand JSON)

{
  "id": "846982133a6c33303221dbc166c0a89074f184ac",
  "worktree": "/Users/viclkykumar/Downloads/coral-repo",
  "vcs": "git",
  "time_created": "1785310987900"
}

columns (4)

idworktreevcstime_created

filter-vcs3 trials

min 12424ms · median 12894ms · max 12901ms · rows 21,21,21

git projects

Command

SELECT id, worktree, vcs FROM opencode.projects WHERE vcs = 'git' LIMIT 25

Trials + output

trial 1·12424ms·rows 21isError=false

First row (click to expand JSON)

{
  "id": "f7ea95ab6d38fe9ae91fe204fd29d0f24449c712",
  "worktree": "/Users/viclkykumar/video-editor",
  "vcs": "git"
}

columns (3)

idworktreevcs

trial 2·12894ms·rows 21isError=false

First row (click to expand JSON)

{
  "id": "f7ea95ab6d38fe9ae91fe204fd29d0f24449c712",
  "worktree": "/Users/viclkykumar/video-editor",
  "vcs": "git"
}

columns (3)

idworktreevcs

trial 3·12901ms·rows 21isError=false

First row (click to expand JSON)

{
  "id": "f7ea95ab6d38fe9ae91fe204fd29d0f24449c712",
  "worktree": "/Users/viclkykumar/video-editor",
  "vcs": "git"
}

columns (3)

idworktreevcs

filter-by-id3 trials

min 8080ms · median 8240ms · max 8346ms · rows 1,1,1

one known project

Command

SELECT id, worktree, vcs, time_initialized FROM opencode.projects WHERE id = '846982133a6c33303221dbc166c0a89074f184ac' LIMIT 5

Trials + output

trial 1·8240ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "846982133a6c33303221dbc166c0a89074f184ac",
  "worktree": "/Users/viclkykumar/Downloads/coral-repo",
  "vcs": "git",
  "time_initialized": ""
}

columns (4)

idworktreevcstime_initialized

trial 2·8080ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "846982133a6c33303221dbc166c0a89074f184ac",
  "worktree": "/Users/viclkykumar/Downloads/coral-repo",
  "vcs": "git",
  "time_initialized": ""
}

columns (4)

idworktreevcstime_initialized

trial 3·8346ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "846982133a6c33303221dbc166c0a89074f184ac",
  "worktree": "/Users/viclkykumar/Downloads/coral-repo",
  "vcs": "git",
  "time_initialized": ""
}

columns (4)

idworktreevcstime_initialized

aggregate3 trials

min 6427ms · median 6473ms · max 6597ms · rows 2,2,2

projects by VCS

Command

SELECT vcs, COUNT(*) AS n FROM opencode.projects GROUP BY vcs

Trials + output

trial 1·6473ms·rows 2isError=false

First row (click to expand JSON)

{
  "vcs": "git",
  "n": "21"
}

columns (2)

vcsn

trial 2·6597ms·rows 2isError=false

First row (click to expand JSON)

{
  "vcs": "git",
  "n": "21"
}

columns (2)

vcsn

trial 3·6427ms·rows 2isError=false

First row (click to expand JSON)

{
  "vcs": "git",
  "n": "21"
}

columns (2)

vcsn

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

196 rows stored · 196 returned · page 1/8


0	0	f7ea95ab6d38fe9ae91fe204fd29d0f24449c712	/Users/viclkykumar/video-editor	—	git	—	—	—
0	1	9af71c0ffa1f9c4c21c344c9e0af22214bf3f6da	/Users/viclkykumar/code/coral-mcp-benchmark	—	git	—	—	—
0	2	9b3059ea2dec3bf3ac99f38438fe21be27c5e5c1	/Users/viclkykumar/projects/telegram	—	git	—	—	—
1	3	f7ea95ab6d38fe9ae91fe204fd29d0f24449c712	/Users/viclkykumar/video-editor	—	git	—	—	—
1	4	9af71c0ffa1f9c4c21c344c9e0af22214bf3f6da	/Users/viclkykumar/code/coral-mcp-benchmark	—	git	—	—	—
1	5	9b3059ea2dec3bf3ac99f38438fe21be27c5e5c1	/Users/viclkykumar/projects/telegram	—	git	—	—	—
2	6	f7ea95ab6d38fe9ae91fe204fd29d0f24449c712	/Users/viclkykumar/video-editor	—	git	—	—	—
2	7	9af71c0ffa1f9c4c21c344c9e0af22214bf3f6da	/Users/viclkykumar/code/coral-mcp-benchmark	—	git	—	—	—
2	8	9b3059ea2dec3bf3ac99f38438fe21be27c5e5c1	/Users/viclkykumar/projects/telegram	—	git	—	—	—
3	9	f7ea95ab6d38fe9ae91fe204fd29d0f24449c712	/Users/viclkykumar/video-editor	—	git	—	—	—
3	10	9af71c0ffa1f9c4c21c344c9e0af22214bf3f6da	/Users/viclkykumar/code/coral-mcp-benchmark	—	git	—	—	—
3	11	9b3059ea2dec3bf3ac99f38438fe21be27c5e5c1	/Users/viclkykumar/projects/telegram	—	git	—	—	—
0	12	846982133a6c33303221dbc166c0a89074f184ac	/Users/viclkykumar/Downloads/coral-repo	—	git	1785310987900	—	—
0	13	d3ca44b6e235b09221e596aab300e4d3e14d2d3d	/Users/viclkykumar/ghevra-full	—	git	1787317560819	—	—
0	14	global	/	—	—	1782151644718	—	—
0	15	f7ea95ab6d38fe9ae91fe204fd29d0f24449c712	/Users/viclkykumar/video-editor	—	git	1788181363002	—	—
0	16	5759b405b4fd9a9ef17a284a3054a469355d9399	/Users/viclkykumar/stock_agent	—	git	1787767505723	—	—
0	17	73a435a36102df2dbfeb97d1fd9bd22e4af2429d	/Users/viclkykumar/agentic-dashboard-sandbox	—	git	1786517431727	—	—
0	18	908812f142d3f0237f9a0449e93a5c5e28e4f876	/Volumes/algsoch/terminal 3	—	git	1782728857952	—	—
0	19	cee5eaf48cc5fcefa539fceb90f04e9a97a23f1e	/Users/viclkykumar/razorpay	—	git	1787383028583	—	—
0	20	9af71c0ffa1f9c4c21c344c9e0af22214bf3f6da	/Users/viclkykumar/code/coral-mcp-benchmark	—	git	1788031580634	—	—
0	21	54d568696de63f9f1c1fd380aaea32702da92491	/Users/viclkykumar/scrape-verse-sentinel	—	git	1787062643844	—	—
0	22	4e126cd13f5438f8e881e450c4a932cbf55253f3	/Users/viclkykumar/chatbot	—	git	1786273387284	—	—
0	23	9b3059ea2dec3bf3ac99f38438fe21be27c5e5c1	/Users/viclkykumar/projects/telegram	—	git	1787985630674	—	—
0	24	1883b4b9c2fb28c4b7985a26dfed6cdcd3a613b9	/Users/viclkykumar/harness	—	git	1787722649201	—	—

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	id	string	16	4	`"f7ea95ab6d38fe9ae91fe204fd29d0f24449c712""846982133a6c33303221dbc166c0a89074f184ac"`
2	worktree	string	16	4	`"/Users/viclkykumar/video-editor""/Users/viclkykumar/Downloads/coral-repo"`
3	name	—	0	20	empty
4	vcs	string	20	0	`"git"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	10863ms	3	ok	id, worktree, name
minimal	t2	10015ms	3	ok	id, worktree, name
minimal	t3	23475ms	3	ok	id, worktree, name
order	t1	17349ms	22	ok	id, worktree, vcs
order	t2	7407ms	22	ok	id, worktree, vcs
order	t3	12459ms	22	ok	id, worktree, vcs
filter-vcs	t1	12424ms	21	ok	id, worktree, vcs
filter-vcs	t2	12894ms	21	ok	id, worktree, vcs
filter-vcs	t3	12901ms	21	ok	id, worktree, vcs
filter-by-id	t1	8240ms	1	ok	id, worktree, vcs
filter-by-id	t2	8080ms	1	ok	id, worktree, vcs
filter-by-id	t3	8346ms	1	ok	id, worktree, vcs
aggregate	t1	6473ms	2	ok	vcs, n
aggregate	t2	6597ms	2	ok	vcs, n
aggregate	t3	6427ms	2	ok	vcs, n

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

SELECT id, worktree, name, time_created

Columns coral returned (4)

idworktreenamevcs

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T10:06:04Z

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

first_run_at: 2026-09-01T08:33:27Z

last_retried_at: 2026-09-01T10:06:04Z

retry_count: 3

View version history →