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

List featured topics

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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The timestamp when the topic was created.
created_by	text		The creator of the topic.
curated	boolean		Whether the topic is curated.
description	text		The description of the topic.
display_name	text		The display name of the topic.
featured	boolean		Whether the topic is featured.
login_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the user login.
name	text		The name of the topic.
query	text	=	The query used to match the topic.
score	double precision		The score of the topic.
short_description	text		The short description of the topic.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
updated_at	timestamp with time zone		The 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