steampipe plugin install github

Table: github_team_member - Query GitHub Team Members using SQL

GitHub Team Members are part of GitHub's Team feature which allows users to organize and manage user groups within a repository. These Team Members can be assigned different roles and permissions within the team. This feature is part of GitHub's collaboration tools designed to facilitate project management and team coordination.

Table Usage Guide

The github_team_member table provides insights into team members within GitHub. As a project manager or team lead, explore team member-specific details through this table, including their roles and permissions within teams. Utilize it to manage and coordinate your team effectively, ensuring that each team member has the appropriate permissions and roles for their tasks.

Important Notes

  • You must specify the organization and slug columns in the where or join clause to query the table.

Examples

List team members for a specific team

Explore which team members belong to a specific team in your organization. This is useful for understanding team composition and roles within your organization.

select
organization,
slug as team_slug,
login,
role,
status
from
github_team_member
where
organization = 'my_org'
and slug = 'my-team';
select
organization,
slug as team_slug,
login,
role,
status
from
github_team_member
where
organization = 'my_org'
and slug = 'my-team';

List active team members with maintainer role for a specific team

This query helps to identify active team members who hold the 'Maintainer' role within a specific team in your organization. It is useful for managing team roles and ensuring that every team has an active maintainer.

select
organization,
slug as team_slug,
login,
role,
status
from
github_team_member
where
organization = 'my_org'
and slug = 'my-team'
and role = 'MAINTAINER';
select
organization,
slug as team_slug,
login,
role,
status
from
github_team_member
where
organization = 'my_org'
and slug = 'my-team'
and role = 'MAINTAINER';

List team members with maintainer role for visible teams

Discover the segments that consist of team members with a maintainer role in visible teams. This can be useful for understanding the distribution of roles within your organization's teams, particularly in identifying those who have the authority to manage team settings.

select
t.organization as organization,
t.name as team_name,
t.slug as team_slug,
t.privacy as team_privacy,
t.description as team_description,
tm.login as member_login,
tm.role as member_role,
tm.status as member_status
from
github_team as t,
github_team_member as tm
where
t.organization = tm.organization
and t.slug = tm.slug
and tm.role = 'MAINTAINER';
select
t.organization as organization,
t.name as team_name,
t.slug as team_slug,
t.privacy as team_privacy,
t.description as team_description,
tm.login as member_login,
tm.role as member_role,
tm.status as member_status
from
github_team as t
join github_team_member as tm on t.organization = tm.organization
and t.slug = tm.slug
where
tm.role = 'MAINTAINER';

Schema for github_team_member

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.
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).
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.
locationtextThe location of the user.
logintextThe login name of the user.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
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.
organizationtext=The organization the team is associated with.
pinned_items_remainingbigintHow many more items this user can pin to their profile.
projects_urltextThe URL listing user's projects.
pronounstextThe user's pronouns.
roletext=The team member's role (MEMBER, MAINTAINER).
slugtext=The team slug name.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sponsors_listingjsonbThe GitHub sponsors listing for this user.
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.
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_team_member