turbot/github

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

Table: github_my_organization

Organizations are shared accounts where businesses and open-source projects can collaborate across many projects at once. Owners and administrators can manage member access to the organization's data and projects with sophisticated security and administrative features.

The github_my_organization table will list the organization that you are a member of. To view details of ANY organization, use the github_organization table.

Examples

Basic info for the GitHub Organizations to which you belong

select
login as organization,
name,
twitter_username,
total_private_repos,
public_repos,
plan_name,
plan_seats,
plan_filled_seats
from
github_my_organization;

Show members of an organization

select
login as organization,
name,
m ->> 'login' as member_login,
m ->> 'type' as member_type
from
github_my_organization,
jsonb_array_elements(members) as m
where
login = 'turbot';

Show Organization security settings

select
login as organization,
jsonb_array_length(members) as num_members,
members_allowed_repository_creation_type,
members_can_create_internal_repos,
members_can_create_pages,
members_can_create_private_repos,
members_can_create_public_repos,
members_can_create_repos,
default_repo_permission,
two_factor_requirement_enabled
from
github_my_organization;

Show collaborators in your organization's repositories that are not members of the organization

select
r.name,
collaborator_login
from
github_my_repository as r,
jsonb_array_elements_text(r.collaborator_logins) as collaborator_login,
github_my_organization as o
where
r.owner_login = o.login
and collaborator_login not in (
select m from github_my_organization, jsonb_array_elements_text(member_logins) as m
) ;

.inspect github_my_organization

GitHub Organizations that you are a member of. GitHub Organizations are shared accounts where businesses and open-source projects can collaborate across many projects at once.

NameTypeDescription
avatar_urltextThe URL of the organization's avatar.
billing_emailtextThe email address for billing.
blogtextThe URL of the organizations blog.
collaboratorsbigintThe number of collaborators for the organization.
companytextThe name of the associated company.
created_attimestamp without time zoneThe timestamp when the organization was created.
default_repo_permissiontextThe default repository permissions for the organization.
descriptiontextThe organization description.
disk_usagebigintThe total disk usage for the organization.
emailtextThe email address associated with the organization.
events_urltextThe API Events URL.
followersbigintThe number of users following the organization.
followingbigintThe number of users followed by the organization.
has_organization_projectsbooleanIf true, the organization can use organization projects.
has_repository_projectsbooleanIf true, the organization can use repository projects.
hooks_urltextThe API Hooks URL.
html_urltextThe address for the organization's GitHub web page.
idbigintThe unique ID number of the organization.
is_verifiedbooleanIf true, the organization has been verified with domain verification.
issues_urltextThe API Issues URL.
locationtextThe geographical location.
logintextThe login name of the organization.
member_loginsjsonbAn array of user logins that are members of the organization.
membersjsonbAn array of users that are members of the organization.
members_allowed_repository_creation_typetextSpecifies which types of repositories non-admin organization members can create
members_can_create_internal_reposbooleanIf true, members can create internal repositories.
members_can_create_pagesbooleanIf true, members can create pages.
members_can_create_private_reposbooleanIf true, members can create private repositories.
members_can_create_public_reposbooleanIf true, members can create public repositories.
members_can_create_reposbooleanIf true, members can create repositories.
members_urltextThe API Members URL.
nametextThe organization name.
node_idtextThe node id of the organization.
owned_private_reposbigintThe number of owned private repositories.
plan_filled_seatsbigintThe number of used seats for the plan.
plan_nametextThe name of the GitHub plan.
plan_private_reposbigintThe number of private repositories for the plan.
plan_seatsbigintThe number of available seats for the plan
plan_spacebigintThe total space allocated for the plan.
private_gistsbigintThe number of private gists.
public_gistsbigintThe number of public gists.
public_members_urltextThe API Public Members URL.
public_reposbigintThe number of public repositories.
repos_urltextThe API Repos URL.
total_private_reposbigintThe number of private repositories.
twitter_usernametextThe organizations twitter handle.
two_factor_requirement_enabledbooleanIf true, all members in the organization must have two factor authentication enabled.
typetextThe user type of the organization.
updated_attimestamp without time zoneThe timestamp when the organization was last updated.
urltextThe API URL of the organization.