turbot/github

steampipe plugin install githubsteampipe plugin install github
On This Page
Get Involved

Table: github_license

GitHub allows you to associate a license with your repository. The github_license table lists information about the available licenses.

Examples

List basic license info

select
spdx_id,
name,
description
from
github_license;

View license permissions

select
name,
jsonb_pretty(permissions)
from
github_license;

Count your repositories by license

select
l.name,
count(r.license_key) as num_repos
from
github_license as l
left join github_my_repository as r on l.key = r.license_key
group by
l.name
order by
num_repos desc;

.inspect github_license

GitHub Licenses are common software licenses that you can associate with your repository.

NameTypeDescription
conditionsjsonbAn array of license conditions (include-copyright,disclose-source, etc).
descriptiontextThe license description.
featuredbooleanIf true, the license is 'featured' in the GitHub UI.
html_urltextThe HTML URL of the license.
implementationtextImplementation instructions for the license.
keytextThe unique key of the license.
limitationsjsonbAn array of limitations for the license (trademark-use, liability,warranty, etc).
nametextThe name of the license.
permissionsjsonbAn array of permissions for the license (private-use, commercial-use,modifications, etc).
spdx_idtextThe Software Package Data Exchange (SPDX) id of the license.
urltextThe API url of the license.