turbot/github

GitHub
steampipe plugin install githubsteampipe plugin install github

Table: github_my_gist

GitHub Gist is a simple way to share snippets and pastes with others. The github_my_gist table will list only gists that you own.

To query ANY gist that you have access to (including any public gists), use the github_gist table.

Examples

List your gists

select
*
from
github_my_gist;

List your public gists

select
*
from
github_my_gist
where
public;

Summarize your gists by language.

select
file ->> 'language' as language,
count(*)
from
github_my_gist g
cross join jsonb_array_elements(g.files) file
group by
language
order by
count desc

.inspect github_my_gist

GitHub Gists owned by you. GitHub Gist is a simple way to share snippets and pastes with others.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
commentsbigintThe number of comments for the gist.
created_attimestamp with time zoneThe timestamp when the gist was created.
descriptiontextThe gist description.
filesjsonbFiles in the gist.
git_pull_urltextThe https url to pull or clone the gist.
git_push_urltextThe https url to push the gist.
html_urltextThe HTML URL of the gist.
idtextThe unique id of the gist.
node_idtextThe Node ID of the gist.
owner_idbigintThe user id (number) of the gist owner.
owner_logintextThe user login name of the gist owner.
owner_typetextThe type of the gist owner (User or Organization).
publicbooleanIf true, the gist is public, otherwise it is private.
updated_attimestamp with time zoneThe timestamp when the gist was last updated.