turbot/kubernetes

GitHub
steampipe plugin install kubernetessteampipe plugin install kubernetes

Table: helm_release

A Helm release is an instance of a chart running in a Kubernetes cluster. When you use the helm install command, it creates a release for the chart and generates a set of Kubernetes resources based on the chart's templates and the values provided.

Examples

Basic info

select
name,
namespace,
version,
status,
first_deployed,
chart_name
from
helm_release;

List kubernetes deployment resources deployed using a specific chart

select
d.name as deployment_name,
d.namespace,
d.uid,
r.name as release_name,
r.chart_name,
r.version as release_version,
r.first_deployed as deployed_at
from
kubernetes_deployment as d
left join helm_release as r on (
d.labels ->> 'app.kubernetes.io/managed-by' = 'Helm'
and d.labels ->> 'app.kubernetes.io/instance' = r.name
)
where
r.chart_name = 'ingress-nginx'
and d.source_type = 'deployed';

List all deployed releases of a specific chart

select
name,
namespace,
version,
status,
first_deployed,
chart_name
from
helm_release
where
chart_name = 'ingress-nginx';

List releases from a specific namespace

select
name,
namespace,
version,
status,
last_deployed,
description
from
helm_release
where
namespace = 'steampipe';

List all failed releases

select
name,
namespace,
version,
status,
last_deployed,
description
from
helm_release
where
status = 'failed';

List all unfinished releases

select
name,
namespace,
version,
status,
last_deployed,
description
from
helm_release
where
status = 'pending';

List releases updated in last 3 days

select
name,
namespace,
version,
status,
last_deployed,
description
from
helm_release
where
last_deployed > (now() - interval '3 days');

Get a specific release

select
name,
namespace,
version,
status,
last_deployed,
description
from
helm_release
where
name = 'brigade-github-app-1683552635';

.inspect helm_release

List all of the releases of chart in a Kubernetes cluster

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
chart_nametextThe name of the chart that was released.
configjsonbThe set of extra Values added to the chart. These values override the default values inside of the chart.
deletedtimestamp with time zoneThe time when this object was deleted.
descriptiontextA human-friendly description about the release.
first_deployedtimestamp with time zoneThe time when the release was first deployed.
labelsjsonbThe labels of the release.
last_deployedtimestamp with time zoneThe time when the release was last deployed.
manifesttextThe string representation of the rendered template.
nametextThe name of the release.
namespacetextThe kubernetes namespace of the release.
notestextContains the rendered templates/NOTES.txt if available.
statustextThe current state of the release. Possible values: deployed, failed, pending-install, pending-rollback, pending-upgrade, superseded, uninstalled, uninstalling, unknown.
versionbigintThe revision of the release.