Bulk fetching repository details with the GitHub GraphQL API#

I wanted to be able to fetch details of a list of different repositories from the GitHub GraphQL API by name in a single operation.

It turns out the search() operation can be used for this, given 100 repos at a time. The trick is to use the repo: search operator, e.g repo:simonw/datasette repo:django/django as demonstrated by this search.

Here’s the GraphQL query, tried out using https://docs.github.com/en/graphql/overview/explorer

1
{
2
  search(type: REPOSITORY, query: "repo:simonw/datasette repo:django/django", first: 100) {
3
    nodes {
4
      ... on Repository {
5
        id
6
        nameWithOwner
7
        createdAt
8
        repositoryTopics(first: 100) {
9
          totalCount
10
          nodes {
11
            topic {
12
              name
13
            }
14
          }
15
        }
16
        openIssueCount: issues(states: [OPEN]) {
17
          totalCount
18
        }
19
        closedIssueCount: issues(states: [CLOSED]) {
20
          totalCount
21
        }
22
        releases(last: 1) {
23
          totalCount
24
          nodes {
25
            tagName
26
          }
27
        }
28
      }
29
    }
30
  }
31
}