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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
login_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the user login.
repository_full_name	text		The full name of the repository, including the owner and repo name.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
starred_at	timestamp with time zone		The timestamp when the repository was starred.
url	text		URL 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