`opencode.accounts`

pass

OpenCode account rows used for provider authentication. Exposes the account email, url, token expiry, and timestamps. The underlying `access_token` / `refresh_token` are not exposed; they are live secrets.

SELECT id, email, url, token_expiry

no filters captured 2026-09-01 11:20:28Zmedian 7694 ms

Verdict: TRUE

Reachable and queryable: 0 errors across all trials, but the table is currently empty in the source (no data rows on scan variants). See analysis.json → data.empty_table.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	3	7210 ms	7694 ms	9270 ms	[0, 0, 0]
order	3	10531 ms	11187 ms	11395 ms	[0, 0, 0]
filter-email	3	10700 ms	11163 ms	18163 ms	[0, 0, 0]
aggregate	3	11036 ms	11269 ms	12867 ms	[1, 1, 1]

Latency per trial

minimalmedian 7694ms

scale: 0–9270 ms

ordermedian 11187ms

scale: 0–11395 ms

filter-emailmedian 11163ms

scale: 0–18163 ms

aggregatemedian 11269ms

scale: 0–12867 ms

Probe variants — every command + output

minimal3 trials

min 7210ms · median 7694ms · max 9270ms · rows 0,0,0

smallest query

Command

SELECT id, email, url, token_expiry, time_created FROM opencode.accounts LIMIT 1

Trials + output

trial 1·7210ms·rows 0isError=false

trial 2·7694ms·rows 0isError=false

trial 3·9270ms·rows 0isError=false

order3 trials

min 10531ms · median 11187ms · max 11395ms · rows 0,0,0

most recently created accounts

Command

SELECT id, email, url, token_expiry FROM opencode.accounts ORDER BY time_created DESC LIMIT 25

Trials + output

trial 1·10531ms·rows 0isError=false

trial 2·11395ms·rows 0isError=false

trial 3·11187ms·rows 0isError=false

filter-email3 trials

min 10700ms · median 11163ms · max 18163ms · rows 0,0,0

accounts with a known email

Command

SELECT id, email, url FROM opencode.accounts WHERE email IS NOT NULL LIMIT 25

Trials + output

trial 1·18163ms·rows 0isError=false

trial 2·10700ms·rows 0isError=false

trial 3·11163ms·rows 0isError=false

aggregate3 trials

min 11036ms · median 11269ms · max 12867ms · rows 1,1,1

account totals

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT url) AS providers FROM opencode.accounts

Trials + output

trial 1·11269ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "providers": "0"
}

columns (2)

nproviders

trial 2·11036ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "providers": "0"
}

columns (2)

nproviders

trial 3·12867ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "providers": "0"
}

columns (2)

nproviders

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

4 rows stored · 4 returned · page 1/1


0	0	0	0
1	1	0	0
2	2	0	0
3	3	0	0

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	7210ms	0	ok	—
minimal	t2	7694ms	0	ok	—
minimal	t3	9270ms	0	ok	—
order	t1	10531ms	0	ok	—
order	t2	11395ms	0	ok	—
order	t3	11187ms	0	ok	—
filter-email	t1	18163ms	0	ok	—
filter-email	t2	10700ms	0	ok	—
filter-email	t3	11163ms	0	ok	—
aggregate	t1	11269ms	1	ok	n, providers
aggregate	t2	11036ms	1	ok	n, providers
aggregate	t3	12867ms	1	ok	n, providers

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T11:20:28Z

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

first_run_at: 2026-09-01T11:20:28Z

last_retried_at: 2026-09-01T11:20:28Z

retry_count: 1

View version history →