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

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form.
annotations	jsonb	Annotations are additional mappings uninterpreted by Helm, made available for inspection by other applications.
api_version	text	The API Version of the chart.
app_version	text	The version of the application enclosed inside of this chart.
chart_path	text	The path to the directory where the chart is located.
condition	text	The condition to check to enable chart.
dependencies	jsonb	Dependencies are a list of dependencies for a chart.
deprecated	boolean	Indicates whether or not this chart is deprecated.
description	text	A one-sentence description of the chart.
home	text	The URL to a relevant project page, git repo, or contact person.
icon	text	The URL to an icon file.
keywords	jsonb	A list of string keywords.
kube_version	text	A SemVer constraint specifying the version of Kubernetes required.
maintainers	jsonb	A list of name and URL/email address combinations for the maintainer(s).
name	text	The name of the chart.
sources	jsonb	Source is the URL to the source code of this chart.
sp_connection_name	text	Steampipe connection name.
sp_ctx	jsonb	Steampipe context in JSON form.
tags	text	The tags to check to enable chart.
type	text	Specifies the chart type. Possible values: application, or library.
version	text	A 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