`github.databases`

pass

List CodeQL databases for a repository

Requires owner and repo. Most useful optional filters: language. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

owner, repo captured 2026-08-31 05:54:25Zmedian 28495 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	31655 ms	32189 ms	32724 ms	[1, 1]
realistic	2	27971 ms	28495 ms	29020 ms	[2, 2]
edge	2	28971 ms	30594 ms	32218 ms	[2, 2]

Latency per trial

minimalmedian 32189ms

scale: 0–32724 ms

realisticmedian 28495ms

scale: 0–29020 ms

edgemedian 30594ms

scale: 0–32218 ms

Probe variants — every command + output

minimal2 trials

min 31655ms · median 32189ms · max 32724ms · rows 1,1

smallest valid query

Command

SELECT * FROM github.databases WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 1

Trials + output

trial 1·31655ms·rows 1isError=false

First row (click to expand JSON)

{
  "commit_oid": "a7444bf944c219b9eaba2f794847b3001237795f",
  "content_type": "application/zip",
  "created_at": "2026-08-25T14:53:07Z",
  "id": "497890010",
  "language": "javascript",
  "name": "database.zip",
  "owner": "anomalyco",
  "repo": "opencode",
  "size": "61026471",
  "updated_at": "2026-08-25T14:53:09Z",
  "uploader": "{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node_id\":\"MDM6Qm90NjIzMTA4MTU=\",\"avatar_url\":\"https://avatars.githubusercontent.com/in/57789?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D\",\"html_url\":\"https://github.com/apps/github-advanced-security\",\"followers_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/followers\",\"following_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions\",\"organizations_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs\",\"repos_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/repos\",\"events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events\",\"type\":\"Bot\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "uploader__avatar_url": "https://avatars.githubusercontent.com/in/57789?v=4",
  "uploader__email": "",
  "uploader__events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}",
  "uploader__followers_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/followers",
  "uploader__following_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}",
  "uploader__gists_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}",
  "uploader__gravatar_id": "",
  "uploader__html_url": "https://github.com/apps/github-advanced-security",
  "uploader__id": "62310815",
  "uploader__login": "github-advanced-security[bot]",
  "uploader__name": "",
  "uploader__node_id": "MDM6Qm90NjIzMTA4MTU=",
  "uploader__organizations_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs",
  "uploader__received_events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events",
  "uploader__repos_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/repos",
  "uploader__site_admin": "false",
  "uploader__starred_at": "",
  "uploader__starred_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}",
  "uploader__subscriptions_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions",
  "uploader__type": "Bot",
  "uploader__url": "https://api.github.com/users/github-advanced-security%5Bbot%5D",
  "uploader__user_view_type": "public",
  "url": "https://api.github.com/repositories/975734319/code-scanning/codeql/databases/javascript"
}

columns (34)

commit_oidcontent_typecreated_atidlanguagenameownerreposizeupdated_atuploaderuploader__avatar_urluploader__emailuploader__events_urluploader__followers_urluploader__following_urluploader__gists_urluploader__gravatar_iduploader__html_urluploader__iduploader__loginuploader__nameuploader__node_iduploader__organizations_urluploader__received_events_urluploader__repos_urluploader__site_adminuploader__starred_atuploader__starred_urluploader__subscriptions_urluploader__typeuploader__urluploader__user_view_typeurl

trial 2·32724ms·rows 1isError=false

First row (click to expand JSON)

{
  "commit_oid": "a7444bf944c219b9eaba2f794847b3001237795f",
  "content_type": "application/zip",
  "created_at": "2026-08-25T14:53:07Z",
  "id": "497890010",
  "language": "javascript",
  "name": "database.zip",
  "owner": "anomalyco",
  "repo": "opencode",
  "size": "61026471",
  "updated_at": "2026-08-25T14:53:09Z",
  "uploader": "{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node_id\":\"MDM6Qm90NjIzMTA4MTU=\",\"avatar_url\":\"https://avatars.githubusercontent.com/in/57789?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D\",\"html_url\":\"https://github.com/apps/github-advanced-security\",\"followers_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/followers\",\"following_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions\",\"organizations_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs\",\"repos_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/repos\",\"events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events\",\"type\":\"Bot\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "uploader__avatar_url": "https://avatars.githubusercontent.com/in/57789?v=4",
  "uploader__email": "",
  "uploader__events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}",
  "uploader__followers_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/followers",
  "uploader__following_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}",
  "uploader__gists_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}",
  "uploader__gravatar_id": "",
  "uploader__html_url": "https://github.com/apps/github-advanced-security",
  "uploader__id": "62310815",
  "uploader__login": "github-advanced-security[bot]",
  "uploader__name": "",
  "uploader__node_id": "MDM6Qm90NjIzMTA4MTU=",
  "uploader__organizations_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs",
  "uploader__received_events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events",
  "uploader__repos_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/repos",
  "uploader__site_admin": "false",
  "uploader__starred_at": "",
  "uploader__starred_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}",
  "uploader__subscriptions_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions",
  "uploader__type": "Bot",
  "uploader__url": "https://api.github.com/users/github-advanced-security%5Bbot%5D",
  "uploader__user_view_type": "public",
  "url": "https://api.github.com/repositories/975734319/code-scanning/codeql/databases/javascript"
}

columns (34)

realistic2 trials

min 27971ms · median 28495ms · max 29020ms · rows 2,2

typical user query

Command

SELECT * FROM github.databases WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 25

Trials + output

trial 1·27971ms·rows 2isError=false

First row (click to expand JSON)

{
  "commit_oid": "a7444bf944c219b9eaba2f794847b3001237795f",
  "content_type": "application/zip",
  "created_at": "2026-08-25T14:53:07Z",
  "id": "497890010",
  "language": "javascript",
  "name": "database.zip",
  "owner": "anomalyco",
  "repo": "opencode",
  "size": "61026471",
  "updated_at": "2026-08-25T14:53:09Z",
  "uploader": "{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node_id\":\"MDM6Qm90NjIzMTA4MTU=\",\"avatar_url\":\"https://avatars.githubusercontent.com/in/57789?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D\",\"html_url\":\"https://github.com/apps/github-advanced-security\",\"followers_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/followers\",\"following_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions\",\"organizations_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs\",\"repos_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/repos\",\"events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events\",\"type\":\"Bot\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "uploader__avatar_url": "https://avatars.githubusercontent.com/in/57789?v=4",
  "uploader__email": "",
  "uploader__events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}",
  "uploader__followers_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/followers",
  "uploader__following_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}",
  "uploader__gists_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}",
  "uploader__gravatar_id": "",
  "uploader__html_url": "https://github.com/apps/github-advanced-security",
  "uploader__id": "62310815",
  "uploader__login": "github-advanced-security[bot]",
  "uploader__name": "",
  "uploader__node_id": "MDM6Qm90NjIzMTA4MTU=",
  "uploader__organizations_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs",
  "uploader__received_events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events",
  "uploader__repos_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/repos",
  "uploader__site_admin": "false",
  "uploader__starred_at": "",
  "uploader__starred_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}",
  "uploader__subscriptions_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions",
  "uploader__type": "Bot",
  "uploader__url": "https://api.github.com/users/github-advanced-security%5Bbot%5D",
  "uploader__user_view_type": "public",
  "url": "https://api.github.com/repositories/975734319/code-scanning/codeql/databases/javascript"
}

columns (34)

trial 2·29020ms·rows 2isError=false

First row (click to expand JSON)

{
  "commit_oid": "a7444bf944c219b9eaba2f794847b3001237795f",
  "content_type": "application/zip",
  "created_at": "2026-08-25T14:53:07Z",
  "id": "497890010",
  "language": "javascript",
  "name": "database.zip",
  "owner": "anomalyco",
  "repo": "opencode",
  "size": "61026471",
  "updated_at": "2026-08-25T14:53:09Z",
  "uploader": "{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node_id\":\"MDM6Qm90NjIzMTA4MTU=\",\"avatar_url\":\"https://avatars.githubusercontent.com/in/57789?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D\",\"html_url\":\"https://github.com/apps/github-advanced-security\",\"followers_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/followers\",\"following_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions\",\"organizations_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs\",\"repos_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/repos\",\"events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events\",\"type\":\"Bot\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "uploader__avatar_url": "https://avatars.githubusercontent.com/in/57789?v=4",
  "uploader__email": "",
  "uploader__events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}",
  "uploader__followers_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/followers",
  "uploader__following_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}",
  "uploader__gists_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}",
  "uploader__gravatar_id": "",
  "uploader__html_url": "https://github.com/apps/github-advanced-security",
  "uploader__id": "62310815",
  "uploader__login": "github-advanced-security[bot]",
  "uploader__name": "",
  "uploader__node_id": "MDM6Qm90NjIzMTA4MTU=",
  "uploader__organizations_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs",
  "uploader__received_events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events",
  "uploader__repos_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/repos",
  "uploader__site_admin": "false",
  "uploader__starred_at": "",
  "uploader__starred_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}",
  "uploader__subscriptions_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions",
  "uploader__type": "Bot",
  "uploader__url": "https://api.github.com/users/github-advanced-security%5Bbot%5D",
  "uploader__user_view_type": "public",
  "url": "https://api.github.com/repositories/975734319/code-scanning/codeql/databases/javascript"
}

columns (34)

edge2 trials

min 28971ms · median 30594ms · max 32218ms · rows 2,2

edge: larger limit

Command

SELECT * FROM github.databases WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 200

Trials + output

trial 1·28971ms·rows 2isError=false

First row (click to expand JSON)

{
  "commit_oid": "a7444bf944c219b9eaba2f794847b3001237795f",
  "content_type": "application/zip",
  "created_at": "2026-08-25T14:53:07Z",
  "id": "497890010",
  "language": "javascript",
  "name": "database.zip",
  "owner": "anomalyco",
  "repo": "opencode",
  "size": "61026471",
  "updated_at": "2026-08-25T14:53:09Z",
  "uploader": "{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node_id\":\"MDM6Qm90NjIzMTA4MTU=\",\"avatar_url\":\"https://avatars.githubusercontent.com/in/57789?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D\",\"html_url\":\"https://github.com/apps/github-advanced-security\",\"followers_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/followers\",\"following_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions\",\"organizations_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs\",\"repos_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/repos\",\"events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events\",\"type\":\"Bot\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "uploader__avatar_url": "https://avatars.githubusercontent.com/in/57789?v=4",
  "uploader__email": "",
  "uploader__events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}",
  "uploader__followers_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/followers",
  "uploader__following_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}",
  "uploader__gists_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}",
  "uploader__gravatar_id": "",
  "uploader__html_url": "https://github.com/apps/github-advanced-security",
  "uploader__id": "62310815",
  "uploader__login": "github-advanced-security[bot]",
  "uploader__name": "",
  "uploader__node_id": "MDM6Qm90NjIzMTA4MTU=",
  "uploader__organizations_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs",
  "uploader__received_events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events",
  "uploader__repos_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/repos",
  "uploader__site_admin": "false",
  "uploader__starred_at": "",
  "uploader__starred_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}",
  "uploader__subscriptions_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions",
  "uploader__type": "Bot",
  "uploader__url": "https://api.github.com/users/github-advanced-security%5Bbot%5D",
  "uploader__user_view_type": "public",
  "url": "https://api.github.com/repositories/975734319/code-scanning/codeql/databases/javascript"
}

columns (34)

trial 2·32218ms·rows 2isError=false

First row (click to expand JSON)

{
  "commit_oid": "a7444bf944c219b9eaba2f794847b3001237795f",
  "content_type": "application/zip",
  "created_at": "2026-08-25T14:53:07Z",
  "id": "497890010",
  "language": "javascript",
  "name": "database.zip",
  "owner": "anomalyco",
  "repo": "opencode",
  "size": "61026471",
  "updated_at": "2026-08-25T14:53:09Z",
  "uploader": "{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node_id\":\"MDM6Qm90NjIzMTA4MTU=\",\"avatar_url\":\"https://avatars.githubusercontent.com/in/57789?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D\",\"html_url\":\"https://github.com/apps/github-advanced-security\",\"followers_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/followers\",\"following_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions\",\"organizations_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs\",\"repos_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/repos\",\"events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events\",\"type\":\"Bot\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "uploader__avatar_url": "https://avatars.githubusercontent.com/in/57789?v=4",
  "uploader__email": "",
  "uploader__events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}",
  "uploader__followers_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/followers",
  "uploader__following_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other_user}",
  "uploader__gists_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}",
  "uploader__gravatar_id": "",
  "uploader__html_url": "https://github.com/apps/github-advanced-security",
  "uploader__id": "62310815",
  "uploader__login": "github-advanced-security[bot]",
  "uploader__name": "",
  "uploader__node_id": "MDM6Qm90NjIzMTA4MTU=",
  "uploader__organizations_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs",
  "uploader__received_events_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events",
  "uploader__repos_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/repos",
  "uploader__site_admin": "false",
  "uploader__starred_at": "",
  "uploader__starred_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{/repo}",
  "uploader__subscriptions_url": "https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions",
  "uploader__type": "Bot",
  "uploader__url": "https://api.github.com/users/github-advanced-security%5Bbot%5D",
  "uploader__user_view_type": "public",
  "url": "https://api.github.com/repositories/975734319/code-scanning/codeql/databases/javascript"
}

columns (34)

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

10 rows stored · 10 returned · page 1/1


1	0	a7444bf944c219b9eaba2f794847b3001237795f	application/zip	2026-08-25T14:53:07Z	497890010	javascript	database.zip	anomalyco	opencode	61026471	2026-08-25T14:53:09Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/ja…
2	1	a7444bf944c219b9eaba2f794847b3001237795f	application/zip	2026-08-25T14:53:07Z	497890010	javascript	database.zip	anomalyco	opencode	61026471	2026-08-25T14:53:09Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/ja…
1	2	a7444bf944c219b9eaba2f794847b3001237795f	application/zip	2026-08-25T14:53:07Z	497890010	javascript	database.zip	anomalyco	opencode	61026471	2026-08-25T14:53:09Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/ja…
1	3	8e816a9283b9a9b5caf8413df7461abc4017ee1b	application/zip	2025-12-06T16:14:25Z	250229105	go	database.zip	anomalyco	opencode	975772	2025-12-06T16:14:26Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/go
2	4	a7444bf944c219b9eaba2f794847b3001237795f	application/zip	2026-08-25T14:53:07Z	497890010	javascript	database.zip	anomalyco	opencode	61026471	2026-08-25T14:53:09Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/ja…
2	5	8e816a9283b9a9b5caf8413df7461abc4017ee1b	application/zip	2025-12-06T16:14:25Z	250229105	go	database.zip	anomalyco	opencode	975772	2025-12-06T16:14:26Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/go
1	6	a7444bf944c219b9eaba2f794847b3001237795f	application/zip	2026-08-25T14:53:07Z	497890010	javascript	database.zip	anomalyco	opencode	61026471	2026-08-25T14:53:09Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/ja…
1	7	8e816a9283b9a9b5caf8413df7461abc4017ee1b	application/zip	2025-12-06T16:14:25Z	250229105	go	database.zip	anomalyco	opencode	975772	2025-12-06T16:14:26Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/go
2	8	a7444bf944c219b9eaba2f794847b3001237795f	application/zip	2026-08-25T14:53:07Z	497890010	javascript	database.zip	anomalyco	opencode	61026471	2026-08-25T14:53:09Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/ja…
2	9	8e816a9283b9a9b5caf8413df7461abc4017ee1b	application/zip	2025-12-06T16:14:25Z	250229105	go	database.zip	anomalyco	opencode	975772	2025-12-06T16:14:26Z	{"login":"github-advanced-security[bot]","id":62310815,"node_id":"MDM6Qm90NjIzM…	https://avatars.githubusercontent.com/in/57789?v=4	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/events{/privacy}	https://api.github.com/users/github-advanced-security%5Bbot%5D/followers	https://api.github.com/users/github-advanced-security%5Bbot%5D/following{/other…	https://api.github.com/users/github-advanced-security%5Bbot%5D/gists{/gist_id}	—	https://github.com/apps/github-advanced-security	62310815	github-advanced-security[bot]	—	MDM6Qm90NjIzMTA4MTU=	https://api.github.com/users/github-advanced-security%5Bbot%5D/orgs	https://api.github.com/users/github-advanced-security%5Bbot%5D/received_events	https://api.github.com/users/github-advanced-security%5Bbot%5D/repos	false	—	https://api.github.com/users/github-advanced-security%5Bbot%5D/starred{/owner}{…	https://api.github.com/users/github-advanced-security%5Bbot%5D/subscriptions	Bot	https://api.github.com/users/github-advanced-security%5Bbot%5D	public	https://api.github.com/repositories/975734319/code-scanning/codeql/databases/go

Column profile

34 columns actually returned by coral. Catalog claims "2 required filter(s)": "owner, repo". Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	commit_oid	string	6	0	`"a7444bf944c219b9eaba2f794847b3001237795f"`
2	content_type	string	6	0	`"application/zip"`
3	created_at	string	6	0	`"2026-08-25T14:53:07Z"`
4	id	string	6	0	`"497890010"`
5	language	string	6	0	`"javascript"`
6	name	string	6	0	`"database.zip"`
7	owner	string	6	0	`"anomalyco"`
8	repo	string	6	0	`"opencode"`
9	size	string	6	0	`"61026471"`
10	updated_at	string	6	0	`"2026-08-25T14:53:09Z"`
11	uploader	string	6	0	`"{\"login\":\"github-advanced-security[bot]\",\"id\":62310815,\"node"`
12	uploader__avatar_url	string	6	0	`"https://avatars.githubusercontent.com/in/57789?v=4"`
13	uploader__email	—	0	6	empty
14	uploader__events_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
15	uploader__followers_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
16	uploader__following_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
17	uploader__gists_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
18	uploader__gravatar_id	—	0	6	empty
19	uploader__html_url	string	6	0	`"https://github.com/apps/github-advanced-security"`
20	uploader__id	string	6	0	`"62310815"`
21	uploader__login	string	6	0	`"github-advanced-security[bot]"`
22	uploader__name	—	0	6	empty
23	uploader__node_id	string	6	0	`"MDM6Qm90NjIzMTA4MTU="`
24	uploader__organizations_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
25	uploader__received_events_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
26	uploader__repos_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
27	uploader__site_admin	string	6	0	`"false"`
28	uploader__starred_at	—	0	6	empty
29	uploader__starred_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
30	uploader__subscriptions_url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
31	uploader__type	string	6	0	`"Bot"`
32	uploader__url	string	6	0	`"https://api.github.com/users/github-advanced-security%5Bbot%"`
33	uploader__user_view_type	string	6	0	`"public"`
34	url	string	6	0	`"https://api.github.com/repositories/975734319/code-scanning/"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	31655ms	1	ok	commit_oid, content_type, created_at
minimal	t2	32724ms	1	ok	commit_oid, content_type, created_at
realistic	t1	27971ms	2	ok	commit_oid, content_type, created_at
realistic	t2	29020ms	2	ok	commit_oid, content_type, created_at
edge	t1	28971ms	2	ok	commit_oid, content_type, created_at
edge	t2	32218ms	2	ok	commit_oid, content_type, created_at

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires owner and repo. Most useful optional filters: language. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

Columns coral returned (34)

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T05:54:25Z

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

first_run_at: 2026-08-31T05:54:25Z

last_retried_at: 2026-08-31T05:54:25Z

retry_count: 0

View version history →