turbot/kubernetes
steampipe plugin install kubernetes

Table: helm_chart - Query Kubernetes Helm Charts using SQL

Kubernetes Helm is a package manager for Kubernetes that allows developers and operators to more easily package, configure, and deploy applications and services onto Kubernetes clusters. Helm uses a packaging format called charts, which include all of the Kubernetes resources that a particular application needs to run. A Helm chart can provide information about the version of the application, the Kubernetes resources that will be used, and any other application-specific information.

Table Usage Guide

The helm_chart table provides insights into Helm Charts within Kubernetes. As a DevOps engineer, explore chart-specific details through this table, including version, status, and associated metadata. Utilize it to uncover information about charts, such as their current status, the version of the application they are deploying, and other application-specific information.

Examples

Basic info

Explore which Helm charts are deprecated by analyzing their basic information, including name, version, and type. This can help in maintaining up-to-date and secure applications by avoiding the use of outdated or deprecated charts.

select
name,
api_version,
version,
deprecated,
type,
description
from
helm_chart;
select
name,
api_version,
version,
deprecated,
type,
description
from
helm_chart;

List all deployed charts

Discover the segments that have been deployed in your Kubernetes environment. This query can be used to get insights into the status, configuration, and version details of all deployed charts, helping you manage and track your deployments effectively.

select
hc.name as chart_name,
hc.type as chart_type,
hc.version as chart_version,
hr.name as release_name,
hr.status as release_status,
hr.version as deployment_version,
hr.first_deployed as deployed_at,
hr.config as deployment_config
from
kubernetes.helm_chart as hc
left join kubernetes.helm_release as hr on hc.name = hr.chart_name
where
hr.status = 'deployed';
select
hc.name as chart_name,
hc.type as chart_type,
hc.version as chart_version,
hr.name as release_name,
hr.status as release_status,
hr.version as deployment_version,
hr.first_deployed as deployed_at,
hr.config as deployment_config
from
kubernetes_helm_chart as hc
left join kubernetes_helm_release as hr on hc.name = hr.chart_name
where
hr.status = 'deployed';

List all deprecated charts

Discover the segments that contain deprecated charts within your system. This is particularly useful for identifying outdated elements and ensuring your system stays up-to-date.

select
name,
api_version,
version,
type,
description,
app_version
from
helm_chart
where
deprecated;
select
name,
api_version,
version,
type,
description,
app_version
from
helm_chart
where
deprecated = 1;

List application type charts

Explore the different charts related to application type in Helm to gain insights into their names, versions, API versions, and descriptions. This can help you understand the variety and specifications of application charts available, assisting in better application management.

select
name,
api_version,
version,
type,
description,
app_version
from
helm_chart
where
type = 'application';
select
name,
api_version,
version,
type,
description,
app_version
from
helm_chart
where
type = 'application';

Schema for helm_chart

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
annotationsjsonbAnnotations are additional mappings uninterpreted by Helm, made available for inspection by other applications.
api_versiontextThe API Version of the chart.
app_versiontextThe version of the application enclosed inside of this chart.
chart_pathtextThe path to the directory where the chart is located.
conditiontextThe condition to check to enable chart.
dependenciesjsonbDependencies are a list of dependencies for a chart.
deprecatedbooleanIndicates whether or not this chart is deprecated.
descriptiontextA one-sentence description of the chart.
hometextThe URL to a relevant project page, git repo, or contact person.
icontextThe URL to an icon file.
keywordsjsonbA list of string keywords.
kube_versiontextA SemVer constraint specifying the version of Kubernetes required.
maintainersjsonbA list of name and URL/email address combinations for the maintainer(s).
nametextThe name of the chart.
sourcesjsonbSource is the URL to the source code of this chart.
sp_connection_nametextSteampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagstextThe tags to check to enable chart.
typetextSpecifies the chart type. Possible values: application, or library.
versiontextA SemVer 2 conformant version string of the chart.

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)" -- kubernetes

You can pass the configuration to the command with the --config argument:

steampipe_export_kubernetes --config '<your_config>' helm_chart