`github.activity_list_repos_starred_by_user`

pass

List repositories starred by a user

Requires username. Most useful optional filters: sort, direction. Use LIMIT for spot checks; large result sets paginate quickly.

username captured 2026-08-31 05:24:01Zmedian 27691 ms

Verdict: TRUE

All variants returned rows on ≥2 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	21232 ms	22087 ms	22943 ms	[1, 1]
realistic	2	22301 ms	27691 ms	33081 ms	[25, 25]
edge	2	29868 ms	31249 ms	32631 ms	[26, 26]

Latency per trial

minimalmedian 22087ms

scale: 0–22943 ms

realisticmedian 27691ms

scale: 0–33081 ms

edgemedian 31249ms

scale: 0–32631 ms

Probe variants — every command + output

minimal2 trials

min 21232ms · median 22087ms · max 22943ms · rows 1,1

smallest valid query

Command

SELECT * FROM github.activity_list_repos_starred_by_user WHERE username = 'FiscalMindset' LIMIT 1

Trials + output

trial 1·21232ms·rows 1isError=false

First row (click to expand JSON)

{
  "direction": "",
  "json": "{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"full_name\":\"mattpocock/skills\",\"private\":false,\"owner\":{\"login\":\"mattpocock\",\"id\":28293365,\"node_id\":\"MDQ6VXNlcjI4MjkzMzY1\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/28293365?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/mattpocock\",\"html_url\":\"https://github.com/mattpocock\",\"followers_url\":\"https://api.github.com/users/mattpocock/followers\",\"following_url\":\"https://api.github.com/users/mattpocock/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/mattpocock/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/mattpocock/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/mattpocock/subscriptions\",\"organizations_url\":\"https://api.github.com/users/mattpocock/orgs\",\"repos_url\":\"https://api.github.com/users/mattpocock/repos\",\"events_url\":\"https://api.github.com/users/mattpocock/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/mattpocock/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false},\"html_url\":\"https://github.com/mattpocock/skills\",\"description\":\"Skills for Real Engineers. Straight from my .agents directory.\",\"fork\":false,\"url\":\"https://api.github.com/repos/mattpocock/skills\",\"forks_url\":\"https://api.github.com/repos/mattpocock/skills/forks\",\"keys_url\":\"https://api.github.com/repos/mattpocock/skills/keys{/key_id}\",\"collaborators_url\":\"https://api.github.com/repos/mattpocock/skills/collaborators{/collaborator}\",\"teams_url\":\"https://api.github.com/repos/mattpocock/skills/teams\",\"hooks_url\":\"https://api.github.com/repos/mattpocock/skills/hooks\",\"issue_events_url\":\"https://api.github.com/repos/mattpocock/skills/issues/events{/number}\",\"events_url\":\"https://api.github.com/repos/mattpocock/skills/events\",\"assignees_url\":\"https://api.github.com/repos/mattpocock/skills/assignees{/user}\",\"branches_url\":\"https://api.github.com/repos/mattpocock/skills/branches{/branch}\",\"tags_url\":\"https://api.github.com/repos/mattpocock/skills/tags\",\"blobs_url\":\"https://api.github.com/repos/mattpocock/skills/git/blobs{/sha}\",\"git_tags_url\":\"https://api.github.com/repos/mattpocock/skills/git/tags{/sha}\",\"git_refs_url\":\"https://api.github.com/repos/mattpocock/skills/git/refs{/sha}\",\"trees_url\":\"https://api.github.com/repos/mattpocock/skills/git/trees{/sha}\",\"statuses_url\":\"https://api.github.com/repos/mattpocock/skills/statuses/{sha}\",\"languages_url\":\"https://api.github.com/repos/mattpocock/skills/languages\",\"stargazers_url\":\"https://api.github.com/repos/mattpocock/skills/stargazers\",\"contributors_url\":\"https://api.github.com/repos/mattpocock/skills/contributors\",\"subscribers_url\":\"https://api.github.com/repos/mattpocock/skills/subscribers\",\"subscription_url\":\"https://api.github.com/repos/mattpocock/skills/subscription\",\"commits_url\":\"https://api.github.com/repos/mattpocock/skills/commits{/sha}\",\"git_commits_url\":\"https://api.github.com/repos/mattpocock/skills/git/commits{/sha}\",\"comments_url\":\"https://api.github.com/repos/mattpocock/skills/comments{/number}\",\"issue_comment_url\":\"https://api.github.com/repos/mattpocock/skills/issues/comments{/number}\",\"contents_url\":\"https://api.github.com/repos/mattpocock/skills/contents/{+path}\",\"compare_url\":\"https://api.github.com/repos/mattpocock/skills/compare/{base}...{head}\",\"merges_url\":\"https://api.github.com/repos/mattpocock/skills/merges\",\"archive_url\":\"https://api.github.com/repos/mattpocock/skills/{archive_format}{/ref}\",\"downloads_url\":\"https://api.github.com/repos/mattpocock/skills/downloads\",\"issues_url\":\"https://api.github.com/repos/mattpocock/skills/issues{/number}\",\"pulls_url\":\"https://api.github.com/repos/mattpocock/skills/pulls{/number}\",\"milestones_url\":\"https://api.github.com/repos/mattpocock/skills/milestones{/number}\",\"notifications_url\":\"https://api.github.com/repos/mattpocock/skills/notifications{?since,all,participating}\",\"labels_url\":\"https://api.github.com/repos/mattpocock/skills/labels{/name}\",\"releases_url\":\"https://api.github.com/repos/mattpocock/skills/releases{/id}\",\"deployments_url\":\"https://api.github.com/repos/mattpocock/skills/deployments\",\"created_at\":\"2026-02-03T11:15:53Z\",\"updated_at\":\"2026-08-31T05:23:34Z\",\"pushed_at\":\"2026-08-24T14:20:17Z\",\"git_url\":\"git://github.com/mattpocock/skills.git\",\"ssh_url\":\"git@github.com:mattpocock/skills.git\",\"clone_url\":\"https://github.com/mattpocock/skills.git\",\"svn_url\":\"https://github.com/mattpocock/skills\",\"homepage\":\"https://aihero.dev/skills\",\"size\":1548,\"stargazers_count\":242061,\"watchers_count\":242061,\"language\":\"Shell\",\"has_issues\":true,\"has_projects\":true,\"has_downloads\":false,\"has_wiki\":false,\"has_pages\":false,\"has_discussions\":true,\"forks_count\":20587,\"mirror_url\":null,\"archived\":false,\"disabled\":false,\"open_issues_count\":442,\"license\":{\"key\":\"mit\",\"name\":\"MIT License\",\"spdx_id\":\"MIT\",\"url\":\"https://api.github.com/licenses/mit\",\"node_id\":\"MDc6TGljZW5zZTEz\"},\"allow_forking\":true,\"is_template\":false,\"web_commit_signoff_required\":false,\"has_pull_requests\":true,\"pull_request_creation_policy\":\"collaborators_only\",\"topics\":[],\"visibility\":\"public\",\"forks\":20587,\"open_issues\":442,\"watchers\":242061,\"default_branch\":\"main\",\"permissions\":{\"admin\":false,\"maintain\":false,\"push\":false,\"triage\":false,\"pull\":true}}",
  "sort": "",
  "username": "FiscalMindset"
}

columns (4)

directionjsonsortusername

trial 2·22943ms·rows 1isError=false

First row (click to expand JSON)

{
  "direction": "",
  "json": "{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"full_name\":\"mattpocock/skills\",\"private\":false,\"owner\":{\"login\":\"mattpocock\",\"id\":28293365,\"node_id\":\"MDQ6VXNlcjI4MjkzMzY1\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/28293365?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/mattpocock\",\"html_url\":\"https://github.com/mattpocock\",\"followers_url\":\"https://api.github.com/users/mattpocock/followers\",\"following_url\":\"https://api.github.com/users/mattpocock/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/mattpocock/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/mattpocock/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/mattpocock/subscriptions\",\"organizations_url\":\"https://api.github.com/users/mattpocock/orgs\",\"repos_url\":\"https://api.github.com/users/mattpocock/repos\",\"events_url\":\"https://api.github.com/users/mattpocock/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/mattpocock/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false},\"html_url\":\"https://github.com/mattpocock/skills\",\"description\":\"Skills for Real Engineers. Straight from my .agents directory.\",\"fork\":false,\"url\":\"https://api.github.com/repos/mattpocock/skills\",\"forks_url\":\"https://api.github.com/repos/mattpocock/skills/forks\",\"keys_url\":\"https://api.github.com/repos/mattpocock/skills/keys{/key_id}\",\"collaborators_url\":\"https://api.github.com/repos/mattpocock/skills/collaborators{/collaborator}\",\"teams_url\":\"https://api.github.com/repos/mattpocock/skills/teams\",\"hooks_url\":\"https://api.github.com/repos/mattpocock/skills/hooks\",\"issue_events_url\":\"https://api.github.com/repos/mattpocock/skills/issues/events{/number}\",\"events_url\":\"https://api.github.com/repos/mattpocock/skills/events\",\"assignees_url\":\"https://api.github.com/repos/mattpocock/skills/assignees{/user}\",\"branches_url\":\"https://api.github.com/repos/mattpocock/skills/branches{/branch}\",\"tags_url\":\"https://api.github.com/repos/mattpocock/skills/tags\",\"blobs_url\":\"https://api.github.com/repos/mattpocock/skills/git/blobs{/sha}\",\"git_tags_url\":\"https://api.github.com/repos/mattpocock/skills/git/tags{/sha}\",\"git_refs_url\":\"https://api.github.com/repos/mattpocock/skills/git/refs{/sha}\",\"trees_url\":\"https://api.github.com/repos/mattpocock/skills/git/trees{/sha}\",\"statuses_url\":\"https://api.github.com/repos/mattpocock/skills/statuses/{sha}\",\"languages_url\":\"https://api.github.com/repos/mattpocock/skills/languages\",\"stargazers_url\":\"https://api.github.com/repos/mattpocock/skills/stargazers\",\"contributors_url\":\"https://api.github.com/repos/mattpocock/skills/contributors\",\"subscribers_url\":\"https://api.github.com/repos/mattpocock/skills/subscribers\",\"subscription_url\":\"https://api.github.com/repos/mattpocock/skills/subscription\",\"commits_url\":\"https://api.github.com/repos/mattpocock/skills/commits{/sha}\",\"git_commits_url\":\"https://api.github.com/repos/mattpocock/skills/git/commits{/sha}\",\"comments_url\":\"https://api.github.com/repos/mattpocock/skills/comments{/number}\",\"issue_comment_url\":\"https://api.github.com/repos/mattpocock/skills/issues/comments{/number}\",\"contents_url\":\"https://api.github.com/repos/mattpocock/skills/contents/{+path}\",\"compare_url\":\"https://api.github.com/repos/mattpocock/skills/compare/{base}...{head}\",\"merges_url\":\"https://api.github.com/repos/mattpocock/skills/merges\",\"archive_url\":\"https://api.github.com/repos/mattpocock/skills/{archive_format}{/ref}\",\"downloads_url\":\"https://api.github.com/repos/mattpocock/skills/downloads\",\"issues_url\":\"https://api.github.com/repos/mattpocock/skills/issues{/number}\",\"pulls_url\":\"https://api.github.com/repos/mattpocock/skills/pulls{/number}\",\"milestones_url\":\"https://api.github.com/repos/mattpocock/skills/milestones{/number}\",\"notifications_url\":\"https://api.github.com/repos/mattpocock/skills/notifications{?since,all,participating}\",\"labels_url\":\"https://api.github.com/repos/mattpocock/skills/labels{/name}\",\"releases_url\":\"https://api.github.com/repos/mattpocock/skills/releases{/id}\",\"deployments_url\":\"https://api.github.com/repos/mattpocock/skills/deployments\",\"created_at\":\"2026-02-03T11:15:53Z\",\"updated_at\":\"2026-08-31T05:24:31Z\",\"pushed_at\":\"2026-08-24T14:20:17Z\",\"git_url\":\"git://github.com/mattpocock/skills.git\",\"ssh_url\":\"git@github.com:mattpocock/skills.git\",\"clone_url\":\"https://github.com/mattpocock/skills.git\",\"svn_url\":\"https://github.com/mattpocock/skills\",\"homepage\":\"https://aihero.dev/skills\",\"size\":1548,\"stargazers_count\":242062,\"watchers_count\":242062,\"language\":\"Shell\",\"has_issues\":true,\"has_projects\":true,\"has_downloads\":false,\"has_wiki\":false,\"has_pages\":false,\"has_discussions\":true,\"forks_count\":20587,\"mirror_url\":null,\"archived\":false,\"disabled\":false,\"open_issues_count\":442,\"license\":{\"key\":\"mit\",\"name\":\"MIT License\",\"spdx_id\":\"MIT\",\"url\":\"https://api.github.com/licenses/mit\",\"node_id\":\"MDc6TGljZW5zZTEz\"},\"allow_forking\":true,\"is_template\":false,\"web_commit_signoff_required\":false,\"has_pull_requests\":true,\"pull_request_creation_policy\":\"collaborators_only\",\"topics\":[],\"visibility\":\"public\",\"forks\":20587,\"open_issues\":442,\"watchers\":242062,\"default_branch\":\"main\",\"permissions\":{\"admin\":false,\"maintain\":false,\"push\":false,\"triage\":false,\"pull\":true}}",
  "sort": "",
  "username": "FiscalMindset"
}

columns (4)

directionjsonsortusername

realistic2 trials

min 22301ms · median 27691ms · max 33081ms · rows 25,25

typical user query

Command

SELECT * FROM github.activity_list_repos_starred_by_user WHERE username = 'FiscalMindset' LIMIT 25

Trials + output

trial 1·22301ms·rows 25isError=false

First row (click to expand JSON)

{
  "direction": "",
  "json": "{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"full_name\":\"mattpocock/skills\",\"private\":false,\"owner\":{\"login\":\"mattpocock\",\"id\":28293365,\"node_id\":\"MDQ6VXNlcjI4MjkzMzY1\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/28293365?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/mattpocock\",\"html_url\":\"https://github.com/mattpocock\",\"followers_url\":\"https://api.github.com/users/mattpocock/followers\",\"following_url\":\"https://api.github.com/users/mattpocock/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/mattpocock/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/mattpocock/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/mattpocock/subscriptions\",\"organizations_url\":\"https://api.github.com/users/mattpocock/orgs\",\"repos_url\":\"https://api.github.com/users/mattpocock/repos\",\"events_url\":\"https://api.github.com/users/mattpocock/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/mattpocock/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false},\"html_url\":\"https://github.com/mattpocock/skills\",\"description\":\"Skills for Real Engineers. Straight from my .agents directory.\",\"fork\":false,\"url\":\"https://api.github.com/repos/mattpocock/skills\",\"forks_url\":\"https://api.github.com/repos/mattpocock/skills/forks\",\"keys_url\":\"https://api.github.com/repos/mattpocock/skills/keys{/key_id}\",\"collaborators_url\":\"https://api.github.com/repos/mattpocock/skills/collaborators{/collaborator}\",\"teams_url\":\"https://api.github.com/repos/mattpocock/skills/teams\",\"hooks_url\":\"https://api.github.com/repos/mattpocock/skills/hooks\",\"issue_events_url\":\"https://api.github.com/repos/mattpocock/skills/issues/events{/number}\",\"events_url\":\"https://api.github.com/repos/mattpocock/skills/events\",\"assignees_url\":\"https://api.github.com/repos/mattpocock/skills/assignees{/user}\",\"branches_url\":\"https://api.github.com/repos/mattpocock/skills/branches{/branch}\",\"tags_url\":\"https://api.github.com/repos/mattpocock/skills/tags\",\"blobs_url\":\"https://api.github.com/repos/mattpocock/skills/git/blobs{/sha}\",\"git_tags_url\":\"https://api.github.com/repos/mattpocock/skills/git/tags{/sha}\",\"git_refs_url\":\"https://api.github.com/repos/mattpocock/skills/git/refs{/sha}\",\"trees_url\":\"https://api.github.com/repos/mattpocock/skills/git/trees{/sha}\",\"statuses_url\":\"https://api.github.com/repos/mattpocock/skills/statuses/{sha}\",\"languages_url\":\"https://api.github.com/repos/mattpocock/skills/languages\",\"stargazers_url\":\"https://api.github.com/repos/mattpocock/skills/stargazers\",\"contributors_url\":\"https://api.github.com/repos/mattpocock/skills/contributors\",\"subscribers_url\":\"https://api.github.com/repos/mattpocock/skills/subscribers\",\"subscription_url\":\"https://api.github.com/repos/mattpocock/skills/subscription\",\"commits_url\":\"https://api.github.com/repos/mattpocock/skills/commits{/sha}\",\"git_commits_url\":\"https://api.github.com/repos/mattpocock/skills/git/commits{/sha}\",\"comments_url\":\"https://api.github.com/repos/mattpocock/skills/comments{/number}\",\"issue_comment_url\":\"https://api.github.com/repos/mattpocock/skills/issues/comments{/number}\",\"contents_url\":\"https://api.github.com/repos/mattpocock/skills/contents/{+path}\",\"compare_url\":\"https://api.github.com/repos/mattpocock/skills/compare/{base}...{head}\",\"merges_url\":\"https://api.github.com/repos/mattpocock/skills/merges\",\"archive_url\":\"https://api.github.com/repos/mattpocock/skills/{archive_format}{/ref}\",\"downloads_url\":\"https://api.github.com/repos/mattpocock/skills/downloads\",\"issues_url\":\"https://api.github.com/repos/mattpocock/skills/issues{/number}\",\"pulls_url\":\"https://api.github.com/repos/mattpocock/skills/pulls{/number}\",\"milestones_url\":\"https://api.github.com/repos/mattpocock/skills/milestones{/number}\",\"notifications_url\":\"https://api.github.com/repos/mattpocock/skills/notifications{?since,all,participating}\",\"labels_url\":\"https://api.github.com/repos/mattpocock/skills/labels{/name}\",\"releases_url\":\"https://api.github.com/repos/mattpocock/skills/releases{/id}\",\"deployments_url\":\"https://api.github.com/repos/mattpocock/skills/deployments\",\"created_at\":\"2026-02-03T11:15:53Z\",\"updated_at\":\"2026-08-31T05:24:31Z\",\"pushed_at\":\"2026-08-24T14:20:17Z\",\"git_url\":\"git://github.com/mattpocock/skills.git\",\"ssh_url\":\"git@github.com:mattpocock/skills.git\",\"clone_url\":\"https://github.com/mattpocock/skills.git\",\"svn_url\":\"https://github.com/mattpocock/skills\",\"homepage\":\"https://aihero.dev/skills\",\"size\":1548,\"stargazers_count\":242062,\"watchers_count\":242062,\"language\":\"Shell\",\"has_issues\":true,\"has_projects\":true,\"has_downloads\":false,\"has_wiki\":false,\"has_pages\":false,\"has_discussions\":true,\"forks_count\":20587,\"mirror_url\":null,\"archived\":false,\"disabled\":false,\"open_issues_count\":442,\"license\":{\"key\":\"mit\",\"name\":\"MIT License\",\"spdx_id\":\"MIT\",\"url\":\"https://api.github.com/licenses/mit\",\"node_id\":\"MDc6TGljZW5zZTEz\"},\"allow_forking\":true,\"is_template\":false,\"web_commit_signoff_required\":false,\"has_pull_requests\":true,\"pull_request_creation_policy\":\"collaborators_only\",\"topics\":[],\"visibility\":\"public\",\"forks\":20587,\"open_issues\":442,\"watchers\":242062,\"default_branch\":\"main\",\"permissions\":{\"admin\":false,\"maintain\":false,\"push\":false,\"triage\":false,\"pull\":true}}",
  "sort": "",
  "username": "FiscalMindset"
}

columns (4)

directionjsonsortusername

trial 2·33081ms·rows 25isError=false

First row (click to expand JSON)

{
  "direction": "",
  "json": "{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"full_name\":\"mattpocock/skills\",\"private\":false,\"owner\":{\"login\":\"mattpocock\",\"id\":28293365,\"node_id\":\"MDQ6VXNlcjI4MjkzMzY1\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/28293365?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/mattpocock\",\"html_url\":\"https://github.com/mattpocock\",\"followers_url\":\"https://api.github.com/users/mattpocock/followers\",\"following_url\":\"https://api.github.com/users/mattpocock/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/mattpocock/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/mattpocock/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/mattpocock/subscriptions\",\"organizations_url\":\"https://api.github.com/users/mattpocock/orgs\",\"repos_url\":\"https://api.github.com/users/mattpocock/repos\",\"events_url\":\"https://api.github.com/users/mattpocock/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/mattpocock/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false},\"html_url\":\"https://github.com/mattpocock/skills\",\"description\":\"Skills for Real Engineers. Straight from my .agents directory.\",\"fork\":false,\"url\":\"https://api.github.com/repos/mattpocock/skills\",\"forks_url\":\"https://api.github.com/repos/mattpocock/skills/forks\",\"keys_url\":\"https://api.github.com/repos/mattpocock/skills/keys{/key_id}\",\"collaborators_url\":\"https://api.github.com/repos/mattpocock/skills/collaborators{/collaborator}\",\"teams_url\":\"https://api.github.com/repos/mattpocock/skills/teams\",\"hooks_url\":\"https://api.github.com/repos/mattpocock/skills/hooks\",\"issue_events_url\":\"https://api.github.com/repos/mattpocock/skills/issues/events{/number}\",\"events_url\":\"https://api.github.com/repos/mattpocock/skills/events\",\"assignees_url\":\"https://api.github.com/repos/mattpocock/skills/assignees{/user}\",\"branches_url\":\"https://api.github.com/repos/mattpocock/skills/branches{/branch}\",\"tags_url\":\"https://api.github.com/repos/mattpocock/skills/tags\",\"blobs_url\":\"https://api.github.com/repos/mattpocock/skills/git/blobs{/sha}\",\"git_tags_url\":\"https://api.github.com/repos/mattpocock/skills/git/tags{/sha}\",\"git_refs_url\":\"https://api.github.com/repos/mattpocock/skills/git/refs{/sha}\",\"trees_url\":\"https://api.github.com/repos/mattpocock/skills/git/trees{/sha}\",\"statuses_url\":\"https://api.github.com/repos/mattpocock/skills/statuses/{sha}\",\"languages_url\":\"https://api.github.com/repos/mattpocock/skills/languages\",\"stargazers_url\":\"https://api.github.com/repos/mattpocock/skills/stargazers\",\"contributors_url\":\"https://api.github.com/repos/mattpocock/skills/contributors\",\"subscribers_url\":\"https://api.github.com/repos/mattpocock/skills/subscribers\",\"subscription_url\":\"https://api.github.com/repos/mattpocock/skills/subscription\",\"commits_url\":\"https://api.github.com/repos/mattpocock/skills/commits{/sha}\",\"git_commits_url\":\"https://api.github.com/repos/mattpocock/skills/git/commits{/sha}\",\"comments_url\":\"https://api.github.com/repos/mattpocock/skills/comments{/number}\",\"issue_comment_url\":\"https://api.github.com/repos/mattpocock/skills/issues/comments{/number}\",\"contents_url\":\"https://api.github.com/repos/mattpocock/skills/contents/{+path}\",\"compare_url\":\"https://api.github.com/repos/mattpocock/skills/compare/{base}...{head}\",\"merges_url\":\"https://api.github.com/repos/mattpocock/skills/merges\",\"archive_url\":\"https://api.github.com/repos/mattpocock/skills/{archive_format}{/ref}\",\"downloads_url\":\"https://api.github.com/repos/mattpocock/skills/downloads\",\"issues_url\":\"https://api.github.com/repos/mattpocock/skills/issues{/number}\",\"pulls_url\":\"https://api.github.com/repos/mattpocock/skills/pulls{/number}\",\"milestones_url\":\"https://api.github.com/repos/mattpocock/skills/milestones{/number}\",\"notifications_url\":\"https://api.github.com/repos/mattpocock/skills/notifications{?since,all,participating}\",\"labels_url\":\"https://api.github.com/repos/mattpocock/skills/labels{/name}\",\"releases_url\":\"https://api.github.com/repos/mattpocock/skills/releases{/id}\",\"deployments_url\":\"https://api.github.com/repos/mattpocock/skills/deployments\",\"created_at\":\"2026-02-03T11:15:53Z\",\"updated_at\":\"2026-08-31T05:24:31Z\",\"pushed_at\":\"2026-08-24T14:20:17Z\",\"git_url\":\"git://github.com/mattpocock/skills.git\",\"ssh_url\":\"git@github.com:mattpocock/skills.git\",\"clone_url\":\"https://github.com/mattpocock/skills.git\",\"svn_url\":\"https://github.com/mattpocock/skills\",\"homepage\":\"https://aihero.dev/skills\",\"size\":1548,\"stargazers_count\":242062,\"watchers_count\":242062,\"language\":\"Shell\",\"has_issues\":true,\"has_projects\":true,\"has_downloads\":false,\"has_wiki\":false,\"has_pages\":false,\"has_discussions\":true,\"forks_count\":20587,\"mirror_url\":null,\"archived\":false,\"disabled\":false,\"open_issues_count\":442,\"license\":{\"key\":\"mit\",\"name\":\"MIT License\",\"spdx_id\":\"MIT\",\"url\":\"https://api.github.com/licenses/mit\",\"node_id\":\"MDc6TGljZW5zZTEz\"},\"allow_forking\":true,\"is_template\":false,\"web_commit_signoff_required\":false,\"has_pull_requests\":true,\"pull_request_creation_policy\":\"collaborators_only\",\"topics\":[],\"visibility\":\"public\",\"forks\":20587,\"open_issues\":442,\"watchers\":242062,\"default_branch\":\"main\",\"permissions\":{\"admin\":false,\"maintain\":false,\"push\":false,\"triage\":false,\"pull\":true}}",
  "sort": "",
  "username": "FiscalMindset"
}

columns (4)

directionjsonsortusername

edge2 trials

min 29868ms · median 31249ms · max 32631ms · rows 26,26

edge: larger limit

Command

SELECT * FROM github.activity_list_repos_starred_by_user WHERE username = 'FiscalMindset' LIMIT 200

Trials + output

trial 1·29868ms·rows 26isError=false

First row (click to expand JSON)

{
  "direction": "",
  "json": "{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"full_name\":\"mattpocock/skills\",\"private\":false,\"owner\":{\"login\":\"mattpocock\",\"id\":28293365,\"node_id\":\"MDQ6VXNlcjI4MjkzMzY1\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/28293365?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/mattpocock\",\"html_url\":\"https://github.com/mattpocock\",\"followers_url\":\"https://api.github.com/users/mattpocock/followers\",\"following_url\":\"https://api.github.com/users/mattpocock/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/mattpocock/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/mattpocock/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/mattpocock/subscriptions\",\"organizations_url\":\"https://api.github.com/users/mattpocock/orgs\",\"repos_url\":\"https://api.github.com/users/mattpocock/repos\",\"events_url\":\"https://api.github.com/users/mattpocock/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/mattpocock/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false},\"html_url\":\"https://github.com/mattpocock/skills\",\"description\":\"Skills for Real Engineers. Straight from my .agents directory.\",\"fork\":false,\"url\":\"https://api.github.com/repos/mattpocock/skills\",\"forks_url\":\"https://api.github.com/repos/mattpocock/skills/forks\",\"keys_url\":\"https://api.github.com/repos/mattpocock/skills/keys{/key_id}\",\"collaborators_url\":\"https://api.github.com/repos/mattpocock/skills/collaborators{/collaborator}\",\"teams_url\":\"https://api.github.com/repos/mattpocock/skills/teams\",\"hooks_url\":\"https://api.github.com/repos/mattpocock/skills/hooks\",\"issue_events_url\":\"https://api.github.com/repos/mattpocock/skills/issues/events{/number}\",\"events_url\":\"https://api.github.com/repos/mattpocock/skills/events\",\"assignees_url\":\"https://api.github.com/repos/mattpocock/skills/assignees{/user}\",\"branches_url\":\"https://api.github.com/repos/mattpocock/skills/branches{/branch}\",\"tags_url\":\"https://api.github.com/repos/mattpocock/skills/tags\",\"blobs_url\":\"https://api.github.com/repos/mattpocock/skills/git/blobs{/sha}\",\"git_tags_url\":\"https://api.github.com/repos/mattpocock/skills/git/tags{/sha}\",\"git_refs_url\":\"https://api.github.com/repos/mattpocock/skills/git/refs{/sha}\",\"trees_url\":\"https://api.github.com/repos/mattpocock/skills/git/trees{/sha}\",\"statuses_url\":\"https://api.github.com/repos/mattpocock/skills/statuses/{sha}\",\"languages_url\":\"https://api.github.com/repos/mattpocock/skills/languages\",\"stargazers_url\":\"https://api.github.com/repos/mattpocock/skills/stargazers\",\"contributors_url\":\"https://api.github.com/repos/mattpocock/skills/contributors\",\"subscribers_url\":\"https://api.github.com/repos/mattpocock/skills/subscribers\",\"subscription_url\":\"https://api.github.com/repos/mattpocock/skills/subscription\",\"commits_url\":\"https://api.github.com/repos/mattpocock/skills/commits{/sha}\",\"git_commits_url\":\"https://api.github.com/repos/mattpocock/skills/git/commits{/sha}\",\"comments_url\":\"https://api.github.com/repos/mattpocock/skills/comments{/number}\",\"issue_comment_url\":\"https://api.github.com/repos/mattpocock/skills/issues/comments{/number}\",\"contents_url\":\"https://api.github.com/repos/mattpocock/skills/contents/{+path}\",\"compare_url\":\"https://api.github.com/repos/mattpocock/skills/compare/{base}...{head}\",\"merges_url\":\"https://api.github.com/repos/mattpocock/skills/merges\",\"archive_url\":\"https://api.github.com/repos/mattpocock/skills/{archive_format}{/ref}\",\"downloads_url\":\"https://api.github.com/repos/mattpocock/skills/downloads\",\"issues_url\":\"https://api.github.com/repos/mattpocock/skills/issues{/number}\",\"pulls_url\":\"https://api.github.com/repos/mattpocock/skills/pulls{/number}\",\"milestones_url\":\"https://api.github.com/repos/mattpocock/skills/milestones{/number}\",\"notifications_url\":\"https://api.github.com/repos/mattpocock/skills/notifications{?since,all,participating}\",\"labels_url\":\"https://api.github.com/repos/mattpocock/skills/labels{/name}\",\"releases_url\":\"https://api.github.com/repos/mattpocock/skills/releases{/id}\",\"deployments_url\":\"https://api.github.com/repos/mattpocock/skills/deployments\",\"created_at\":\"2026-02-03T11:15:53Z\",\"updated_at\":\"2026-08-31T05:24:31Z\",\"pushed_at\":\"2026-08-24T14:20:17Z\",\"git_url\":\"git://github.com/mattpocock/skills.git\",\"ssh_url\":\"git@github.com:mattpocock/skills.git\",\"clone_url\":\"https://github.com/mattpocock/skills.git\",\"svn_url\":\"https://github.com/mattpocock/skills\",\"homepage\":\"https://aihero.dev/skills\",\"size\":1548,\"stargazers_count\":242062,\"watchers_count\":242062,\"language\":\"Shell\",\"has_issues\":true,\"has_projects\":true,\"has_downloads\":false,\"has_wiki\":false,\"has_pages\":false,\"has_discussions\":true,\"forks_count\":20587,\"mirror_url\":null,\"archived\":false,\"disabled\":false,\"open_issues_count\":442,\"license\":{\"key\":\"mit\",\"name\":\"MIT License\",\"spdx_id\":\"MIT\",\"url\":\"https://api.github.com/licenses/mit\",\"node_id\":\"MDc6TGljZW5zZTEz\"},\"allow_forking\":true,\"is_template\":false,\"web_commit_signoff_required\":false,\"has_pull_requests\":true,\"pull_request_creation_policy\":\"collaborators_only\",\"topics\":[],\"visibility\":\"public\",\"forks\":20587,\"open_issues\":442,\"watchers\":242062,\"default_branch\":\"main\",\"permissions\":{\"admin\":false,\"maintain\":false,\"push\":false,\"triage\":false,\"pull\":true}}",
  "sort": "",
  "username": "FiscalMindset"
}

columns (4)

directionjsonsortusername

trial 2·32631ms·rows 26isError=false

First row (click to expand JSON)

{
  "direction": "",
  "json": "{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"full_name\":\"mattpocock/skills\",\"private\":false,\"owner\":{\"login\":\"mattpocock\",\"id\":28293365,\"node_id\":\"MDQ6VXNlcjI4MjkzMzY1\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/28293365?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/mattpocock\",\"html_url\":\"https://github.com/mattpocock\",\"followers_url\":\"https://api.github.com/users/mattpocock/followers\",\"following_url\":\"https://api.github.com/users/mattpocock/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/mattpocock/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/mattpocock/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/mattpocock/subscriptions\",\"organizations_url\":\"https://api.github.com/users/mattpocock/orgs\",\"repos_url\":\"https://api.github.com/users/mattpocock/repos\",\"events_url\":\"https://api.github.com/users/mattpocock/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/mattpocock/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false},\"html_url\":\"https://github.com/mattpocock/skills\",\"description\":\"Skills for Real Engineers. Straight from my .agents directory.\",\"fork\":false,\"url\":\"https://api.github.com/repos/mattpocock/skills\",\"forks_url\":\"https://api.github.com/repos/mattpocock/skills/forks\",\"keys_url\":\"https://api.github.com/repos/mattpocock/skills/keys{/key_id}\",\"collaborators_url\":\"https://api.github.com/repos/mattpocock/skills/collaborators{/collaborator}\",\"teams_url\":\"https://api.github.com/repos/mattpocock/skills/teams\",\"hooks_url\":\"https://api.github.com/repos/mattpocock/skills/hooks\",\"issue_events_url\":\"https://api.github.com/repos/mattpocock/skills/issues/events{/number}\",\"events_url\":\"https://api.github.com/repos/mattpocock/skills/events\",\"assignees_url\":\"https://api.github.com/repos/mattpocock/skills/assignees{/user}\",\"branches_url\":\"https://api.github.com/repos/mattpocock/skills/branches{/branch}\",\"tags_url\":\"https://api.github.com/repos/mattpocock/skills/tags\",\"blobs_url\":\"https://api.github.com/repos/mattpocock/skills/git/blobs{/sha}\",\"git_tags_url\":\"https://api.github.com/repos/mattpocock/skills/git/tags{/sha}\",\"git_refs_url\":\"https://api.github.com/repos/mattpocock/skills/git/refs{/sha}\",\"trees_url\":\"https://api.github.com/repos/mattpocock/skills/git/trees{/sha}\",\"statuses_url\":\"https://api.github.com/repos/mattpocock/skills/statuses/{sha}\",\"languages_url\":\"https://api.github.com/repos/mattpocock/skills/languages\",\"stargazers_url\":\"https://api.github.com/repos/mattpocock/skills/stargazers\",\"contributors_url\":\"https://api.github.com/repos/mattpocock/skills/contributors\",\"subscribers_url\":\"https://api.github.com/repos/mattpocock/skills/subscribers\",\"subscription_url\":\"https://api.github.com/repos/mattpocock/skills/subscription\",\"commits_url\":\"https://api.github.com/repos/mattpocock/skills/commits{/sha}\",\"git_commits_url\":\"https://api.github.com/repos/mattpocock/skills/git/commits{/sha}\",\"comments_url\":\"https://api.github.com/repos/mattpocock/skills/comments{/number}\",\"issue_comment_url\":\"https://api.github.com/repos/mattpocock/skills/issues/comments{/number}\",\"contents_url\":\"https://api.github.com/repos/mattpocock/skills/contents/{+path}\",\"compare_url\":\"https://api.github.com/repos/mattpocock/skills/compare/{base}...{head}\",\"merges_url\":\"https://api.github.com/repos/mattpocock/skills/merges\",\"archive_url\":\"https://api.github.com/repos/mattpocock/skills/{archive_format}{/ref}\",\"downloads_url\":\"https://api.github.com/repos/mattpocock/skills/downloads\",\"issues_url\":\"https://api.github.com/repos/mattpocock/skills/issues{/number}\",\"pulls_url\":\"https://api.github.com/repos/mattpocock/skills/pulls{/number}\",\"milestones_url\":\"https://api.github.com/repos/mattpocock/skills/milestones{/number}\",\"notifications_url\":\"https://api.github.com/repos/mattpocock/skills/notifications{?since,all,participating}\",\"labels_url\":\"https://api.github.com/repos/mattpocock/skills/labels{/name}\",\"releases_url\":\"https://api.github.com/repos/mattpocock/skills/releases{/id}\",\"deployments_url\":\"https://api.github.com/repos/mattpocock/skills/deployments\",\"created_at\":\"2026-02-03T11:15:53Z\",\"updated_at\":\"2026-08-31T05:26:32Z\",\"pushed_at\":\"2026-08-24T14:20:17Z\",\"git_url\":\"git://github.com/mattpocock/skills.git\",\"ssh_url\":\"git@github.com:mattpocock/skills.git\",\"clone_url\":\"https://github.com/mattpocock/skills.git\",\"svn_url\":\"https://github.com/mattpocock/skills\",\"homepage\":\"https://aihero.dev/skills\",\"size\":1548,\"stargazers_count\":242063,\"watchers_count\":242063,\"language\":\"Shell\",\"has_issues\":true,\"has_projects\":true,\"has_downloads\":false,\"has_wiki\":false,\"has_pages\":false,\"has_discussions\":true,\"forks_count\":20587,\"mirror_url\":null,\"archived\":false,\"disabled\":false,\"open_issues_count\":442,\"license\":{\"key\":\"mit\",\"name\":\"MIT License\",\"spdx_id\":\"MIT\",\"url\":\"https://api.github.com/licenses/mit\",\"node_id\":\"MDc6TGljZW5zZTEz\"},\"allow_forking\":true,\"is_template\":false,\"web_commit_signoff_required\":false,\"has_pull_requests\":true,\"pull_request_creation_policy\":\"collaborators_only\",\"topics\":[],\"visibility\":\"public\",\"forks\":20587,\"open_issues\":442,\"watchers\":242063,\"default_branch\":\"main\",\"permissions\":{\"admin\":false,\"maintain\":false,\"push\":false,\"triage\":false,\"pull\":true}}",
  "sort": "",
  "username": "FiscalMindset"
}

columns (4)

directionjsonsortusername

All returned rowsacross all non-errored trials · filterable · paginated

104 rows stored · 104 returned · page 1/5


1	0	—	{"id":1148788086,"node_id":"R_kgDORHkddg","name":"skills","full_name":"mattpoco…	—	FiscalMindset
2	1	—	{"id":1148788086,"node_id":"R_kgDORHkddg","name":"skills","full_name":"mattpoco…	—	FiscalMindset
1	2	—	{"id":1148788086,"node_id":"R_kgDORHkddg","name":"skills","full_name":"mattpoco…	—	FiscalMindset
1	3	—	{"id":1309751899,"node_id":"R_kgDOThE6Ww","name":"trueforge","full_name":"truef…	—	FiscalMindset
1	4	—	{"id":748030359,"node_id":"R_kgDOLJYJlw","name":"GraphRAG-SDK","full_name":"Fal…	—	FiscalMindset
1	5	—	{"id":1175168650,"node_id":"R_kgDORgumig","name":"cli","full_name":"brightdata/…	—	FiscalMindset
1	6	—	{"id":668673665,"node_id":"R_kgDOJ9smgQ","name":"FalkorDB","full_name":"FalkorD…	—	FiscalMindset
1	7	—	{"id":1316527318,"node_id":"R_kgDOTnic1g","name":"qm","full_name":"yc-software/…	—	FiscalMindset
1	8	—	{"id":1293989750,"node_id":"R_kgDOTSC3dg","name":"Clipo","full_name":"SACHINN12…	—	FiscalMindset
1	9	—	{"id":326404870,"node_id":"MDEwOlJlcG9zaXRvcnkzMjY0MDQ4NzA=","name":"signoz","f…	—	FiscalMindset
1	10	—	{"id":1287654367,"node_id":"R_kgDOTMAL3w","name":"JanAdhikar","full_name":"Fisc…	—	FiscalMindset
1	11	—	{"id":1252432466,"node_id":"R_kgDOSqaaUg","name":"zero","full_name":"Gitlawb/ze…	—	FiscalMindset
1	12	—	{"id":1278527983,"node_id":"R_kgDOTDTJ7w","name":"article","full_name":"FiscalM…	—	FiscalMindset
1	13	—	{"id":787076358,"node_id":"R_kgDOLunVBg","name":"firecrawl","full_name":"firecr…	—	FiscalMindset
1	14	—	{"id":679343504,"node_id":"R_kgDOKH31kA","name":"cognee","full_name":"topoteret…	—	FiscalMindset
1	15	—	{"id":1187694119,"node_id":"R_kgDORsrGJw","name":"algsoch","full_name":"FiscalM…	—	FiscalMindset
1	16	—	{"id":975734319,"node_id":"R_kgDOOiiGLw","name":"opencode","full_name":"anomaly…	—	FiscalMindset
1	17	—	{"id":1264367236,"node_id":"R_kgDOS1y2hA","name":"polybazar","full_name":"Fisca…	—	FiscalMindset
1	18	—	{"id":1036205124,"node_id":"R_kgDOPcM8RA","name":"Vision-Agents","full_name":"G…	—	FiscalMindset
1	19	—	{"id":1255180606,"node_id":"R_kgDOStCJPg","name":"odysseus","full_name":"odysse…	—	FiscalMindset
1	20	—	{"id":1248211466,"node_id":"R_kgDOSmYyCg","name":"coral","full_name":"FiscalMin…	—	FiscalMindset
1	21	—	{"id":1204057895,"node_id":"R_kgDOR8R3Jw","name":"kimchi","full_name":"getkimch…	—	FiscalMindset
1	22	—	{"id":1253307851,"node_id":"R_kgDOSrP1yw","name":"careops","full_name":"FiscalM…	—	FiscalMindset
1	23	—	{"id":1152600431,"node_id":"R_kgDORLNJbw","name":"git-lrc","full_name":"HexmosT…	—	FiscalMindset
1	24	—	{"id":1200798950,"node_id":"R_kgDOR5K85g","name":"coral","full_name":"withcoral…	—	FiscalMindset

Column profile

4 columns actually returned by coral. Catalog claims "1 required filter(s)": "username". Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	direction	—	0	6	empty
2	json	string	6	0	`"{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"f""{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"f""{\"id\":1148788086,\"node_id\":\"R_kgDORHkddg\",\"name\":\"skills\",\"f"`
3	sort	—	0	6	empty
4	username	string	6	0	`"FiscalMindset"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	21232ms	1	ok	direction, json, sort
minimal	t2	22943ms	1	ok	direction, json, sort
realistic	t1	22301ms	25	ok	direction, json, sort
realistic	t2	33081ms	25	ok	direction, json, sort
edge	t1	29868ms	26	ok	direction, json, sort
edge	t2	32631ms	26	ok	direction, json, sort

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires username. Most useful optional filters: sort, direction. Use LIMIT for spot checks; large result sets paginate quickly.

Columns coral returned (4)

directionjsonsortusername

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T05:24:01Z

JSON record: reports/github/tables/activity_list_repos_starred_by_user.json

first_run_at: 2026-08-31T05:19:34Z

last_retried_at: 2026-08-31T05:24:01Z

retry_count: 1

View version history →