star_history

Creates, updates, deletes, gets or lists a star_history resource.

Overview

Name	star_history
Type	Resource
Id	github.activity.star_history

Fields

The following fields are returned by SELECT queries:

list

Response

Name	Datatype	Description
starred_at	string (date-time)	When the star was given.
user	object	The user who starred the repository (login, id, database_id, name, company, location, url, avatar_url).

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	owner, repo		Every star on a repository with the time it was given, oldest first - suitable for star growth over time. Backed by the GitHub GraphQL API (repository.stargazers ordered by STARRED_AT). Since July 2026 GitHub limits stargazer listings to repository admins and collaborators; other tokens get "Resource not accessible by personal access token".

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
owner	string	The account owner of the repository.
repo	string	The name of the repository.

SELECT examples

list

Every star on a repository with the time it was given, oldest first - suitable for star growth over time. Backed by the GitHub GraphQL API (repository.stargazers ordered by STARRED_AT). Since July 2026 GitHub limits stargazer listings to repository admins and collaborators; other tokens get "Resource not accessible by personal access token".

SELECT
starred_at,
user
FROM github.activity.star_history
WHERE owner = '{{ owner }}' -- required
AND repo = '{{ repo }}' -- required
;