github_actions_artifactgithub_actions_repository_runnergithub_actions_repository_secretgithub_actions_repository_workflow_rungithub_audit_loggithub_branchgithub_branch_protectiongithub_code_ownergithub_commitgithub_community_profilegithub_gistgithub_gitignoregithub_issuegithub_issue_commentgithub_licensegithub_my_gistgithub_my_issuegithub_my_organizationgithub_my_repositorygithub_my_stargithub_my_teamgithub_organizationgithub_organization_dependabot_alertgithub_organization_external_identitygithub_organization_membergithub_pull_requestgithub_pull_request_commentgithub_pull_request_reviewgithub_rate_limitgithub_rate_limit_graphqlgithub_releasegithub_repositorygithub_repository_collaboratorgithub_repository_dependabot_alertgithub_repository_deploymentgithub_repository_environmentgithub_repository_vulnerability_alertgithub_search_codegithub_search_commitgithub_search_issuegithub_search_labelgithub_search_pull_requestgithub_search_repositorygithub_search_topicgithub_search_usergithub_stargazergithub_taggithub_teamgithub_team_membergithub_team_repositorygithub_traffic_view_dailygithub_traffic_view_weeklygithub_treegithub_usergithub_workflow
Table: github_my_repository
A repository contains all of your project's files and each file's revision history.
You can own repositories individually, or you can share ownership of repositories with other people in an organization. The github_my_repository
table will list tables you own, you collaborate on, or that belong to your organizations.
To query ANY repository, including public repos, use the github_repository
table.
Examples
List of repositories that you or your organizations own or contribute to
select name, owner_login, name_with_ownerfrom github_my_repositoryorder by name_with_owner;
Show repository stats
select name, owner_login, primary_language ->> 'name' as language, fork_count, stargazer_count, subscribers_count, watchers_total_count, updated_at as last_updated, descriptionfrom github_my_repository;
List your public repositories
select name, is_private, visibility, owner_loginfrom github_my_repositorywhere not is_private;
OR
select name, is_private, visibilityfrom github_my_repositorywhere visibility = 'PUBLIC';
List all your repositories and their collaborators
select r.name_with_owner as repository_full_name, c.user_login, c.permissionfrom github_my_repository r, github_repository_collaborator cwhere r.name_with_owner = c.repository_full_name;
List all your repository collaborators with admin or maintainer permissions
select r.name_with_owner as repository_full_name, c.user_login, c.permissionfrom github_my_repository r, github_repository_collaborator cwhere r.name_with_owner = c.repository_full_name and permission in ('ADMIN', 'MAINTAIN');
List repository hooks that are insecure
select name as repository, hookfrom github_my_repository, jsonb_array_elements(hooks) as hookwhere hook -> 'config' ->> 'insecure_ssl' = '1' or hook -> 'config' ->> 'secret' is null or hook -> 'config' ->> 'url' not like '%https:%';
Query examples
- default_branch_protection_disabled_unverifiable_count
- default_branch_protection_enabled_count
- default_branch_protection_table
- open_issue_1_year_count
- open_issue_24_hours_count
- open_issue_30_90_days_count
- open_issue_30_days_count
- open_issue_90_365_days_count
- open_issue_count
- open_issue_table
- open_pull_request_1_year_count
- open_pull_request_24_hours_count
- open_pull_request_30_90_days_count
- open_pull_request_30_days_count
- open_pull_request_90_365_days_count
- open_pull_request_count
- open_pull_request_table
- repository_101_500_stars_count
- repository_1_100_stars_count
- repository_501_1000_stars_count
- repository_count
- repository_license_table
- repository_other_license_count
- repository_over_1000_stars_count
- repository_permissive_license_count
- repository_popular_copyleft_license_count
- repository_private_count
- repository_public_count
- repository_security_advisory_count
- repository_security_advisory_critical_count
- repository_security_advisory_high_count
- repository_security_advisory_low_count
- repository_security_advisory_medium_count
- repository_security_advisory_table
- repository_stargazer_table
- repository_unstarred_count
- repository_visibility_table
- repository_weak_copyleft_license_count
- repository_without_license_count
Control examples
- issue_has_assignee
- issue_has_labels
- issue_older_30_days
- private_repo_default_branch_blocks_deletion
- private_repo_default_branch_blocks_force_push
- private_repo_default_branch_protections_apply_to_admins
- private_repo_default_branch_requires_pull_request_reviews
- private_repo_delete_branch_on_merge_enabled
- private_repo_issues_enabled
- private_repo_no_outside_collaborators
- public_repo_code_of_conduct_added
- public_repo_contributing_added
- public_repo_default_branch_blocks_deletion
- public_repo_default_branch_blocks_force_push
- public_repo_default_branch_protections_apply_to_admins
- public_repo_default_branch_requires_pull_request_reviews
- public_repo_delete_branch_on_merge_enabled
- public_repo_description_set
- public_repo_issues_enabled
- public_repo_license_added
- public_repo_pull_request_template_added
- public_repo_readme_added
- public_repo_topics_set
- public_repo_website_set
.inspect github_my_repository
GitHub Repositories that you are associated with. GitHub Repositories contain all of your project's files and each file's revision history.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
allow_update_branch | boolean | If true, a pull request head branch that is behind its base branch can always be updated even if it is not required to be up to date before merging. |
archived_at | timestamp with time zone | Timestamp when repository was archived. |
auto_merge_allowed | boolean | If true, auto-merge can be enabled on pull requests in this repository. |
can_administer | boolean | If true, you can administer this repository. |
can_create_projects | boolean | If true, you can create projects in this repository. |
can_subscribe | boolean | If true, you can subscribe to this repository. |
can_update_topics | boolean | If true, you can update topics on this repository. |
code_of_conduct | jsonb | The code of conduct for this repository. |
contact_links | jsonb | List of contact links associated to the repository. |
created_at | timestamp with time zone | Timestamp when the repository was created. |
default_branch_ref | jsonb | Default ref information. |
delete_branch_on_merge | boolean | If true, branches are automatically deleted when merged in this repository. |
description | text | The description of the repository. |
disk_usage | bigint | Number of kilobytes this repository occupies on disk. |
fork_count | bigint | Number of forks there are of this repository in the whole network. |
forking_allowed | boolean | If true, repository allows forks. |
funding_links | jsonb | The funding links for this repository. |
has_discussions_enabled | boolean | If true, the repository has the Discussions feature enabled. |
has_downloads | boolean | If true, the GitHub Downloads feature is enabled on the repository. |
has_issues_enabled | boolean | If true, the repository has issues feature enabled. |
has_pages | boolean | If true, the GitHub Pages feature is enabled on the repository. |
has_projects_enabled | boolean | If true, the repository has the Projects feature enabled. |
has_starred | boolean | If true, you have starred this repository. |
has_vulnerability_alerts_enabled | boolean | If true, vulnerability alerts are enabled for the repository. |
has_wiki_enabled | boolean | If true, the repository has wiki feature enabled. |
homepage_url | text | The external URL of the repository if set. |
hooks | jsonb | The API Hooks URL. |
id | bigint | The numeric ID of the repository. |
interaction_ability | jsonb | The interaction ability settings for this repository. |
is_archived | boolean | If true, the repository is unmaintained (archived). |
is_blank_issues_enabled | boolean | If true, blank issue creation is allowed. |
is_disabled | boolean | If true, this repository disabled. |
is_empty | boolean | If true, this repository is empty. |
is_fork | boolean | If true, the repository is a fork. |
is_in_organization | boolean | If true, repository is either owned by an organization, or is a private fork of an organization repository. |
is_locked | boolean | If true, repository is locked. |
is_mirror | boolean | If true, the repository is a mirror. |
is_private | boolean | If true, the repository is private or internal. |
is_security_policy_enabled | boolean | If true, repository has a security policy. |
is_template | boolean | If true, the repository is a template that can be used to generate new repositories. |
is_user_configuration_repository | boolean | If true, this is a user configuration repository. |
issue_templates | jsonb | A list of issue templates associated to the repository. |
license_info | jsonb | The license associated with the repository. |
lock_reason | text | The reason the repository has been locked. |
merge_commit_allowed | boolean | If true, PRs are merged with a merge commit on this repository. |
merge_commit_message | text | How the default commit message will be generated when merging a pull request. |
merge_commit_title | text | How the default commit title will be generated when merging a pull request. |
mirror_url | text | The repository's original mirror URL. |
name | text | The name of the repository. |
name_with_owner | text | The repository's name with owner. |
network_count | bigint | The number of member repositories in the network. |
node_id | text | The node ID of the repository. |
open_graph_image_url | text | The image used to represent this repository in Open Graph data. |
open_issues_total_count | bigint | Count of issues open on the repository. |
owner_login | text | Login of the repository owner. |
possible_commit_emails | jsonb | A list of emails you can commit to this repository with. |
primary_language | jsonb | The primary language of the repository's code. |
projects_url | text | The URL listing the repository's projects. |
pull_request_templates | jsonb | Returns a list of pull request templates associated to the repository. |
pushed_at | timestamp with time zone | Timestamp when the repository was last pushed to. |
rebase_merge_allowed | boolean | If true, rebase-merging is enabled on this repository. |
repository_topics_total_count | bigint | Count of topics associated with the repository. |
security_policy_url | text | The security policy URL. |
squash_merge_allowed | boolean | If true, squash-merging is enabled on this repository. |
squash_merge_commit_message | text | How the default commit message will be generated when squash merging a pull request. |
squash_merge_commit_title | text | How the default commit title will be generated when squash merging a pull request. |
ssh_url | text | The SSH URL to clone this repository. |
stargazer_count | bigint | Returns a count of how many stargazers there are on this repository. |
subscribers_count | bigint | The number of users who have subscribed to the repository. |
subscription | text | Identifies if the current user is watching, not watching, or ignoring the repository. |
topics | jsonb | The topics (similar to tags or labels) associated with the repository. |
updated_at | timestamp with time zone | Timestamp when repository was last updated. |
url | text | The URL of the repository. |
uses_custom_open_graph_image | boolean | if true, this repository has a custom image to use with Open Graph as opposed to being represented by the owner's avatar. |
visibility | text | Indicates the repository's visibility level. |
watchers_total_count | bigint | Count of watchers on the repository. |
web_commit_signoff_required | boolean | If true, contributors are required to sign off on web-based commits in this repository. |
your_permission | text | Your permission level on the repository. Will return null if authenticated as an GitHub App. |