C
opencode source

opencode.project_directories

pass

Directory entries attached to OpenCode projects, with the entry's type (worktree, sandboxed, etc.) and strategy when present.

SELECT project_id, directory, type, strategy

no filters captured 2026-09-01 10:09:28Zmedian 6466 ms
Verdict: TRUE

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

rendering…

Summary

VariantTrialsMinMedianMaxRow countsErrors
minimal36457 ms6466 ms6468 ms[5, 5, 5]0
all38265 ms8898 ms9002 ms[21, 21, 21]0
filter36488 ms6507 ms6522 ms[1, 1, 1]0
aggregate36465 ms6495 ms6505 ms[1, 1, 1]0

Latency per trial

minimalmedian 6466ms
t16468mst26457mst36466ms
scale: 0–6468 ms
allmedian 8898ms
t18265mst29002mst38898ms
scale: 0–9002 ms
filtermedian 6507ms
t16488mst26507mst36522ms
scale: 0–6522 ms
aggregatemedian 6495ms
t16505mst26495mst36465ms
scale: 0–6505 ms

Probe variants — every command + output

minimal3 trials
min 6457ms · median 6466ms · max 6468ms · rows 5,5,5

smallest query

Command
SELECT project_id, directory, type, strategy FROM opencode.project_directories LIMIT 5
Trials + output
trial 1·6468ms·rows 5isError=false
First row (click to expand JSON)
{
  "project_id": "13e16407886baaa621bc62d02a231f8eea09ae80",
  "directory": "/Users/viclkykumar/janadhikar",
  "type": "",
  "strategy": ""
}
columns (4)
project_iddirectorytypestrategy
trial 2·6457ms·rows 5isError=false
First row (click to expand JSON)
{
  "project_id": "13e16407886baaa621bc62d02a231f8eea09ae80",
  "directory": "/Users/viclkykumar/janadhikar",
  "type": "",
  "strategy": ""
}
columns (4)
project_iddirectorytypestrategy
trial 3·6466ms·rows 5isError=false
First row (click to expand JSON)
{
  "project_id": "13e16407886baaa621bc62d02a231f8eea09ae80",
  "directory": "/Users/viclkykumar/janadhikar",
  "type": "",
  "strategy": ""
}
columns (4)
project_iddirectorytypestrategy
all3 trials
min 8265ms · median 8898ms · max 9002ms · rows 21,21,21

all attached directories

Command
SELECT project_id, directory, type, strategy FROM opencode.project_directories ORDER BY project_id ASC LIMIT 25
Trials + output
trial 1·8265ms·rows 21isError=false
First row (click to expand JSON)
{
  "project_id": "13e16407886baaa621bc62d02a231f8eea09ae80",
  "directory": "/Users/viclkykumar/janadhikar",
  "type": "",
  "strategy": ""
}
columns (4)
project_iddirectorytypestrategy
trial 2·9002ms·rows 21isError=false
First row (click to expand JSON)
{
  "project_id": "13e16407886baaa621bc62d02a231f8eea09ae80",
  "directory": "/Users/viclkykumar/janadhikar",
  "type": "",
  "strategy": ""
}
columns (4)
project_iddirectorytypestrategy
trial 3·8898ms·rows 21isError=false
First row (click to expand JSON)
{
  "project_id": "13e16407886baaa621bc62d02a231f8eea09ae80",
  "directory": "/Users/viclkykumar/janadhikar",
  "type": "",
  "strategy": ""
}
columns (4)
project_iddirectorytypestrategy
filter3 trials
min 6488ms · median 6507ms · max 6522ms · rows 1,1,1

directories of one project

Command
SELECT directory, type FROM opencode.project_directories WHERE project_id = '13e16407886baaa621bc62d02a231f8eea09ae80' LIMIT 25
Trials + output
trial 1·6488ms·rows 1isError=false
First row (click to expand JSON)
{
  "directory": "/Users/viclkykumar/janadhikar",
  "type": ""
}
columns (2)
directorytype
trial 2·6507ms·rows 1isError=false
First row (click to expand JSON)
{
  "directory": "/Users/viclkykumar/janadhikar",
  "type": ""
}
columns (2)
directorytype
trial 3·6522ms·rows 1isError=false
First row (click to expand JSON)
{
  "directory": "/Users/viclkykumar/janadhikar",
  "type": ""
}
columns (2)
directorytype
aggregate3 trials
min 6465ms · median 6495ms · max 6505ms · rows 1,1,1

directories by type

Command
SELECT type, COUNT(*) AS n FROM opencode.project_directories GROUP BY type
Trials + output
trial 1·6505ms·rows 1isError=false
First row (click to expand JSON)
{
  "type": "",
  "n": "21"
}
columns (2)
typen
trial 2·6495ms·rows 1isError=false
First row (click to expand JSON)
{
  "type": "",
  "n": "21"
}
columns (2)
typen
trial 3·6465ms·rows 1isError=false
First row (click to expand JSON)
{
  "type": "",
  "n": "21"
}
columns (2)
typen

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

112 rows stored · 112 returned · page 1/5
0013e16407886baaa621bc62d02a231f8eea09ae80/Users/viclkykumar/janadhikar———
011883b4b9c2fb28c4b7985a26dfed6cdcd3a613b9/Users/viclkykumar/harness———
0241d5d7809bb9e1ae9b5c6ac15cc88ee30dced175/Volumes/algsoch/algsoch———
034e126cd13f5438f8e881e450c4a932cbf55253f3/Users/viclkykumar/chatbot———
0454d568696de63f9f1c1fd380aaea32702da92491/Users/viclkykumar/scrape-verse-sentinel———
1513e16407886baaa621bc62d02a231f8eea09ae80/Users/viclkykumar/janadhikar———
161883b4b9c2fb28c4b7985a26dfed6cdcd3a613b9/Users/viclkykumar/harness———
1741d5d7809bb9e1ae9b5c6ac15cc88ee30dced175/Volumes/algsoch/algsoch———
184e126cd13f5438f8e881e450c4a932cbf55253f3/Users/viclkykumar/chatbot———
1954d568696de63f9f1c1fd380aaea32702da92491/Users/viclkykumar/scrape-verse-sentinel———
21013e16407886baaa621bc62d02a231f8eea09ae80/Users/viclkykumar/janadhikar———
2111883b4b9c2fb28c4b7985a26dfed6cdcd3a613b9/Users/viclkykumar/harness———
21241d5d7809bb9e1ae9b5c6ac15cc88ee30dced175/Volumes/algsoch/algsoch———
2134e126cd13f5438f8e881e450c4a932cbf55253f3/Users/viclkykumar/chatbot———
21454d568696de63f9f1c1fd380aaea32702da92491/Users/viclkykumar/scrape-verse-sentinel———
31513e16407886baaa621bc62d02a231f8eea09ae80/Users/viclkykumar/janadhikar———
3161883b4b9c2fb28c4b7985a26dfed6cdcd3a613b9/Users/viclkykumar/harness———
31741d5d7809bb9e1ae9b5c6ac15cc88ee30dced175/Volumes/algsoch/algsoch———
3184e126cd13f5438f8e881e450c4a932cbf55253f3/Users/viclkykumar/chatbot———
31954d568696de63f9f1c1fd380aaea32702da92491/Users/viclkykumar/scrape-verse-sentinel———
02013e16407886baaa621bc62d02a231f8eea09ae80/Users/viclkykumar/janadhikar———
0211883b4b9c2fb28c4b7985a26dfed6cdcd3a613b9/Users/viclkykumar/harness———
02241d5d7809bb9e1ae9b5c6ac15cc88ee30dced175/Volumes/algsoch/algsoch———
0234e126cd13f5438f8e881e450c4a932cbf55253f3/Users/viclkykumar/chatbot———
02454d568696de63f9f1c1fd380aaea32702da92491/Users/viclkykumar/scrape-verse-sentinel———

Column profile

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

#ColumnInferred typeNon-nullNullsSample value(s)
1project_idstring88"13e16407886baaa621bc62d02a231f8eea09ae80"
2directorystring124"/Users/viclkykumar/janadhikar"
3type—016empty
4strategy—016empty

Trial comparison

Variant / comboTrial #LatencyRowsStatusFirst key returned
minimalt16468ms5okproject_id, directory, type
minimalt26457ms5okproject_id, directory, type
minimalt36466ms5okproject_id, directory, type
allt18265ms21okproject_id, directory, type
allt29002ms21okproject_id, directory, type
allt38898ms21okproject_id, directory, type
filtert16488ms1okdirectory, type
filtert26507ms1okdirectory, type
filtert36522ms1okdirectory, type
aggregatet16505ms1oktype, n
aggregatet26495ms1oktype, n
aggregatet36465ms1oktype, n

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)
SELECT project_id, directory, type, strategy
Columns coral returned (4)
project_iddirectorytypestrategy
Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T10:09:28Z
JSON record: reports/opencode/tables/project_directories.json
first_run_at: 2026-09-01T08:48:01Z
last_retried_at: 2026-09-01T10:09:28Z
retry_count: 2
View version history →