`github.licenses`

partial

Get all commonly used licenses

Works without WHERE filters. Most useful optional filters: featured, license. Use LIMIT for spot checks; large result sets paginate quickly.

no filters captured 2026-08-31 06:31:36Zmedian 41124 ms

Verdict: PARTIAL

1 errors across trials but 3 variants returned data.

What to do

Some variants failed

partial

Investigate which variants returned empty rows and which errored. The failing variant often has the missing filter shape.

Re-probe with smaller LIMIT to isolate the failing variant.

Unrecognized error

unknown

Inspect the raw error and add a rule to scripts/analyze_failures.py.

View the error under Probe variants → first trial → error block.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts	Errors
minimal	2	48317 ms	48317 ms	48317 ms	[1, 0]	1
realistic	2	29816 ms	41124 ms	52433 ms	[13, 13]	0
edge	2	39260 ms	40959 ms	42658 ms	[13, 13]	0

Latency per trial

minimalmedian 48317ms

scale: 0–48317 ms

realisticmedian 41124ms

scale: 0–52433 ms

edgemedian 40959ms

scale: 0–42658 ms

Probe variants — every command + output

minimal2 trials

min 48317ms · median 48317ms · max 48317ms · rows 1,0

smallest valid query (no filters)

Command

SELECT * FROM github.licenses LIMIT 1

Trials + output

trial 1·48317ms·rows 1isError=false

First row (click to expand JSON)

{
  "body": "",
  "conditions": "",
  "description": "",
  "featured": "",
  "html_url": "",
  "implementation": "",
  "key": "agpl-3.0",
  "license": "",
  "limitations": "",
  "name": "GNU Affero General Public License v3.0",
  "node_id": "MDc6TGljZW5zZTE=",
  "permissions": "",
  "spdx_id": "AGPL-3.0",
  "url": "https://api.github.com/licenses/agpl-3.0"
}

columns (14)

bodyconditionsdescriptionfeaturedhtml_urlimplementationkeylicenselimitationsnamenode_idpermissionsspdx_idurl

trial 2·-1ms·rows 0isError=true

Error

timeout

realistic2 trials

min 29816ms · median 41124ms · max 52433ms · rows 13,13

typical user query (no filters)

Command

SELECT * FROM github.licenses LIMIT 25

Trials + output

trial 1·29816ms·rows 13isError=false

First row (click to expand JSON)

{
  "body": "",
  "conditions": "",
  "description": "",
  "featured": "",
  "html_url": "",
  "implementation": "",
  "key": "agpl-3.0",
  "license": "",
  "limitations": "",
  "name": "GNU Affero General Public License v3.0",
  "node_id": "MDc6TGljZW5zZTE=",
  "permissions": "",
  "spdx_id": "AGPL-3.0",
  "url": "https://api.github.com/licenses/agpl-3.0"
}

columns (14)

bodyconditionsdescriptionfeaturedhtml_urlimplementationkeylicenselimitationsnamenode_idpermissionsspdx_idurl

trial 2·52433ms·rows 13isError=false

First row (click to expand JSON)

{
  "body": "",
  "conditions": "",
  "description": "",
  "featured": "",
  "html_url": "",
  "implementation": "",
  "key": "agpl-3.0",
  "license": "",
  "limitations": "",
  "name": "GNU Affero General Public License v3.0",
  "node_id": "MDc6TGljZW5zZTE=",
  "permissions": "",
  "spdx_id": "AGPL-3.0",
  "url": "https://api.github.com/licenses/agpl-3.0"
}

columns (14)

bodyconditionsdescriptionfeaturedhtml_urlimplementationkeylicenselimitationsnamenode_idpermissionsspdx_idurl

edge2 trials

min 39260ms · median 40959ms · max 42658ms · rows 13,13

edge: larger limit, no filters

Command

SELECT * FROM github.licenses LIMIT 200

Trials + output

trial 1·42658ms·rows 13isError=false

First row (click to expand JSON)

{
  "body": "",
  "conditions": "",
  "description": "",
  "featured": "",
  "html_url": "",
  "implementation": "",
  "key": "agpl-3.0",
  "license": "",
  "limitations": "",
  "name": "GNU Affero General Public License v3.0",
  "node_id": "MDc6TGljZW5zZTE=",
  "permissions": "",
  "spdx_id": "AGPL-3.0",
  "url": "https://api.github.com/licenses/agpl-3.0"
}

columns (14)

bodyconditionsdescriptionfeaturedhtml_urlimplementationkeylicenselimitationsnamenode_idpermissionsspdx_idurl

trial 2·39260ms·rows 13isError=false

First row (click to expand JSON)

{
  "body": "",
  "conditions": "",
  "description": "",
  "featured": "",
  "html_url": "",
  "implementation": "",
  "key": "agpl-3.0",
  "license": "",
  "limitations": "",
  "name": "GNU Affero General Public License v3.0",
  "node_id": "MDc6TGljZW5zZTE=",
  "permissions": "",
  "spdx_id": "AGPL-3.0",
  "url": "https://api.github.com/licenses/agpl-3.0"
}

columns (14)

bodyconditionsdescriptionfeaturedhtml_urlimplementationkeylicenselimitationsnamenode_idpermissionsspdx_idurl

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

53 rows stored · 53 returned · page 1/3


1	0	—	—	—	—	—	—	agpl-3.0	—	—	GNU Affero General Public License v3.0	MDc6TGljZW5zZTE=	—	AGPL-3.0	https://api.github.com/licenses/agpl-3.0
1	1	—	—	—	—	—	—	agpl-3.0	—	—	GNU Affero General Public License v3.0	MDc6TGljZW5zZTE=	—	AGPL-3.0	https://api.github.com/licenses/agpl-3.0
1	2	—	—	—	—	—	—	apache-2.0	—	—	Apache License 2.0	MDc6TGljZW5zZTI=	—	Apache-2.0	https://api.github.com/licenses/apache-2.0
1	3	—	—	—	—	—	—	bsd-2-clause	—	—	BSD 2-Clause "Simplified" License	MDc6TGljZW5zZTQ=	—	BSD-2-Clause	https://api.github.com/licenses/bsd-2-clause
1	4	—	—	—	—	—	—	bsd-3-clause	—	—	BSD 3-Clause "New" or "Revised" License	MDc6TGljZW5zZTU=	—	BSD-3-Clause	https://api.github.com/licenses/bsd-3-clause
1	5	—	—	—	—	—	—	bsl-1.0	—	—	Boost Software License 1.0	MDc6TGljZW5zZTI4	—	BSL-1.0	https://api.github.com/licenses/bsl-1.0
1	6	—	—	—	—	—	—	cc0-1.0	—	—	Creative Commons Zero v1.0 Universal	MDc6TGljZW5zZTY=	—	CC0-1.0	https://api.github.com/licenses/cc0-1.0
1	7	—	—	—	—	—	—	epl-2.0	—	—	Eclipse Public License 2.0	MDc6TGljZW5zZTMy	—	EPL-2.0	https://api.github.com/licenses/epl-2.0
1	8	—	—	—	—	—	—	gpl-2.0	—	—	GNU General Public License v2.0	MDc6TGljZW5zZTg=	—	GPL-2.0	https://api.github.com/licenses/gpl-2.0
1	9	—	—	—	—	—	—	gpl-3.0	—	—	GNU General Public License v3.0	MDc6TGljZW5zZTk=	—	GPL-3.0	https://api.github.com/licenses/gpl-3.0
1	10	—	—	—	—	—	—	lgpl-2.1	—	—	GNU Lesser General Public License v2.1	MDc6TGljZW5zZTEx	—	LGPL-2.1	https://api.github.com/licenses/lgpl-2.1
1	11	—	—	—	—	—	—	mit	—	—	MIT License	MDc6TGljZW5zZTEz	—	MIT	https://api.github.com/licenses/mit
1	12	—	—	—	—	—	—	mpl-2.0	—	—	Mozilla Public License 2.0	MDc6TGljZW5zZTE0	—	MPL-2.0	https://api.github.com/licenses/mpl-2.0
1	13	—	—	—	—	—	—	unlicense	—	—	The Unlicense	MDc6TGljZW5zZTE1	—	Unlicense	https://api.github.com/licenses/unlicense
2	14	—	—	—	—	—	—	agpl-3.0	—	—	GNU Affero General Public License v3.0	MDc6TGljZW5zZTE=	—	AGPL-3.0	https://api.github.com/licenses/agpl-3.0
2	15	—	—	—	—	—	—	apache-2.0	—	—	Apache License 2.0	MDc6TGljZW5zZTI=	—	Apache-2.0	https://api.github.com/licenses/apache-2.0
2	16	—	—	—	—	—	—	bsd-2-clause	—	—	BSD 2-Clause "Simplified" License	MDc6TGljZW5zZTQ=	—	BSD-2-Clause	https://api.github.com/licenses/bsd-2-clause
2	17	—	—	—	—	—	—	bsd-3-clause	—	—	BSD 3-Clause "New" or "Revised" License	MDc6TGljZW5zZTU=	—	BSD-3-Clause	https://api.github.com/licenses/bsd-3-clause
2	18	—	—	—	—	—	—	bsl-1.0	—	—	Boost Software License 1.0	MDc6TGljZW5zZTI4	—	BSL-1.0	https://api.github.com/licenses/bsl-1.0
2	19	—	—	—	—	—	—	cc0-1.0	—	—	Creative Commons Zero v1.0 Universal	MDc6TGljZW5zZTY=	—	CC0-1.0	https://api.github.com/licenses/cc0-1.0
2	20	—	—	—	—	—	—	epl-2.0	—	—	Eclipse Public License 2.0	MDc6TGljZW5zZTMy	—	EPL-2.0	https://api.github.com/licenses/epl-2.0
2	21	—	—	—	—	—	—	gpl-2.0	—	—	GNU General Public License v2.0	MDc6TGljZW5zZTg=	—	GPL-2.0	https://api.github.com/licenses/gpl-2.0
2	22	—	—	—	—	—	—	gpl-3.0	—	—	GNU General Public License v3.0	MDc6TGljZW5zZTk=	—	GPL-3.0	https://api.github.com/licenses/gpl-3.0
2	23	—	—	—	—	—	—	lgpl-2.1	—	—	GNU Lesser General Public License v2.1	MDc6TGljZW5zZTEx	—	LGPL-2.1	https://api.github.com/licenses/lgpl-2.1
2	24	—	—	—	—	—	—	mit	—	—	MIT License	MDc6TGljZW5zZTEz	—	MIT	https://api.github.com/licenses/mit

Column profile

14 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	body	—	0	5	empty
2	conditions	—	0	5	empty
3	description	—	0	5	empty
4	featured	—	0	5	empty
5	html_url	—	0	5	empty
6	implementation	—	0	5	empty
7	key	string	5	0	`"agpl-3.0"`
8	license	—	0	5	empty
9	limitations	—	0	5	empty
10	name	string	5	0	`"GNU Affero General Public License v3.0"`
11	node_id	string	5	0	`"MDc6TGljZW5zZTE="`
12	permissions	—	0	5	empty
13	spdx_id	string	5	0	`"AGPL-3.0"`
14	url	string	5	0	`"https://api.github.com/licenses/agpl-3.0"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	48317ms	1	ok	body, conditions, description
minimal	t2	-1ms	0	error	—
realistic	t1	29816ms	13	ok	body, conditions, description
realistic	t2	52433ms	13	ok	body, conditions, description
edge	t1	42658ms	13	ok	body, conditions, description
edge	t2	39260ms	13	ok	body, conditions, description

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Works without WHERE filters. Most useful optional filters: featured, license. Use LIMIT for spot checks; large result sets paginate quickly.

Columns coral returned (14)

bodyconditionsdescriptionfeaturedhtml_urlimplementationkeylicenselimitationsnamenode_idpermissionsspdx_idurl

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

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

first_run_at: 2026-08-31T06:31:36Z

last_retried_at: 2026-08-31T06:31:36Z

retry_count: 0

View version history →