Table: github_actions_repository_runner - Query GitHub Actions Repository Runners using SQL

GitHub Actions is a CI/CD service provided by GitHub which allows automating software workflows. It enables developers to build, test, and deploy applications on GitHub, making it easier to integrate changes and deliver better software faster. A key feature of GitHub Actions is the ability to use self-hosted runners, which are servers with GitHub Actions runner application installed.

Table Usage Guide

The github_actions_repository_runner table provides insights into the self-hosted runners of GitHub Actions for a specific repository. As a DevOps engineer, you can explore runner-specific details through this table, including runner IDs, names, operating systems, statuses, and associated metadata. Utilize it to manage and monitor your self-hosted runners, ensuring they are functioning properly and are up-to-date.

Important Notes

You must specify the repository_full_name column in where or join clause to query the table.

Examples

List runners

Explore which runners are associated with the 'turbot/steampipe' repository in GitHub Actions. This can be beneficial for maintaining and managing the performance and efficiency of your workflows.

select
  *
from
  github_actions_repository_runner
where
  repository_full_name = 'turbot/steampipe';

select
  *
from
  github_actions_repository_runner
where
  repository_full_name = 'turbot/steampipe';

List runners with mac operating system

Discover the segments that utilize a Mac operating system within a specific repository. This is beneficial for understanding the distribution of operating systems within your project, which can aid in troubleshooting and optimization efforts.

select
  repository_full_name,
  id,
  name,
  os
from
  github_actions_repository_runner
where
  repository_full_name = 'turbot/steampipe'
  and os = 'macos';

select
  repository_full_name,
  id,
  name,
  os
from
  github_actions_repository_runner
where
  repository_full_name = 'turbot/steampipe'
  and os = 'macos';

List runners which are in use currently

This query allows you to identify which runners are currently in use in the specified repository. This can be beneficial for understanding the utilization of resources and managing workflow runs in real-time.

select
  repository_full_name,
  id,
  name,
  os,
  busy
from
  github_actions_repository_runner
where
  repository_full_name = 'turbot/steampipe'
  and busy;

select
  repository_full_name,
  id,
  name,
  os,
  busy
from
  github_actions_repository_runner
where
  repository_full_name = 'turbot/steampipe'
  and busy;

Schema for github_actions_repository_runner

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
busy	boolean		Indicates whether the runner is currently in use or not.
id	bigint	=	The unique identifier of the runner.
labels	jsonb		Labels represents a collection of labels attached to each runner.
login_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the user login.
name	text		The name of the runner.
os	text		The operating system of the runner.
repository_full_name	text	=	Full name of the repository that contains the runners.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the runner.

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_actions_repository_runner