turbot/github

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

Table: github_user

The github_user table does not list all users via the API - there is not currently an efficient way to limit the results in a useable way. As a result, you must specify a user login in a where or you will get no results.

Examples

Get information for a user

select
*
from
github_user
where
login = 'torvalds';

List of users in your organizations

select
u.login,
o.login as organization,
u.name,
u.company,
u.location,
u.twitter_username,
u.bio
from
github_user as u,
github_my_organization as o,
jsonb_array_elements_text(o.member_logins) as member_login
where
u.login = member_login;

List of users that collaborate on a repository that you own

select
r.full_name as repository,
u.login,
u.name,
u.company,
u.location,
u.twitter_username,
u.bio
from
github_user as u,
github_my_repository as r,
jsonb_array_elements_text(r.collaborator_logins) as collaborator_login
where
u.login = collaborator_login
and r.full_name = 'turbot/steampipe';

.inspect github_user

GitHub Users are user accounts in GitHub.

NameTypeDescription
avatar_urltextThe URL of the user's avatar
biotextThe biography of the user.
blogtextThe blog address of the user.
collaboratorsbigintThe number of collaborators.
companytextThe company the user works for.
created_attimestamp without time zoneThe timestamp when the user was created.
disk_usagebigintThe total disk usage for the user.
emailtextThe public email address of the user.
followersbigintThe number of users following the user.
followingbigintThe number of users followed by the user.
gravatar_idtextThe user's gravatar ID
hireablebooleanWhether the user currently hireable.
html_urltextThe GitHub page for the user.
idbigintThe ID of the user.
ldap_dntextThe LDAP distinguished name of the user.
locationtextThe geographic location of the user.
logintextThe login name of the user.
nametextThe name of the user.
node_idtextThe node ID of the user.
owned_private_reposbigintThe number of owned private repositories.
private_gistsbigintThe number of private gists owned by the user.
public_gistsbigintThe number of public gists owned by the user.
public_reposbigintThe number of public repositories owned by the user.
site_adminbooleanIf true, user is an administrator.
total_private_reposbigintThe number of private repositories.
twitter_usernametextThe twitter username of the user.
two_factor_authenticationbooleanIf true, two-factor authentication is enabled.
typetextThe type of account.
updated_attimestamp without time zoneThe timestamp when the user was last updated.