`github.deployment_branch_policies`

pass

List deployment branch policies

Requires owner, repo, and environment_name. Most useful optional filters: branch_policy_id. Add branch_policy_id to jump from the default list call to a specific record lookup.

owner, repo, environment_name captured 2026-08-31 05:54:43Zmedian 29607 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	28475 ms	31159 ms	33843 ms	[1, 1]
realistic	2	29149 ms	29607 ms	30065 ms	[1, 1]
edge	2	29724 ms	31276 ms	32829 ms	[1, 1]

Latency per trial

minimalmedian 31159ms

scale: 0–33843 ms

realisticmedian 29607ms

scale: 0–30065 ms

edgemedian 31276ms

scale: 0–32829 ms

Probe variants — every command + output

minimal2 trials

min 28475ms · median 31159ms · max 33843ms · rows 1,1

smallest valid query

Command

SELECT * FROM github.deployment_branch_policies WHERE owner = 'anomalyco' AND repo = 'opencode' AND environment_name = 'production' LIMIT 1

Trials + output

trial 1·33843ms·rows 1isError=false

First row (click to expand JSON)

{
  "branch_policy_id": "",
  "environment_name": "production",
  "id": "50270334",
  "name": "production",
  "node_id": "MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==",
  "owner": "anomalyco",
  "repo": "opencode",
  "type": "branch"
}

columns (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

trial 2·28475ms·rows 1isError=false

First row (click to expand JSON)

{
  "branch_policy_id": "",
  "environment_name": "production",
  "id": "50270334",
  "name": "production",
  "node_id": "MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==",
  "owner": "anomalyco",
  "repo": "opencode",
  "type": "branch"
}

columns (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

realistic2 trials

min 29149ms · median 29607ms · max 30065ms · rows 1,1

typical user query

Command

SELECT * FROM github.deployment_branch_policies WHERE owner = 'anomalyco' AND repo = 'opencode' AND environment_name = 'production' LIMIT 25

Trials + output

trial 1·30065ms·rows 1isError=false

First row (click to expand JSON)

{
  "branch_policy_id": "",
  "environment_name": "production",
  "id": "50270334",
  "name": "production",
  "node_id": "MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==",
  "owner": "anomalyco",
  "repo": "opencode",
  "type": "branch"
}

columns (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

trial 2·29149ms·rows 1isError=false

First row (click to expand JSON)

{
  "branch_policy_id": "",
  "environment_name": "production",
  "id": "50270334",
  "name": "production",
  "node_id": "MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==",
  "owner": "anomalyco",
  "repo": "opencode",
  "type": "branch"
}

columns (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

edge2 trials

min 29724ms · median 31276ms · max 32829ms · rows 1,1

edge: larger limit

Command

SELECT * FROM github.deployment_branch_policies WHERE owner = 'anomalyco' AND repo = 'opencode' AND environment_name = 'production' LIMIT 200

Trials + output

trial 1·29724ms·rows 1isError=false

First row (click to expand JSON)

{
  "branch_policy_id": "",
  "environment_name": "production",
  "id": "50270334",
  "name": "production",
  "node_id": "MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==",
  "owner": "anomalyco",
  "repo": "opencode",
  "type": "branch"
}

columns (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

trial 2·32829ms·rows 1isError=false

First row (click to expand JSON)

{
  "branch_policy_id": "",
  "environment_name": "production",
  "id": "50270334",
  "name": "production",
  "node_id": "MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==",
  "owner": "anomalyco",
  "repo": "opencode",
  "type": "branch"
}

columns (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

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

6 rows stored · 6 returned · page 1/1


1	0	—	production	50270334	production	MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==	anomalyco	opencode	branch
2	1	—	production	50270334	production	MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==	anomalyco	opencode	branch
1	2	—	production	50270334	production	MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==	anomalyco	opencode	branch
2	3	—	production	50270334	production	MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==	anomalyco	opencode	branch
1	4	—	production	50270334	production	MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==	anomalyco	opencode	branch
2	5	—	production	50270334	production	MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA==	anomalyco	opencode	branch

Column profile

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

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	branch_policy_id	—	0	6	empty
2	environment_name	string	6	0	`"production"`
3	id	string	6	0	`"50270334"`
4	name	string	6	0	`"production"`
5	node_id	string	6	0	`"MDE2OkdhdGVCcmFuY2hQb2xpY3k1MDI3MDMzNA=="`
6	owner	string	6	0	`"anomalyco"`
7	repo	string	6	0	`"opencode"`
8	type	string	6	0	`"branch"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	33843ms	1	ok	branch_policy_id, environment_name, id
minimal	t2	28475ms	1	ok	branch_policy_id, environment_name, id
realistic	t1	30065ms	1	ok	branch_policy_id, environment_name, id
realistic	t2	29149ms	1	ok	branch_policy_id, environment_name, id
edge	t1	29724ms	1	ok	branch_policy_id, environment_name, id
edge	t2	32829ms	1	ok	branch_policy_id, environment_name, id

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires owner, repo, and environment_name. Most useful optional filters: branch_policy_id. Add branch_policy_id to jump from the default list call to a specific record lookup.

Columns coral returned (8)

branch_policy_idenvironment_nameidnamenode_idownerrepotype

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T05:54:43Z

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

first_run_at: 2026-08-31T05:54:43Z

last_retried_at: 2026-08-31T05:54:43Z

retry_count: 0

View version history →