turbot/github

GitHub
steampipe plugin install githubsteampipe plugin install github

Table: github_search_topic

The github_search_topic table helps to find topics via various criteria. You can search for topics on GitHub, explore related topics, and see how many repositories are associated with a certain topic.

You must always include at least one search term when searching source code in the where or join clause using the query column. See Searching topics for details on the GitHub query syntax.

Examples

List topics that are not curated

select
name,
created_at,
curated
from
github_search_topic
where
query = 'target-searching is:not-curated repo:turbot/steampipe-plugin-github';
select
name,
created_at,
featured
from
github_search_topic
where
query = 'markdown is:featured repo:turbot/steampipe-plugin-github';

List topics that have more than 5000 repositories

select
name,
created_at,
created_by,
featured,
curated
from
github_search_topic
where
query = 'repositories:>5000 react-redux';

List topics that were created after a specific timestamp

select
name,
created_at,
created_by,
featured,
curated
from
github_search_topic
where
query = 'created:>2021-01-01 react-redux';

.inspect github_search_topic

Find topics via various criteria.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneThe timestamp when the topic was created.
created_bytextThe creator of the topic.
curatedbooleanWhether the topic is curated.
descriptiontextThe description of the topic.
display_nametextThe display name of the topic.
featuredbooleanWhether the topic is featured.
nametextThe name of the topic.
querytextThe query used to match the topic.
scoredouble precisionThe score of the topic.
short_descriptiontextThe short description of the topic.
updated_attimestamp with time zoneThe timestamp when the topic was updated.