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';

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