steampipe plugin install github

Table: github_my_star - Query GitHub My Stars using SQL

GitHub Stars is a feature within GitHub that allows users to bookmark repositories for later reference. Users can star repositories to keep track of projects they find interesting, even if they do not directly contribute to them. This feature serves as a way to show appreciation for the repository maintainers' work and also to keep track of repositories for later use.

Table Usage Guide

The github_my_star table provides insights into the repositories starred by the authenticated GitHub user. As a developer or project manager, explore details through this table, including repository names, owners, and star creation dates. Utilize it to analyze user preferences, discover potential areas of interest, and manage your starred repositories effectively.

Examples

List of your starred repositories

Explore which repositories you've starred on Github, allowing you to quickly access and review your favorite projects. This is particularly useful for keeping track of repositories you find interesting or intend to contribute to in the future.

select
starred_at,
repository_full_name,
url
from
github_my_star;
select
starred_at,
repository_full_name,
url
from
github_my_star;

Schema for github_my_star

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
login_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier for the user login.
repository_full_nametextThe full name of the repository, including the owner and repo name.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
starred_attimestamp with time zoneThe timestamp when the repository was starred.
urltextURL of the repository.

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_my_star