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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
any_pinnable_items	boolean		If true, user has pinnable items.
avatar_url	text		The URL of the user's avatar.
bio	text		The biography of the user.
can_changed_pinned_items	boolean		If true, you can change the pinned items for this user.
can_create_projects	boolean		If true, you can create projects for this user.
can_follow	boolean		If true, you can follow this user.
can_sponsor	boolean		If true, you can sponsor this user.
closed_pull_requests_total_count	bigint		Count of closed pull requests associated with the user.
company	text		The company on the users profile.
created_at	timestamp with time zone		Timestamp when user was created.
email	text		The email of the user.
estimated_next_sponsors_payout_in_cents	bigint		The estimated next GitHub sponsors payout for this user in cents (USD).
followers_total_count	bigint		Count of how many users this user follows.
following_total_count	bigint		Count of how many users follow this user.
has_sponsors_listing	boolean		If true, user has a GitHub sponsors listing.
id	bigint		The ID of the user.
interaction_ability	jsonb		The interaction ability settings for this user.
is_bounty_hunter	boolean		If true, user is a participant in the GitHub security bug bounty.
is_campus_expert	boolean		If true, user is a participant in the GitHub campus experts program.
is_developer_program_member	boolean		If true, user is a GitHub developer program member.
is_employee	boolean		If true, user is a GitHub employee.
is_following	boolean		If true, you are following this user.
is_following_you	boolean		If true, user follows you.
is_github_star	boolean		If true, user is a member of the GitHub Stars Program.
is_hireable	boolean		If true, user has marked themselves as for hire.
is_site_admin	boolean		If true, user is a site administrator.
is_sponsoring	boolean		If true, you are sponsoring this user.
is_sponsoring_you	boolean		If true, this user is sponsoring you.
is_you	boolean		If true, user is you.
issues_total_count	bigint		Count of issues associated with the user.
location	text		The location of the user.
login	text	=	The login name of the user.
login_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the user login.
merged_pull_requests_total_count	bigint		Count of merged pull requests associated with the user.
monthly_estimated_sponsors_income_in_cents	bigint		The estimated monthly GitHub sponsors income for this user in cents (USD).
name	text		The name of the user.
node_id	text		The node ID of the user.
open_pull_requests_total_count	bigint		Count of open pull requests associated with the user.
organizations_total_count	bigint		Count of organizations the user belongs to.
packages_total_count	bigint		Count of packages hosted by the user.
pinned_items_remaining	bigint		How many more items this user can pin to their profile.
pinned_items_total_count	bigint		Count of items pinned on the users profile.
private_repositories_total_count	bigint		Count of private repositories for the user.
projects_url	text		The URL listing user's projects.
pronouns	text		The user's pronouns.
public_gists_total_count	bigint		Count of public gists for the user.
public_keys_total_count	bigint		Count of public keys associated with the user.
public_repositories_total_count	bigint		Count of public repositories for the user.
repositories_total_disk_usage	bigint		Total disk spaced used by the users repositories.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
sponsoring_total_count	bigint		Count of users that this user is sponsoring.
sponsors_listing	jsonb		The GitHub sponsors listing for this user.
sponsors_total_count	bigint		Count of users sponsoring this user.
starred_repositories_total_count	bigint		Count of repositories the user has starred.
status	jsonb		The user's status.
twitter_username	text		Twitter username of the user.
updated_at	timestamp with time zone		Timestamp when user was last updated.
url	text		The URL of the user's GitHub page.
watching_total_count	bigint		Count of repositories being watched by the user.
website_url	text		The 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