steampipe plugin install github

Table: github_user - Query GitHub Users using SQL

GitHub Users is a resource within GitHub that represents an individual user account on GitHub. It provides information about the user's public profile, such as the user's username, bio, location, email, and the date the user joined GitHub. GitHub Users also include statistics about the user's activities and contributions to GitHub repositories.

Table Usage Guide

The github_user table provides insights into individual user accounts within GitHub. As a developer or project manager, explore user-specific details through this table, including user profiles, activities, and contributions. Utilize it to uncover information about users, such as their public profiles, the date they joined GitHub, and their contributions to repositories.

Important Notes

  • You must specify the login column in where or join clause to query the table.

Examples

Get information for a user

Explore the details associated with a specific GitHub user to gain insights into their activity and profile. This can be useful for understanding their contributions or for investigating user behavior.

select
*
from
github_user
where
login = 'torvalds';
select
*
from
github_user
where
login = 'torvalds';

List users that are members of multiple organizations

select
name,
email,
created_at,
bio,
twitter_username,
organizations_total_count
from
github_user
where
login = 'madhushreeray30'
and organizations_total_count > 1;
select
name,
email,
created_at,
bio,
twitter_username,
organizations_total_count
from
github_user
where
login = 'madhushreeray30'
and organizations_total_count > 1;

Schema for github_user

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
any_pinnable_itemsbooleanIf true, user has pinnable items.
avatar_urltextThe URL of the user's avatar.
biotextThe biography of the user.
can_changed_pinned_itemsbooleanIf true, you can change the pinned items for this user.
can_create_projectsbooleanIf true, you can create projects for this user.
can_followbooleanIf true, you can follow this user.
can_sponsorbooleanIf true, you can sponsor this user.
closed_pull_requests_total_countbigintCount of closed pull requests associated with the user.
companytextThe company on the users profile.
created_attimestamp with time zoneTimestamp when user was created.
emailtextThe email of the user.
estimated_next_sponsors_payout_in_centsbigintThe estimated next GitHub sponsors payout for this user in cents (USD).
followers_total_countbigintCount of how many users this user follows.
following_total_countbigintCount of how many users follow this user.
has_sponsors_listingbooleanIf true, user has a GitHub sponsors listing.
idbigintThe ID of the user.
interaction_abilityjsonbThe interaction ability settings for this user.
is_bounty_hunterbooleanIf true, user is a participant in the GitHub security bug bounty.
is_campus_expertbooleanIf true, user is a participant in the GitHub campus experts program.
is_developer_program_memberbooleanIf true, user is a GitHub developer program member.
is_employeebooleanIf true, user is a GitHub employee.
is_followingbooleanIf true, you are following this user.
is_following_youbooleanIf true, user follows you.
is_github_starbooleanIf true, user is a member of the GitHub Stars Program.
is_hireablebooleanIf true, user has marked themselves as for hire.
is_site_adminbooleanIf true, user is a site administrator.
is_sponsoringbooleanIf true, you are sponsoring this user.
is_sponsoring_youbooleanIf true, this user is sponsoring you.
is_youbooleanIf true, user is you.
issues_total_countbigintCount of issues associated with the user.
locationtextThe location of the user.
logintext=The login name of the user.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
merged_pull_requests_total_countbigintCount of merged pull requests associated with the user.
monthly_estimated_sponsors_income_in_centsbigintThe estimated monthly GitHub sponsors income for this user in cents (USD).
nametextThe name of the user.
node_idtextThe node ID of the user.
open_pull_requests_total_countbigintCount of open pull requests associated with the user.
organizations_total_countbigintCount of organizations the user belongs to.
packages_total_countbigintCount of packages hosted by the user.
pinned_items_remainingbigintHow many more items this user can pin to their profile.
pinned_items_total_countbigintCount of items pinned on the users profile.
private_repositories_total_countbigintCount of private repositories for the user.
projects_urltextThe URL listing user's projects.
pronounstextThe user's pronouns.
public_gists_total_countbigintCount of public gists for the user.
public_keys_total_countbigintCount of public keys associated with the user.
public_repositories_total_countbigintCount of public repositories for the user.
repositories_total_disk_usagebigintTotal disk spaced used by the users repositories.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sponsoring_total_countbigintCount of users that this user is sponsoring.
sponsors_listingjsonbThe GitHub sponsors listing for this user.
sponsors_total_countbigintCount of users sponsoring this user.
starred_repositories_total_countbigintCount of repositories the user has starred.
statusjsonbThe user's status.
twitter_usernametextTwitter username of the user.
updated_attimestamp with time zoneTimestamp when user was last updated.
urltextThe URL of the user's GitHub page.
watching_total_countbigintCount of repositories being watched by the user.
website_urltextThe URL pointing to the user's public website/blog.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- github

You can pass the configuration to the command with the --config argument:

steampipe_export_github --config '<your_config>' github_user