steampipe plugin install github

Table: github_search_topic - Query GitHub Topics using SQL

GitHub Topics is a feature that allows users to explore repositories by technology, industry, and more. It helps developers to discover projects, learn from their peers, and better understand the landscape of possibilities within the platform. Topics are labels that repository owners can use to categorize their projects, so they're more discoverable.

Table Usage Guide

The github_search_topic table provides insights into topics within GitHub. As a developer or project manager, explore topic-specific details through this table, including associated repositories, the number of stars, and the language used. Utilize it to uncover information about popular topics, the repositories that use them, and the overall popularity of different technologies and industries.

Important Notes

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

Identify topics that lack curation within a specific GitHub repository. This is useful for maintaining content quality and relevance by pinpointing areas needing further attention.

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,
curated
from
github_search_topic
where
query = 'target-searching is:not-curated repo:turbot/steampipe-plugin-github';

Explore which topics have been highlighted on the GitHub repository for the Steampipe GitHub plugin. This can be useful for understanding what areas of the plugin are being emphasized or promoted.

select
name,
created_at,
featured
from
github_search_topic
where
query = 'markdown is:featured 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

Determine the areas in which popular topics on GitHub exceed 5000 repositories, providing insights into the most widely-used topics and enabling a focus on areas of high activity for potential collaboration or learning opportunities.

select
name,
created_at,
created_by,
featured,
curated
from
github_search_topic
where
query = 'repositories:>5000 react-redux';
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

Discover the segments that have been established after a certain date, specifically within the context of react-redux. This is useful for tracking the evolution and growth of react-redux related topics over time.

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

Schema for github_search_topic

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
nametextThe name of the topic.
querytext=The query used to match the topic.
scoredouble precisionThe score of the topic.
short_descriptiontextThe short description of the topic.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneThe timestamp when the topic was updated.

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_topic