`github.files`

pass

List pull requests files

Requires owner, repo, and pull_number. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

owner, repo, pull_number captured 2026-08-31 06:07:37Zmedian 29489 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	22714 ms	37371 ms	52028 ms	[26, 26]
realistic	2	23712 ms	29489 ms	35267 ms	[200, 200]
edge	2	25959 ms	29501 ms	33044 ms	[200, 200]

Latency per trial

minimalmedian 37371ms

scale: 0–52028 ms

realisticmedian 29489ms

scale: 0–35267 ms

edgemedian 29501ms

scale: 0–33044 ms

Probe variants — every command + output

minimal2 trials

min 22714ms · median 37371ms · max 52028ms · rows 26,26

smallest valid query

Command

SELECT * FROM github.files WHERE owner = 'anomalyco' AND repo = 'opencode' AND pull_number = '1' LIMIT 1

Trials + output

trial 1·22714ms·rows 26isError=false

First row (click to expand JSON)

{
  "additions": "24",
  "blob_url": "https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "changes": "24",
  "contents_url": "https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94431dcd89bd3d59ee1073a27442c95409f",
  "deletions": "0",
  "filename": "CONTEXT.md",
  "owner": "anomalyco",
  "patch": "@@ -0,0 +1,24 @@",
  "previous_filename": "",
  "pull_number": "1",
  "raw_url": "https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "repo": "opencode",
  "sha": "42c02f15d2dd00e294f577afece24b2634c17d9c",
  "status": "added"
}

columns (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

trial 2·52028ms·rows 26isError=false

First row (click to expand JSON)

{
  "additions": "24",
  "blob_url": "https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "changes": "24",
  "contents_url": "https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94431dcd89bd3d59ee1073a27442c95409f",
  "deletions": "0",
  "filename": "CONTEXT.md",
  "owner": "anomalyco",
  "patch": "@@ -0,0 +1,24 @@",
  "previous_filename": "",
  "pull_number": "1",
  "raw_url": "https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "repo": "opencode",
  "sha": "42c02f15d2dd00e294f577afece24b2634c17d9c",
  "status": "added"
}

columns (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

realistic2 trials

min 23712ms · median 29489ms · max 35267ms · rows 200,200

typical user query

Command

SELECT * FROM github.files WHERE owner = 'anomalyco' AND repo = 'opencode' AND pull_number = '1' LIMIT 25

Trials + output

trial 1·35267ms·rows 200isError=false

First row (click to expand JSON)

{
  "additions": "24",
  "blob_url": "https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "changes": "24",
  "contents_url": "https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94431dcd89bd3d59ee1073a27442c95409f",
  "deletions": "0",
  "filename": "CONTEXT.md",
  "owner": "anomalyco",
  "patch": "@@ -0,0 +1,24 @@",
  "previous_filename": "",
  "pull_number": "1",
  "raw_url": "https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "repo": "opencode",
  "sha": "42c02f15d2dd00e294f577afece24b2634c17d9c",
  "status": "added"
}

columns (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

trial 2·23712ms·rows 200isError=false

First row (click to expand JSON)

{
  "additions": "24",
  "blob_url": "https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "changes": "24",
  "contents_url": "https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94431dcd89bd3d59ee1073a27442c95409f",
  "deletions": "0",
  "filename": "CONTEXT.md",
  "owner": "anomalyco",
  "patch": "@@ -0,0 +1,24 @@",
  "previous_filename": "",
  "pull_number": "1",
  "raw_url": "https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "repo": "opencode",
  "sha": "42c02f15d2dd00e294f577afece24b2634c17d9c",
  "status": "added"
}

columns (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

edge2 trials

min 25959ms · median 29501ms · max 33044ms · rows 200,200

edge: larger limit

Command

SELECT * FROM github.files WHERE owner = 'anomalyco' AND repo = 'opencode' AND pull_number = '1' LIMIT 200

Trials + output

trial 1·25959ms·rows 200isError=false

First row (click to expand JSON)

{
  "additions": "24",
  "blob_url": "https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "changes": "24",
  "contents_url": "https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94431dcd89bd3d59ee1073a27442c95409f",
  "deletions": "0",
  "filename": "CONTEXT.md",
  "owner": "anomalyco",
  "patch": "@@ -0,0 +1,24 @@",
  "previous_filename": "",
  "pull_number": "1",
  "raw_url": "https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "repo": "opencode",
  "sha": "42c02f15d2dd00e294f577afece24b2634c17d9c",
  "status": "added"
}

columns (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

trial 2·33044ms·rows 200isError=false

First row (click to expand JSON)

{
  "additions": "24",
  "blob_url": "https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "changes": "24",
  "contents_url": "https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94431dcd89bd3d59ee1073a27442c95409f",
  "deletions": "0",
  "filename": "CONTEXT.md",
  "owner": "anomalyco",
  "patch": "@@ -0,0 +1,24 @@",
  "previous_filename": "",
  "pull_number": "1",
  "raw_url": "https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c95409f/CONTEXT.md",
  "repo": "opencode",
  "sha": "42c02f15d2dd00e294f577afece24b2634c17d9c",
  "status": "added"
}

columns (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

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

852 rows stored · 852 returned · page 1/35


1	0	24	https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd3d59ee1073a27442c95…	24	https://api.github.com/repos/anomalyco/opencode/contents/CONTEXT.md?ref=2a16b94…	0	CONTEXT.md	anomalyco	@@ -0,0 +1,24 @@	—	1	https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3d59ee1073a27442c954…	opencode	42c02f15d2dd00e294f577afece24b2634c17d9c	added
1	1	—	—	—	—	—	—	—	+# OpenCode Development Context	—	—	—	—	—	—
1	2	—	—	—	—	—	—	—	+	—	—	—	—	—	—
1	3	—	—	—	—	—	—	—	+## Build Commands	—	—	—	—	—	—
1	4	—	—	—	—	—	—	—	+- Build: `go build`	—	—	—	—	—	—
1	5	—	—	—	—	—	—	—	+- Run: `go run main.go`	—	—	—	—	—	—
1	6	—	—	—	—	—	—	—	+- Test: `go test ./...`	—	—	—	—	—	—
1	7	—	—	—	—	—	—	—	+- Test single package: `go test ./internal/package/...`	—	—	—	—	—	—
1	8	—	—	—	—	—	—	—	+- Test single test: `go test ./internal/package -run TestName`	—	—	—	—	—	—
1	9	—	—	—	—	—	—	—	+- Verbose test: `go test -v ./...`	—	—	—	—	—	—
1	10	—	—	—	—	—	—	—	+- Coverage: `go test -cover ./...`	—	—	—	—	—	—
1	11	—	—	—	—	—	—	—	+- Lint: `go vet ./...`	—	—	—	—	—	—
1	12	—	—	—	—	—	—	—	+- Format: `go fmt ./...`	—	—	—	—	—	—
1	13	—	—	—	—	—	—	—	+- Build snapshot: `./scripts/snapshot`	—	—	—	—	—	—
1	14	—	—	—	—	—	—	—	+	—	—	—	—	—	—
1	15	—	—	—	—	—	—	—	+## Code Style	—	—	—	—	—	—
1	16	—	—	—	—	—	—	—	+- Use Go 1.24+ features	—	—	—	—	—	—
1	17	—	—	—	—	—	—	—	+- Follow standard Go formatting (gofmt)	—	—	—	—	—	—
1	18	—	—	—	—	—	—	—	+- Use table-driven tests with t.Parallel() when possible	—	—	—	—	—	—
1	19	—	—	—	—	—	—	—	+- Error handling: check errors immediately, return early	—	—	—	—	—	—
1	20	—	—	—	—	—	—	—	+- Naming: CamelCase for exported, camelCase for unexported	—	—	—	—	—	—
1	21	—	—	—	—	—	—	—	+- Imports: standard library first, then external, then internal	—	—	—	—	—	—
1	22	—	—	—	—	—	—	—	+- Use context.Context for cancellation and timeouts	—	—	—	—	—	—
1	23	—	—	—	—	—	—	—	+- Prefer interfaces for dependencies to enable testing	—	—	—	—	—	—
1	24	—	—	—	—	—	—	—	+- Use testify for assertions in tests	—	—	—	—	—	—

Column profile

14 columns actually returned by coral. Catalog claims "3 required filter(s)": "owner, repo, pull_number". Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	additions	string	6	0	`"24"`
2	blob_url	string	6	0	`"https://github.com/anomalyco/opencode/blob/2a16b94431dcd89bd"`
3	changes	string	6	0	`"24"`
4	contents_url	string	6	0	`"https://api.github.com/repos/anomalyco/opencode/contents/CON"`
5	deletions	string	6	0	`"0"`
6	filename	string	6	0	`"CONTEXT.md"`
7	owner	string	6	0	`"anomalyco"`
8	patch	string	6	0	`"@@ -0,0 +1,24 @@"`
9	previous_filename	—	0	6	empty
10	pull_number	string	6	0	`"1"`
11	raw_url	string	6	0	`"https://github.com/anomalyco/opencode/raw/2a16b94431dcd89bd3"`
12	repo	string	6	0	`"opencode"`
13	sha	string	6	0	`"42c02f15d2dd00e294f577afece24b2634c17d9c"`
14	status	string	6	0	`"added"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	22714ms	26	ok	additions, blob_url, changes
minimal	t2	52028ms	26	ok	additions, blob_url, changes
realistic	t1	35267ms	200	ok	additions, blob_url, changes
realistic	t2	23712ms	200	ok	additions, blob_url, changes
edge	t1	25959ms	200	ok	additions, blob_url, changes
edge	t2	33044ms	200	ok	additions, blob_url, changes

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires owner, repo, and pull_number. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

Columns coral returned (14)

additionsblob_urlchangescontents_urldeletionsfilenameownerpatchprevious_filenamepull_numberraw_urlreposhastatus

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T06:07:37Z

JSON record: reports/github/tables/files.json

first_run_at: 2026-08-31T06:07:37Z

last_retried_at: 2026-08-31T06:07:37Z

retry_count: 0

View version history →