steampipe plugin install github

Table: github_search_repository - Query GitHub Repositories using SQL

GitHub Repositories represent a location where all the files for a project are stored. Each project corresponds to one repository. Repositories can contain folders and files, images, videos, spreadsheets, and data sets - anything your project needs.

Table Usage Guide

The github_search_repository table provides insights into repositories within GitHub. As a developer or project manager, explore repository-specific details through this table, including owner, name, description, and more. Utilize it to uncover information about repositories, such as those with specific topics, languages, or other search criteria, and to manage and organize your project's files and resources.

Important Notes

  • You must always include at least one search term when searching repositories 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

Identify specific details about a given repository, such as the owner, language used, and various user interaction metrics. This can be useful for understanding the popularity and reach of a repository within the GitHub community.

select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'repo:turbot/steampipe-plugin-github';
select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'repo:turbot/steampipe-plugin-github';

List repositories based on contents of a repository

Discover the segments that are popular among users by identifying repositories based on the content of a specific repository. This can help in understanding user preferences and trends in the open-source community.

select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'stargazers in:readme repo:turbot/steampipe-plugin-github';
select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'stargazers in:readme repo:turbot/steampipe-plugin-github';

List repositories with more than 100000 followers

Determine the areas in which popular repositories on GitHub have amassed a large following. This query is useful for identifying trends and patterns among the most followed repositories, offering insights into what makes a repository popular.

select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'followers:>=100000';
select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'followers:>=100000';

List forked repositories created within specific timestamp

Discover the segments that have forked a specific repository within a particular time frame. This can be particularly useful for understanding the popularity and reach of a project during that period.

select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'tinyspotifyr in:name created:2021-01-01..2021-01-05 fork:only';
select
name,
owner_login,
primary_language,
fork_count,
stargazer_count,
subscribers_count,
watchers_total_count
from
github_search_repository
where
query = 'tinyspotifyr in:name created:2021-01-01..2021-01-05 fork:only';

Schema for github_search_repository

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
allow_update_branchbooleanIf 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_attimestamp with time zoneTimestamp when repository was archived.
auto_merge_allowedbooleanIf true, auto-merge can be enabled on pull requests in this repository.
can_administerbooleanIf true, you can administer this repository.
can_create_projectsbooleanIf true, you can create projects in this repository.
can_subscribebooleanIf true, you can subscribe to this repository.
can_update_topicsbooleanIf true, you can update topics on this repository.
code_of_conductjsonbThe code of conduct for this repository.
contact_linksjsonbList of contact links associated to the repository.
created_attimestamp with time zoneTimestamp when the repository was created.
default_branch_refjsonbDefault ref information.
delete_branch_on_mergebooleanIf true, branches are automatically deleted when merged in this repository.
descriptiontextThe description of the repository.
disk_usagebigintNumber of kilobytes this repository occupies on disk.
fork_countbigintNumber of forks there are of this repository in the whole network.
forking_allowedbooleanIf true, repository allows forks.
funding_linksjsonbThe funding links for this repository.
has_discussions_enabledbooleanIf true, the repository has the Discussions feature enabled.
has_downloadsbooleanIf true, the GitHub Downloads feature is enabled on the repository.
has_issues_enabledbooleanIf true, the repository has issues feature enabled.
has_pagesbooleanIf true, the GitHub Pages feature is enabled on the repository.
has_projects_enabledbooleanIf true, the repository has the Projects feature enabled.
has_starredbooleanIf true, you have starred this repository.
has_vulnerability_alerts_enabledbooleanIf true, vulnerability alerts are enabled for the repository.
has_wiki_enabledbooleanIf true, the repository has wiki feature enabled.
homepage_urltextThe external URL of the repository if set.
hooksjsonbThe API Hooks URL.
idbigintThe numeric ID of the repository.
interaction_abilityjsonbThe interaction ability settings for this repository.
is_archivedbooleanIf true, the repository is unmaintained (archived).
is_blank_issues_enabledbooleanIf true, blank issue creation is allowed.
is_disabledbooleanIf true, this repository disabled.
is_emptybooleanIf true, this repository is empty.
is_forkbooleanIf true, the repository is a fork.
is_in_organizationbooleanIf true, repository is either owned by an organization, or is a private fork of an organization repository.
is_lockedbooleanIf true, repository is locked.
is_mirrorbooleanIf true, the repository is a mirror.
is_privatebooleanIf true, the repository is private or internal.
is_security_policy_enabledbooleanIf true, repository has a security policy.
is_templatebooleanIf true, the repository is a template that can be used to generate new repositories.
is_user_configuration_repositorybooleanIf true, this is a user configuration repository.
issue_templatesjsonbA list of issue templates associated to the repository.
license_infojsonbThe license associated with the repository.
lock_reasontextThe reason the repository has been locked.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
merge_commit_allowedbooleanIf true, PRs are merged with a merge commit on this repository.
merge_commit_messagetextHow the default commit message will be generated when merging a pull request.
merge_commit_titletextHow the default commit title will be generated when merging a pull request.
mirror_urltextThe repository's original mirror URL.
nametextThe name of the repository.
name_with_ownertextThe repository's name with owner.
network_countbigintThe number of member repositories in the network.
node_idtextThe node ID of the repository.
open_graph_image_urltextThe image used to represent this repository in Open Graph data.
open_issues_total_countbigintCount of issues open on the repository.
owner_logintextLogin of the repository owner.
possible_commit_emailsjsonbA list of emails you can commit to this repository with.
primary_languagejsonbThe primary language of the repository's code.
projects_urltextThe URL listing the repository's projects.
pull_request_templatesjsonbReturns a list of pull request templates associated to the repository.
pushed_attimestamp with time zoneTimestamp when the repository was last pushed to.
querytext=The query provided for the search.
rebase_merge_allowedbooleanIf true, rebase-merging is enabled on this repository.
repository_topics_total_countbigintCount of topics associated with the repository.
security_policy_urltextThe security policy URL.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
squash_merge_allowedbooleanIf true, squash-merging is enabled on this repository.
squash_merge_commit_messagetextHow the default commit message will be generated when squash merging a pull request.
squash_merge_commit_titletextHow the default commit title will be generated when squash merging a pull request.
ssh_urltextThe SSH URL to clone this repository.
stargazer_countbigintReturns a count of how many stargazers there are on this repository.
subscribers_countbigintThe number of users who have subscribed to the repository.
subscriptiontextIdentifies if the current user is watching, not watching, or ignoring the repository.
text_matchesjsonbThe text match details.
topicsjsonbThe topics (similar to tags or labels) associated with the repository.
updated_attimestamp with time zoneTimestamp when repository was last updated.
urltextThe URL of the repository.
uses_custom_open_graph_imagebooleanif true, this repository has a custom image to use with Open Graph as opposed to being represented by the owner's avatar.
visibilitytextIndicates the repository's visibility level.
watchers_total_countbigintCount of watchers on the repository.
web_commit_signoff_requiredbooleanIf true, contributors are required to sign off on web-based commits in this repository.
your_permissiontextYour permission level on the repository. Will return null if authenticated as an GitHub App.

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_search_repository