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_count
from
  github_search_repository
where
  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_count
from
  github_search_repository
where
  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_count
from
  github_search_repository
where
  query = 'followers:>=100000';

List forked repositories created within specific timestamp

select
  name,
  owner_login,
  language,
  forks_count,
  stargazers_count,
  subscribers_count,
  watchers_count
from
  github_search_repository
where
  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.

turbot/github