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_licensegithub_my_gistgithub_my_issuegithub_my_organizationgithub_my_repositorygithub_my_stargithub_my_teamgithub_organizationgithub_organization_dependabot_alertgithub_organization_membergithub_pull_requestgithub_rate_limitgithub_releasegithub_repositorygithub_repository_dependabot_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_search_repository
The github_search_repository
table helps to find repositories via various criteria. You can search for repositories on GitHub and narrow the results using these repository search qualifiers in any combination.
You must always include at least one search term when searching source code in the where or join clause using the query
column. You can search for repositories globally across all of GitHub.com, or search for repositories within a particular organization. See Searching for repositories for details on the GitHub query syntax.
Examples
Get a specific repository
select name, owner_login, language, forks_count, stargazers_count, subscribers_count, watchers_countfrom github_search_repositorywhere query = 'repo:turbot/steampipe-plugin-github';
List repositories based on contents of a repository
select name, owner_login, language, forks_count, stargazers_count, subscribers_count, watchers_countfrom github_search_repositorywhere query = 'stargazers in:readme repo:turbot/steampipe-plugin-github';
List repositories with more than 100000 followers
select name, owner_login, language, forks_count, stargazers_count, subscribers_count, watchers_countfrom github_search_repositorywhere query = 'followers:>=100000';
List forked repositories created within specific timestamp
select name, owner_login, language, forks_count, stargazers_count, subscribers_count, watchers_countfrom github_search_repositorywhere query = 'tinyspotifyr in:name created:2021-01-01..2021-01-05 fork:only';
.inspect github_search_repository
Find repositories via various criteria.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
allow_merge_commit | boolean | If true, the repository allows merge commits. |
allow_rebase_merge | boolean | If true, the repository allows rebase merges. |
allow_squash_merge | boolean | If true, the repository allows squash merges. |
archived | boolean | If true, the repository is archived and read-only. |
clone_url | text | URL that can be provided to git clone to clone the repository via HTTPS. |
code_of_conduct_key | text | Unique key for code of conduct for the repository. |
code_of_conduct_name | text | Name of the Code of Conduct for the repository. |
code_of_conduct_url | text | URL of the Code of Conduct for the repository. |
collaborator_logins | jsonb | An array of logins for users (inside and outside collaborators) who have access to the repository. |
collaborators | jsonb | An array of users (teams and outside collaborators) who have access to the repository, including their permissions. |
created_at | timestamp with time zone | The timestamp when the repository was created. |
default_branch | text | The name of the deafult branch. The default branch is the base branch for pull requests and code commits. |
delete_branch_on_merge | boolean | If enabled, branches are automatically deleted whe a PR is merged. |
description | text | The repository description. |
disabled | boolean | If true, the repository is disabled. |
fork | boolean | If true, this repository is a fork of another repository. |
forks_count | bigint | The number of repositories that have forked this repository. |
full_name | text | The full name of the repository, including the owner and repo name. |
git_url | text | The git url to clone this repo via the git protocol. |
has_downloads | boolean | If true, the GitHub Downloads feature is enabled on the repository. |
has_issues | boolean | If true, the GitHub Issues feature is enabled on the repository. |
has_pages | boolean | If true, the GitHub Pages feature is enabled on the repository. |
has_projects | boolean | If true, the GitHub Projects feature is enabled on the repository. |
has_wiki | boolean | If true, the GitHub Wiki feature is enabled on the repository. |
homepage | text | The URL of a page describing the project. |
hooks | jsonb | The API Hooks URL. |
html_url | text | The URL of the repo. |
id | bigint | The unique ID number of the repository. |
is_template | boolean | If true, the repository is a template repository. |
language | text | The repository language (JavaScript, Go, etc) |
license_key | text | The key of the license associated with the repository. |
license_name | text | The name of the license associated with the repository. |
license_node_id | text | The node id of the license associated with the repository. |
license_spdx_id | text | The Software Package Data Exchange (SPDX) id of the license associated with the repository. |
license_url | text | The url of the license associated with the repository. |
name | text | The name of the repository. |
network_count | bigint | The number of member repositories in the network. |
node_id | text | The Node ID of the repository. |
open_issues_count | bigint | The number of open issues for the repository. |
outside_collaborator_logins | jsonb | An array of logins for outside collaborators who have access to the repository. |
outside_collaborators | jsonb | An array of outside collaborators who have access to the repository, including their permissions. |
owner_id | bigint | The user id (number) of the repository owner. |
owner_login | text | The user login name of the repository owner. |
owner_type | text | The type of the repository owner (User or Organization). |
private | boolean | If true, the repo is private, otherwise it is public. |
pushed_at | timestamp with time zone | Timestamp of the last push to the repository. |
query | text | The query used to match the repository. |
size | bigint | The size of the whole repository (including history), in kilobytes. |
ssh_url | text | The url to clone this repo via ssh. |
stargazers_count | bigint | The number of users who have 'starred' the repository. |
subscribers_count | bigint | The number of users who have subscribed to the repository. |
template_repository | text | The template repository used to create this resource. |
text_matches | jsonb | The text match details. |
topics | jsonb | The topics (similar to tags or labels) associated with the repository. |
updated_at | timestamp with time zone | Timestamp when the repository was last updated. |
url | text | The url to clone this repo via https. |
visibility | text | The visibility of the repository (public or private) |
watchers_count | bigint | The number of users who have watched the repository. |