`github.organizations`

pass

List organizations

Works without WHERE filters. Most useful optional filters: org, enterprise, enterprise-team. Use LIMIT for spot checks; large result sets paginate quickly.

no filters captured 2026-08-31 07:27:47Zmedian 34028 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	36744 ms	37341 ms	37939 ms	[1, 1]
realistic	2	33554 ms	34028 ms	34502 ms	[25, 25]
edge	2	37903 ms	41924 ms	45945 ms	[200, 200]

Latency per trial

minimalmedian 37341ms

scale: 0–37939 ms

realisticmedian 34028ms

scale: 0–34502 ms

edgemedian 41924ms

scale: 0–45945 ms

Probe variants — every command + output

minimal2 trials

min 36744ms · median 37341ms · max 37939ms · rows 1,1

smallest valid query (no filters)

Command

SELECT * FROM github.organizations LIMIT 1

Trials + output

trial 1·36744ms·rows 1isError=false

First row (click to expand JSON)

{
  "avatar_url": "https://avatars.githubusercontent.com/u/81?v=4",
  "description": "",
  "events_url": "https://api.github.com/orgs/engineyard/events",
  "hooks_url": "https://api.github.com/orgs/engineyard/hooks",
  "id": "81",
  "issues_url": "https://api.github.com/orgs/engineyard/issues",
  "login": "engineyard",
  "members_url": "https://api.github.com/orgs/engineyard/members{/member}",
  "node_id": "MDEyOk9yZ2FuaXphdGlvbjgx",
  "public_members_url": "https://api.github.com/orgs/engineyard/public_members{/member}",
  "repos_url": "https://api.github.com/orgs/engineyard/repos",
  "url": "https://api.github.com/orgs/engineyard",
  "enterprise": "",
  "enterprise-team": "",
  "org": ""
}

columns (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

trial 2·37939ms·rows 1isError=false

First row (click to expand JSON)

{
  "avatar_url": "https://avatars.githubusercontent.com/u/81?v=4",
  "description": "",
  "events_url": "https://api.github.com/orgs/engineyard/events",
  "hooks_url": "https://api.github.com/orgs/engineyard/hooks",
  "id": "81",
  "issues_url": "https://api.github.com/orgs/engineyard/issues",
  "login": "engineyard",
  "members_url": "https://api.github.com/orgs/engineyard/members{/member}",
  "node_id": "MDEyOk9yZ2FuaXphdGlvbjgx",
  "public_members_url": "https://api.github.com/orgs/engineyard/public_members{/member}",
  "repos_url": "https://api.github.com/orgs/engineyard/repos",
  "url": "https://api.github.com/orgs/engineyard",
  "enterprise": "",
  "enterprise-team": "",
  "org": ""
}

columns (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

realistic2 trials

min 33554ms · median 34028ms · max 34502ms · rows 25,25

typical user query (no filters)

Command

SELECT * FROM github.organizations LIMIT 25

Trials + output

trial 1·34502ms·rows 25isError=false

First row (click to expand JSON)

{
  "avatar_url": "https://avatars.githubusercontent.com/u/81?v=4",
  "description": "",
  "events_url": "https://api.github.com/orgs/engineyard/events",
  "hooks_url": "https://api.github.com/orgs/engineyard/hooks",
  "id": "81",
  "issues_url": "https://api.github.com/orgs/engineyard/issues",
  "login": "engineyard",
  "members_url": "https://api.github.com/orgs/engineyard/members{/member}",
  "node_id": "MDEyOk9yZ2FuaXphdGlvbjgx",
  "public_members_url": "https://api.github.com/orgs/engineyard/public_members{/member}",
  "repos_url": "https://api.github.com/orgs/engineyard/repos",
  "url": "https://api.github.com/orgs/engineyard",
  "enterprise": "",
  "enterprise-team": "",
  "org": ""
}

columns (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

trial 2·33554ms·rows 25isError=false

First row (click to expand JSON)

{
  "avatar_url": "https://avatars.githubusercontent.com/u/81?v=4",
  "description": "",
  "events_url": "https://api.github.com/orgs/engineyard/events",
  "hooks_url": "https://api.github.com/orgs/engineyard/hooks",
  "id": "81",
  "issues_url": "https://api.github.com/orgs/engineyard/issues",
  "login": "engineyard",
  "members_url": "https://api.github.com/orgs/engineyard/members{/member}",
  "node_id": "MDEyOk9yZ2FuaXphdGlvbjgx",
  "public_members_url": "https://api.github.com/orgs/engineyard/public_members{/member}",
  "repos_url": "https://api.github.com/orgs/engineyard/repos",
  "url": "https://api.github.com/orgs/engineyard",
  "enterprise": "",
  "enterprise-team": "",
  "org": ""
}

columns (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

edge2 trials

min 37903ms · median 41924ms · max 45945ms · rows 200,200

edge: larger limit, no filters

Command

SELECT * FROM github.organizations LIMIT 200

Trials + output

trial 1·45945ms·rows 200isError=false

First row (click to expand JSON)

{
  "avatar_url": "https://avatars.githubusercontent.com/u/81?v=4",
  "description": "",
  "events_url": "https://api.github.com/orgs/engineyard/events",
  "hooks_url": "https://api.github.com/orgs/engineyard/hooks",
  "id": "81",
  "issues_url": "https://api.github.com/orgs/engineyard/issues",
  "login": "engineyard",
  "members_url": "https://api.github.com/orgs/engineyard/members{/member}",
  "node_id": "MDEyOk9yZ2FuaXphdGlvbjgx",
  "public_members_url": "https://api.github.com/orgs/engineyard/public_members{/member}",
  "repos_url": "https://api.github.com/orgs/engineyard/repos",
  "url": "https://api.github.com/orgs/engineyard",
  "enterprise": "",
  "enterprise-team": "",
  "org": ""
}

columns (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

trial 2·37903ms·rows 200isError=false

First row (click to expand JSON)

{
  "avatar_url": "https://avatars.githubusercontent.com/u/81?v=4",
  "description": "",
  "events_url": "https://api.github.com/orgs/engineyard/events",
  "hooks_url": "https://api.github.com/orgs/engineyard/hooks",
  "id": "81",
  "issues_url": "https://api.github.com/orgs/engineyard/issues",
  "login": "engineyard",
  "members_url": "https://api.github.com/orgs/engineyard/members{/member}",
  "node_id": "MDEyOk9yZ2FuaXphdGlvbjgx",
  "public_members_url": "https://api.github.com/orgs/engineyard/public_members{/member}",
  "repos_url": "https://api.github.com/orgs/engineyard/repos",
  "url": "https://api.github.com/orgs/engineyard",
  "enterprise": "",
  "enterprise-team": "",
  "org": ""
}

columns (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

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

452 rows stored · 452 returned · page 1/19


1	0	https://avatars.githubusercontent.com/u/81?v=4	—	https://api.github.com/orgs/engineyard/events	https://api.github.com/orgs/engineyard/hooks	81	https://api.github.com/orgs/engineyard/issues	engineyard	https://api.github.com/orgs/engineyard/members{/member}	MDEyOk9yZ2FuaXphdGlvbjgx	https://api.github.com/orgs/engineyard/public_members{/member}	https://api.github.com/orgs/engineyard/repos	https://api.github.com/orgs/engineyard	—	—	—
2	1	https://avatars.githubusercontent.com/u/81?v=4	—	https://api.github.com/orgs/engineyard/events	https://api.github.com/orgs/engineyard/hooks	81	https://api.github.com/orgs/engineyard/issues	engineyard	https://api.github.com/orgs/engineyard/members{/member}	MDEyOk9yZ2FuaXphdGlvbjgx	https://api.github.com/orgs/engineyard/public_members{/member}	https://api.github.com/orgs/engineyard/repos	https://api.github.com/orgs/engineyard	—	—	—
1	2	https://avatars.githubusercontent.com/u/81?v=4	—	https://api.github.com/orgs/engineyard/events	https://api.github.com/orgs/engineyard/hooks	81	https://api.github.com/orgs/engineyard/issues	engineyard	https://api.github.com/orgs/engineyard/members{/member}	MDEyOk9yZ2FuaXphdGlvbjgx	https://api.github.com/orgs/engineyard/public_members{/member}	https://api.github.com/orgs/engineyard/repos	https://api.github.com/orgs/engineyard	—	—	—
1	3	https://avatars.githubusercontent.com/u/119?v=4	—	https://api.github.com/orgs/ministrycentered/events	https://api.github.com/orgs/ministrycentered/hooks	119	https://api.github.com/orgs/ministrycentered/issues	ministrycentered	https://api.github.com/orgs/ministrycentered/members{/member}	MDEyOk9yZ2FuaXphdGlvbjExOQ==	https://api.github.com/orgs/ministrycentered/public_members{/member}	https://api.github.com/orgs/ministrycentered/repos	https://api.github.com/orgs/ministrycentered	—	—	—
1	4	https://avatars.githubusercontent.com/u/128?v=4	We build software to solve real problems.	https://api.github.com/orgs/collectiveidea/events	https://api.github.com/orgs/collectiveidea/hooks	128	https://api.github.com/orgs/collectiveidea/issues	collectiveidea	https://api.github.com/orgs/collectiveidea/members{/member}	MDEyOk9yZ2FuaXphdGlvbjEyOA==	https://api.github.com/orgs/collectiveidea/public_members{/member}	https://api.github.com/orgs/collectiveidea/repos	https://api.github.com/orgs/collectiveidea	—	—	—
1	5	https://avatars.githubusercontent.com/u/144?v=4	—	https://api.github.com/orgs/ogc/events	https://api.github.com/orgs/ogc/hooks	144	https://api.github.com/orgs/ogc/issues	ogc	https://api.github.com/orgs/ogc/members{/member}	MDEyOk9yZ2FuaXphdGlvbjE0NA==	https://api.github.com/orgs/ogc/public_members{/member}	https://api.github.com/orgs/ogc/repos	https://api.github.com/orgs/ogc	—	—	—
1	6	https://avatars.githubusercontent.com/u/150?v=4	—	https://api.github.com/orgs/sevenwire/events	https://api.github.com/orgs/sevenwire/hooks	150	https://api.github.com/orgs/sevenwire/issues	sevenwire	https://api.github.com/orgs/sevenwire/members{/member}	MDEyOk9yZ2FuaXphdGlvbjE1MA==	https://api.github.com/orgs/sevenwire/public_members{/member}	https://api.github.com/orgs/sevenwire/repos	https://api.github.com/orgs/sevenwire	—	—	—
1	7	https://avatars.githubusercontent.com/u/167?v=4	—	https://api.github.com/orgs/entryway/events	https://api.github.com/orgs/entryway/hooks	167	https://api.github.com/orgs/entryway/issues	entryway	https://api.github.com/orgs/entryway/members{/member}	MDEyOk9yZ2FuaXphdGlvbjE2Nw==	https://api.github.com/orgs/entryway/public_members{/member}	https://api.github.com/orgs/entryway/repos	https://api.github.com/orgs/entryway	—	—	—
1	8	https://avatars.githubusercontent.com/u/264?v=4	—	https://api.github.com/orgs/merb/events	https://api.github.com/orgs/merb/hooks	264	https://api.github.com/orgs/merb/issues	merb	https://api.github.com/orgs/merb/members{/member}	MDEyOk9yZ2FuaXphdGlvbjI2NA==	https://api.github.com/orgs/merb/public_members{/member}	https://api.github.com/orgs/merb/repos	https://api.github.com/orgs/merb	—	—	—
1	9	https://avatars.githubusercontent.com/u/359?v=4	—	https://api.github.com/orgs/moneyspyder/events	https://api.github.com/orgs/moneyspyder/hooks	359	https://api.github.com/orgs/moneyspyder/issues	moneyspyder	https://api.github.com/orgs/moneyspyder/members{/member}	MDEyOk9yZ2FuaXphdGlvbjM1OQ==	https://api.github.com/orgs/moneyspyder/public_members{/member}	https://api.github.com/orgs/moneyspyder/repos	https://api.github.com/orgs/moneyspyder	—	—	—
1	10	https://avatars.githubusercontent.com/u/374?v=4	—	https://api.github.com/orgs/sproutit/events	https://api.github.com/orgs/sproutit/hooks	374	https://api.github.com/orgs/sproutit/issues	sproutit	https://api.github.com/orgs/sproutit/members{/member}	MDEyOk9yZ2FuaXphdGlvbjM3NA==	https://api.github.com/orgs/sproutit/public_members{/member}	https://api.github.com/orgs/sproutit/repos	https://api.github.com/orgs/sproutit	—	—	—
1	11	https://avatars.githubusercontent.com/u/489?v=4	—	https://api.github.com/orgs/wrenchlabs/events	https://api.github.com/orgs/wrenchlabs/hooks	489	https://api.github.com/orgs/wrenchlabs/issues	wrenchlabs	https://api.github.com/orgs/wrenchlabs/members{/member}	MDEyOk9yZ2FuaXphdGlvbjQ4OQ==	https://api.github.com/orgs/wrenchlabs/public_members{/member}	https://api.github.com/orgs/wrenchlabs/repos	https://api.github.com/orgs/wrenchlabs	—	—	—
1	12	https://avatars.githubusercontent.com/u/555?v=4	—	https://api.github.com/orgs/ipvideomarketinfo/events	https://api.github.com/orgs/ipvideomarketinfo/hooks	555	https://api.github.com/orgs/ipvideomarketinfo/issues	ipvideomarketinfo	https://api.github.com/orgs/ipvideomarketinfo/members{/member}	MDEyOk9yZ2FuaXphdGlvbjU1NQ==	https://api.github.com/orgs/ipvideomarketinfo/public_members{/member}	https://api.github.com/orgs/ipvideomarketinfo/repos	https://api.github.com/orgs/ipvideomarketinfo	—	—	—
1	13	https://avatars.githubusercontent.com/u/728?v=4	—	https://api.github.com/orgs/revelation/events	https://api.github.com/orgs/revelation/hooks	728	https://api.github.com/orgs/revelation/issues	revelation	https://api.github.com/orgs/revelation/members{/member}	MDEyOk9yZ2FuaXphdGlvbjcyOA==	https://api.github.com/orgs/revelation/public_members{/member}	https://api.github.com/orgs/revelation/repos	https://api.github.com/orgs/revelation	—	—	—
1	14	https://avatars.githubusercontent.com/u/1067?v=4	We're an agile team building new products for the web. And oh boy, we're kind o…	https://api.github.com/orgs/railslove/events	https://api.github.com/orgs/railslove/hooks	1067	https://api.github.com/orgs/railslove/issues	railslove	https://api.github.com/orgs/railslove/members{/member}	MDEyOk9yZ2FuaXphdGlvbjEwNjc=	https://api.github.com/orgs/railslove/public_members{/member}	https://api.github.com/orgs/railslove/repos	https://api.github.com/orgs/railslove	—	—	—
1	15	https://avatars.githubusercontent.com/u/1119?v=4	Leading Spree Commerce Integration Partner	https://api.github.com/orgs/railsdog/events	https://api.github.com/orgs/railsdog/hooks	1119	https://api.github.com/orgs/railsdog/issues	railsdog	https://api.github.com/orgs/railsdog/members{/member}	MDEyOk9yZ2FuaXphdGlvbjExMTk=	https://api.github.com/orgs/railsdog/public_members{/member}	https://api.github.com/orgs/railsdog/repos	https://api.github.com/orgs/railsdog	—	—	—
1	16	https://avatars.githubusercontent.com/u/1146?v=4	Building software for world changers	https://api.github.com/orgs/netguru/events	https://api.github.com/orgs/netguru/hooks	1146	https://api.github.com/orgs/netguru/issues	netguru	https://api.github.com/orgs/netguru/members{/member}	MDEyOk9yZ2FuaXphdGlvbjExNDY=	https://api.github.com/orgs/netguru/public_members{/member}	https://api.github.com/orgs/netguru/repos	https://api.github.com/orgs/netguru	—	—	—
1	17	https://avatars.githubusercontent.com/u/1190?v=4	—	https://api.github.com/orgs/animikii/events	https://api.github.com/orgs/animikii/hooks	1190	https://api.github.com/orgs/animikii/issues	animikii	https://api.github.com/orgs/animikii/members{/member}	MDEyOk9yZ2FuaXphdGlvbjExOTA=	https://api.github.com/orgs/animikii/public_members{/member}	https://api.github.com/orgs/animikii/repos	https://api.github.com/orgs/animikii	—	—	—
1	18	https://avatars.githubusercontent.com/u/1375?v=4	New home @coder	https://api.github.com/orgs/cdr/events	https://api.github.com/orgs/cdr/hooks	1375	https://api.github.com/orgs/cdr/issues	cdr	https://api.github.com/orgs/cdr/members{/member}	MDEyOk9yZ2FuaXphdGlvbjEzNzU=	https://api.github.com/orgs/cdr/public_members{/member}	https://api.github.com/orgs/cdr/repos	https://api.github.com/orgs/cdr	—	—	—
1	19	https://avatars.githubusercontent.com/u/1511?v=4	—	https://api.github.com/orgs/sauspiel/events	https://api.github.com/orgs/sauspiel/hooks	1511	https://api.github.com/orgs/sauspiel/issues	sauspiel	https://api.github.com/orgs/sauspiel/members{/member}	MDEyOk9yZ2FuaXphdGlvbjE1MTE=	https://api.github.com/orgs/sauspiel/public_members{/member}	https://api.github.com/orgs/sauspiel/repos	https://api.github.com/orgs/sauspiel	—	—	—
1	20	https://avatars.githubusercontent.com/u/1849?v=4	—	https://api.github.com/orgs/wherecloud/events	https://api.github.com/orgs/wherecloud/hooks	1849	https://api.github.com/orgs/wherecloud/issues	wherecloud	https://api.github.com/orgs/wherecloud/members{/member}	MDEyOk9yZ2FuaXphdGlvbjE4NDk=	https://api.github.com/orgs/wherecloud/public_members{/member}	https://api.github.com/orgs/wherecloud/repos	https://api.github.com/orgs/wherecloud	—	—	—
1	21	https://avatars.githubusercontent.com/u/1964?v=4	Makers of high performance web applications.	https://api.github.com/orgs/lincolnloop/events	https://api.github.com/orgs/lincolnloop/hooks	1964	https://api.github.com/orgs/lincolnloop/issues	lincolnloop	https://api.github.com/orgs/lincolnloop/members{/member}	MDEyOk9yZ2FuaXphdGlvbjE5NjQ=	https://api.github.com/orgs/lincolnloop/public_members{/member}	https://api.github.com/orgs/lincolnloop/repos	https://api.github.com/orgs/lincolnloop	—	—	—
1	22	https://avatars.githubusercontent.com/u/2084?v=4	—	https://api.github.com/orgs/notch8-old/events	https://api.github.com/orgs/notch8-old/hooks	2084	https://api.github.com/orgs/notch8-old/issues	notch8-old	https://api.github.com/orgs/notch8-old/members{/member}	MDEyOk9yZ2FuaXphdGlvbjIwODQ=	https://api.github.com/orgs/notch8-old/public_members{/member}	https://api.github.com/orgs/notch8-old/repos	https://api.github.com/orgs/notch8-old	—	—	—
1	23	https://avatars.githubusercontent.com/u/2309?v=4	—	https://api.github.com/orgs/edgecase/events	https://api.github.com/orgs/edgecase/hooks	2309	https://api.github.com/orgs/edgecase/issues	edgecase	https://api.github.com/orgs/edgecase/members{/member}	MDEyOk9yZ2FuaXphdGlvbjIzMDk=	https://api.github.com/orgs/edgecase/public_members{/member}	https://api.github.com/orgs/edgecase/repos	https://api.github.com/orgs/edgecase	—	—	—
1	24	https://avatars.githubusercontent.com/u/2548?v=4	—	https://api.github.com/orgs/galaxycats/events	https://api.github.com/orgs/galaxycats/hooks	2548	https://api.github.com/orgs/galaxycats/issues	galaxycats	https://api.github.com/orgs/galaxycats/members{/member}	MDEyOk9yZ2FuaXphdGlvbjI1NDg=	https://api.github.com/orgs/galaxycats/public_members{/member}	https://api.github.com/orgs/galaxycats/repos	https://api.github.com/orgs/galaxycats	—	—	—

Column profile

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

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	avatar_url	string	6	0	`"https://avatars.githubusercontent.com/u/81?v=4"`
2	description	—	0	6	empty
3	events_url	string	6	0	`"https://api.github.com/orgs/engineyard/events"`
4	hooks_url	string	6	0	`"https://api.github.com/orgs/engineyard/hooks"`
5	id	string	6	0	`"81"`
6	issues_url	string	6	0	`"https://api.github.com/orgs/engineyard/issues"`
7	login	string	6	0	`"engineyard"`
8	members_url	string	6	0	`"https://api.github.com/orgs/engineyard/members{/member}"`
9	node_id	string	6	0	`"MDEyOk9yZ2FuaXphdGlvbjgx"`
10	public_members_url	string	6	0	`"https://api.github.com/orgs/engineyard/public_members{/membe"`
11	repos_url	string	6	0	`"https://api.github.com/orgs/engineyard/repos"`
12	url	string	6	0	`"https://api.github.com/orgs/engineyard"`
13	enterprise	—	0	6	empty
14	enterprise-team	—	0	6	empty
15	org	—	0	6	empty

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	36744ms	1	ok	avatar_url, description, events_url
minimal	t2	37939ms	1	ok	avatar_url, description, events_url
realistic	t1	34502ms	25	ok	avatar_url, description, events_url
realistic	t2	33554ms	25	ok	avatar_url, description, events_url
edge	t1	45945ms	200	ok	avatar_url, description, events_url
edge	t2	37903ms	200	ok	avatar_url, description, events_url

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Works without WHERE filters. Most useful optional filters: org, enterprise, enterprise-team. Use LIMIT for spot checks; large result sets paginate quickly.

Columns coral returned (15)

avatar_urldescriptionevents_urlhooks_urlidissues_urlloginmembers_urlnode_idpublic_members_urlrepos_urlurlenterpriseenterprise-teamorg

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T07:27:47Z

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

first_run_at: 2026-08-31T07:27:47Z

last_retried_at: 2026-08-31T07:27:47Z

retry_count: 0

View version history →