k8s-steampipe

Query Kubernetes cluster resources using Steampipe SQL.

2|Updated Feb 14, 2026

Search Tags:#kubernetes #sql #query #kubectl #k8s #steampipe

Ready to run

npx skills add https://github.com/jimweller/davit-dataops-dotfiles --skill k8s-steampipe

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: k8s-steampipe
Source: https://github.com/jimweller/davit-dataops-dotfiles/tree/main/dataops-plugin/skills/k8s-steampipe
Command: npx skills add https://github.com/jimweller/davit-dataops-dotfiles --skill k8s-steampipe

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill allows you to query your Kubernetes clusters using SQL, providing a powerful and flexible way to inspect and manage your cluster resources without needing to learn complex kubectl commands for every scenario.

Core Features & Use Cases

SQL Interface: Query Kubernetes objects (pods, deployments, services, etc.) using familiar SQL syntax.
Direct CLI Access: Bypasses higher-level abstractions to call the steampipe CLI directly for maximum portability.
Explicit Cluster Selection: Requires you to specify which cluster to query, ensuring clarity and control.
Use Case: Quickly find all pods in a specific namespace that are not in a 'Running' state across your development cluster.

Quick Start

Use the k8s-steampipe skill to list all tables in the 'dss-eks-platform-dev' cluster.

Frequently Asked Questions about k8s-steampipe

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I query Kubernetes cluster resources using SQL instead of kubectl commands?▼

You can query Kubernetes cluster resources using SQL by running Steampipe SQL commands against your cluster, which translates standard SQL syntax into API calls for retrieving pods, deployments, and services without complex kubectl commands.

Can I use SQL to find all pods in a specific namespace that are not running?▼

Yes, you can use SQL to find non-running pods in a specific namespace by writing a SELECT query against the Kubernetes pod table in Steampipe, filtering by namespace and status conditions to retrieve the exact resources.

Do I need to specify which Kubernetes cluster to query before running SQL commands?▼

Yes, you must explicitly specify which Kubernetes cluster to query before running SQL commands, ensuring clarity and control over cluster selection and preventing accidental queries against the wrong environment.

How do I authenticate to EKS clusters when querying Kubernetes resources with SQL?▼

You can authenticate to EKS clusters when querying Kubernetes resources with SQL by integrating with tools like aws-vault and yq for credential management and configuration before executing Steampipe SQL queries.

What is the best way to perform ad-hoc data retrieval and analysis of Kubernetes environments?▼

The best way to perform ad-hoc data retrieval and analysis of Kubernetes environments is using a unified SQL interface like Steampipe, which allows direct CLI access to query cluster resources without higher-level abstractions for maximum portability.

Does querying Kubernetes with SQL bypass kubectl entirely or work alongside it?▼

Querying Kubernetes with SQL calls the Steampipe CLI directly for maximum portability, bypassing kubectl abstractions while still integrating with kubectl configuration and tools like yq and aws-vault for authentication setup.