`github.environments`

pass

List environments

Requires owner and repo. Most useful optional filters: environment_name. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

owner, repo captured 2026-08-31 06:03:37Zmedian 28091 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	29917 ms	30713 ms	31510 ms	[1, 1]
realistic	2	26988 ms	28091 ms	29195 ms	[5, 5]
edge	2	30395 ms	38323 ms	46251 ms	[5, 5]

Latency per trial

minimalmedian 30713ms

scale: 0–31510 ms

realisticmedian 28091ms

scale: 0–29195 ms

edgemedian 38323ms

scale: 0–46251 ms

Probe variants — every command + output

minimal2 trials

min 29917ms · median 30713ms · max 31510ms · rows 1,1

smallest valid query

Command

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

Trials + output

trial 1·29917ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-08-29T04:51:54Z",
  "deployment_branch_policy": "",
  "environment_name": "",
  "html_url": "https://github.com/anomalyco/opencode/deployments/activity_log?environments_filter=beta",
  "id": "20822474166",
  "name": "beta",
  "node_id": "EN_kwDOOiiGL88AAAAE2R29tg",
  "owner": "anomalyco",
  "prevent_self_review": "",
  "protection_rules": "[]",
  "repo": "opencode",
  "reviewers": "",
  "type": "",
  "updated_at": "2026-08-29T04:51:54Z",
  "url": "https://api.github.com/repos/anomalyco/opencode/environments/beta",
  "wait_timer": ""
}

columns (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

trial 2·31510ms·rows 1isError=false

First row (click to expand JSON)

{
  "created_at": "2026-08-29T04:51:54Z",
  "deployment_branch_policy": "",
  "environment_name": "",
  "html_url": "https://github.com/anomalyco/opencode/deployments/activity_log?environments_filter=beta",
  "id": "20822474166",
  "name": "beta",
  "node_id": "EN_kwDOOiiGL88AAAAE2R29tg",
  "owner": "anomalyco",
  "prevent_self_review": "",
  "protection_rules": "[]",
  "repo": "opencode",
  "reviewers": "",
  "type": "",
  "updated_at": "2026-08-29T04:51:54Z",
  "url": "https://api.github.com/repos/anomalyco/opencode/environments/beta",
  "wait_timer": ""
}

columns (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

realistic2 trials

min 26988ms · median 28091ms · max 29195ms · rows 5,5

typical user query

Command

SELECT * FROM github.environments WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 25

Trials + output

trial 1·26988ms·rows 5isError=false

First row (click to expand JSON)

{
  "created_at": "2026-08-29T04:51:54Z",
  "deployment_branch_policy": "",
  "environment_name": "",
  "html_url": "https://github.com/anomalyco/opencode/deployments/activity_log?environments_filter=beta",
  "id": "20822474166",
  "name": "beta",
  "node_id": "EN_kwDOOiiGL88AAAAE2R29tg",
  "owner": "anomalyco",
  "prevent_self_review": "",
  "protection_rules": "[]",
  "repo": "opencode",
  "reviewers": "",
  "type": "",
  "updated_at": "2026-08-29T04:51:54Z",
  "url": "https://api.github.com/repos/anomalyco/opencode/environments/beta",
  "wait_timer": ""
}

columns (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

trial 2·29195ms·rows 5isError=false

First row (click to expand JSON)

{
  "created_at": "2026-08-29T04:51:54Z",
  "deployment_branch_policy": "",
  "environment_name": "",
  "html_url": "https://github.com/anomalyco/opencode/deployments/activity_log?environments_filter=beta",
  "id": "20822474166",
  "name": "beta",
  "node_id": "EN_kwDOOiiGL88AAAAE2R29tg",
  "owner": "anomalyco",
  "prevent_self_review": "",
  "protection_rules": "[]",
  "repo": "opencode",
  "reviewers": "",
  "type": "",
  "updated_at": "2026-08-29T04:51:54Z",
  "url": "https://api.github.com/repos/anomalyco/opencode/environments/beta",
  "wait_timer": ""
}

columns (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

edge2 trials

min 30395ms · median 38323ms · max 46251ms · rows 5,5

edge: larger limit

Command

SELECT * FROM github.environments WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 200

Trials + output

trial 1·46251ms·rows 5isError=false

First row (click to expand JSON)

{
  "created_at": "2026-08-29T04:51:54Z",
  "deployment_branch_policy": "",
  "environment_name": "",
  "html_url": "https://github.com/anomalyco/opencode/deployments/activity_log?environments_filter=beta",
  "id": "20822474166",
  "name": "beta",
  "node_id": "EN_kwDOOiiGL88AAAAE2R29tg",
  "owner": "anomalyco",
  "prevent_self_review": "",
  "protection_rules": "[]",
  "repo": "opencode",
  "reviewers": "",
  "type": "",
  "updated_at": "2026-08-29T04:51:54Z",
  "url": "https://api.github.com/repos/anomalyco/opencode/environments/beta",
  "wait_timer": ""
}

columns (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

trial 2·30395ms·rows 5isError=false

First row (click to expand JSON)

{
  "created_at": "2026-08-29T04:51:54Z",
  "deployment_branch_policy": "",
  "environment_name": "",
  "html_url": "https://github.com/anomalyco/opencode/deployments/activity_log?environments_filter=beta",
  "id": "20822474166",
  "name": "beta",
  "node_id": "EN_kwDOOiiGL88AAAAE2R29tg",
  "owner": "anomalyco",
  "prevent_self_review": "",
  "protection_rules": "[]",
  "repo": "opencode",
  "reviewers": "",
  "type": "",
  "updated_at": "2026-08-29T04:51:54Z",
  "url": "https://api.github.com/repos/anomalyco/opencode/environments/beta",
  "wait_timer": ""
}

columns (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

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

22 rows stored · 22 returned · page 1/1


1	0	2026-08-29T04:51:54Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	20822474166	beta	EN_kwDOOiiGL88AAAAE2R29tg	anomalyco	—	[]	opencode	—	—	2026-08-29T04:51:54Z	https://api.github.com/repos/anomalyco/opencode/environments/beta	—
2	1	2026-08-29T04:51:54Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	20822474166	beta	EN_kwDOOiiGL88AAAAE2R29tg	anomalyco	—	[]	opencode	—	—	2026-08-29T04:51:54Z	https://api.github.com/repos/anomalyco/opencode/environments/beta	—
1	2	2026-08-29T04:51:54Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	20822474166	beta	EN_kwDOOiiGL88AAAAE2R29tg	anomalyco	—	[]	opencode	—	—	2026-08-29T04:51:54Z	https://api.github.com/repos/anomalyco/opencode/environments/beta	—
1	3	2025-10-28T20:05:35Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	9592718331	copilot	EN_kwDOOiiGL88AAAACO8VD-w	anomalyco	—	[]	opencode	—	—	2025-10-28T20:05:35Z	https://api.github.com/repos/anomalyco/opencode/environments/copilot	—
1	4	2026-05-25T22:27:19Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15797273185	dev	EN_kwDOOiiGL88AAAADrZdCYQ	anomalyco	—	[{"id":55605532,"node_id":"GA_kwDOOiiGL84DUHkc","type":"branch_policy"}]	opencode	—	—	2026-05-25T22:27:19Z	https://api.github.com/repos/anomalyco/opencode/environments/dev	—
1	5	2026-05-26T01:22:45Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15801161231	production	EN_kwDOOiiGL88AAAADrdKWDw	anomalyco	—	[{"id":55612085,"node_id":"GA_kwDOOiiGL84DUJK1","type":"branch_policy"}]	opencode	—	—	2026-05-26T01:22:45Z	https://api.github.com/repos/anomalyco/opencode/environments/production	—
1	6	2025-12-05T21:42:25Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	10455826962	staging - packages/docs	EN_kwDOOiiGL88AAAACbzdCEg	anomalyco	—	[]	opencode	—	—	2025-12-05T21:42:25Z	https://api.github.com/repos/anomalyco/opencode/environments/staging - packages…	—
2	7	2026-08-29T04:51:54Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	20822474166	beta	EN_kwDOOiiGL88AAAAE2R29tg	anomalyco	—	[]	opencode	—	—	2026-08-29T04:51:54Z	https://api.github.com/repos/anomalyco/opencode/environments/beta	—
2	8	2025-10-28T20:05:35Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	9592718331	copilot	EN_kwDOOiiGL88AAAACO8VD-w	anomalyco	—	[]	opencode	—	—	2025-10-28T20:05:35Z	https://api.github.com/repos/anomalyco/opencode/environments/copilot	—
2	9	2026-05-25T22:27:19Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15797273185	dev	EN_kwDOOiiGL88AAAADrZdCYQ	anomalyco	—	[{"id":55605532,"node_id":"GA_kwDOOiiGL84DUHkc","type":"branch_policy"}]	opencode	—	—	2026-05-25T22:27:19Z	https://api.github.com/repos/anomalyco/opencode/environments/dev	—
2	10	2026-05-26T01:22:45Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15801161231	production	EN_kwDOOiiGL88AAAADrdKWDw	anomalyco	—	[{"id":55612085,"node_id":"GA_kwDOOiiGL84DUJK1","type":"branch_policy"}]	opencode	—	—	2026-05-26T01:22:45Z	https://api.github.com/repos/anomalyco/opencode/environments/production	—
2	11	2025-12-05T21:42:25Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	10455826962	staging - packages/docs	EN_kwDOOiiGL88AAAACbzdCEg	anomalyco	—	[]	opencode	—	—	2025-12-05T21:42:25Z	https://api.github.com/repos/anomalyco/opencode/environments/staging - packages…	—
1	12	2026-08-29T04:51:54Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	20822474166	beta	EN_kwDOOiiGL88AAAAE2R29tg	anomalyco	—	[]	opencode	—	—	2026-08-29T04:51:54Z	https://api.github.com/repos/anomalyco/opencode/environments/beta	—
1	13	2025-10-28T20:05:35Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	9592718331	copilot	EN_kwDOOiiGL88AAAACO8VD-w	anomalyco	—	[]	opencode	—	—	2025-10-28T20:05:35Z	https://api.github.com/repos/anomalyco/opencode/environments/copilot	—
1	14	2026-05-25T22:27:19Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15797273185	dev	EN_kwDOOiiGL88AAAADrZdCYQ	anomalyco	—	[{"id":55605532,"node_id":"GA_kwDOOiiGL84DUHkc","type":"branch_policy"}]	opencode	—	—	2026-05-25T22:27:19Z	https://api.github.com/repos/anomalyco/opencode/environments/dev	—
1	15	2026-05-26T01:22:45Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15801161231	production	EN_kwDOOiiGL88AAAADrdKWDw	anomalyco	—	[{"id":55612085,"node_id":"GA_kwDOOiiGL84DUJK1","type":"branch_policy"}]	opencode	—	—	2026-05-26T01:22:45Z	https://api.github.com/repos/anomalyco/opencode/environments/production	—
1	16	2025-12-05T21:42:25Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	10455826962	staging - packages/docs	EN_kwDOOiiGL88AAAACbzdCEg	anomalyco	—	[]	opencode	—	—	2025-12-05T21:42:25Z	https://api.github.com/repos/anomalyco/opencode/environments/staging - packages…	—
2	17	2026-08-29T04:51:54Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	20822474166	beta	EN_kwDOOiiGL88AAAAE2R29tg	anomalyco	—	[]	opencode	—	—	2026-08-29T04:51:54Z	https://api.github.com/repos/anomalyco/opencode/environments/beta	—
2	18	2025-10-28T20:05:35Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	9592718331	copilot	EN_kwDOOiiGL88AAAACO8VD-w	anomalyco	—	[]	opencode	—	—	2025-10-28T20:05:35Z	https://api.github.com/repos/anomalyco/opencode/environments/copilot	—
2	19	2026-05-25T22:27:19Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15797273185	dev	EN_kwDOOiiGL88AAAADrZdCYQ	anomalyco	—	[{"id":55605532,"node_id":"GA_kwDOOiiGL84DUHkc","type":"branch_policy"}]	opencode	—	—	2026-05-25T22:27:19Z	https://api.github.com/repos/anomalyco/opencode/environments/dev	—
2	20	2026-05-26T01:22:45Z	{"protected_branches":false,"custom_branch_policies":true}	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	15801161231	production	EN_kwDOOiiGL88AAAADrdKWDw	anomalyco	—	[{"id":55612085,"node_id":"GA_kwDOOiiGL84DUJK1","type":"branch_policy"}]	opencode	—	—	2026-05-26T01:22:45Z	https://api.github.com/repos/anomalyco/opencode/environments/production	—
2	21	2025-12-05T21:42:25Z	—	—	https://github.com/anomalyco/opencode/deployments/activity_log?environments_fil…	10455826962	staging - packages/docs	EN_kwDOOiiGL88AAAACbzdCEg	anomalyco	—	[]	opencode	—	—	2025-12-05T21:42:25Z	https://api.github.com/repos/anomalyco/opencode/environments/staging - packages…	—

Column profile

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

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	created_at	string	6	0	`"2026-08-29T04:51:54Z"`
2	deployment_branch_policy	—	0	6	empty
3	environment_name	—	0	6	empty
4	html_url	string	6	0	`"https://github.com/anomalyco/opencode/deployments/activity_l"`
5	id	string	6	0	`"20822474166"`
6	name	string	6	0	`"beta"`
7	node_id	string	6	0	`"EN_kwDOOiiGL88AAAAE2R29tg"`
8	owner	string	6	0	`"anomalyco"`
9	prevent_self_review	—	0	6	empty
10	protection_rules	string	6	0	`"[]"`
11	repo	string	6	0	`"opencode"`
12	reviewers	—	0	6	empty
13	type	—	0	6	empty
14	updated_at	string	6	0	`"2026-08-29T04:51:54Z"`
15	url	string	6	0	`"https://api.github.com/repos/anomalyco/opencode/environments"`
16	wait_timer	—	0	6	empty

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	29917ms	1	ok	created_at, deployment_branch_policy, environment_name
minimal	t2	31510ms	1	ok	created_at, deployment_branch_policy, environment_name
realistic	t1	26988ms	5	ok	created_at, deployment_branch_policy, environment_name
realistic	t2	29195ms	5	ok	created_at, deployment_branch_policy, environment_name
edge	t1	46251ms	5	ok	created_at, deployment_branch_policy, environment_name
edge	t2	30395ms	5	ok	created_at, deployment_branch_policy, environment_name

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires owner and repo. Most useful optional filters: environment_name. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

Columns coral returned (16)

created_atdeployment_branch_policyenvironment_namehtml_urlidnamenode_idownerprevent_self_reviewprotection_rulesreporeviewerstypeupdated_aturlwait_timer

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

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

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

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

retry_count: 0

View version history →