skills.rest
pypeaday
pypeadayCOMMUNITY
Explore all skills by this author →
Website𝕏@pypeadayGitHub

steampipe-aws

Query AWS resources across accounts using Steampipe SQL.

2|Updated Jun 29, 2021
Search Tags:#security#aws#compliance#cloud#query#inventory#steampipe
One-click install
npx skills add https://github.com/pypeaday/dotfiles --skill steampipe-aws
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: steampipe-aws
Source: https://github.com/pypeaday/dotfiles/tree/main/opencode/.config/opencode/skill/steampipe-aws
Command: npx skills add https://github.com/pypeaday/dotfiles --skill steampipe-aws

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables rapid discovery and inventory of AWS resources across accounts using Steampipe SQL, simplifying auditing and security posture checks.

Core Features & Use Cases

  • Resource discovery: Query AWS resources across services (EC2, S3, IAM, VPC, and more) to build a current inventory.
  • Security & compliance audits: Inspect IAM roles/policies, security groups, and configuration status to identify misconfigurations.
  • Cross-account analysis: Run queries across regions or accounts to detect drift and patterns for governance.

Quick Start

Run a sample Steampipe query to list five EC2 instances: steampipe query "SELECT * FROM aws_ec2_instance LIMIT 5"

Frequently Asked Questions about steampipe-aws

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

FAQPage Schema
How do I query AWS infrastructure inventory across multiple accounts using SQL?▼

Query AWS infrastructure inventory by running Steampipe SQL statements across multi-account environments to discover resources for auditing and security posture assessment across compute, storage, networking, and IAM services.

Can I use SQL to audit IAM roles and security groups in AWS?▼

Audit IAM roles, policies, and security groups by running cross-service Steampipe SQL queries against AWS tables to inspect configurations and identify misconfigurations for compliance checks.

Do I need Steampipe installed to query AWS resources?▼

You need Steampipe installed and the AWS plugin configured to access AWS data. This setup supports running cross-service queries against AWS tables for resource discovery and security posture assessment.

What's the best way to detect configuration drift across AWS regions?▼

Run Steampipe SQL queries across AWS accounts and regions to detect configuration drift and identify governance patterns by analyzing resource configurations across multiple regions.

How do I list EC2 instances using Steampipe?▼

List EC2 instances by executing a Steampipe query such as "SELECT * FROM aws_ec2_instance LIMIT 5" to return a current inventory of your compute resources directly through SQL syntax.

Related Skills

Explore More Data & Analytics Skills→
jimwellerjimweller

aws-steampipe-query

Query AWS infrastructure resources using Steampipe SQL with aws-vault authentication.

Community
Intermediate
DCx7C5DCx7C5

cloud-SKILL.md

Aggregate cloud misconfigurations from AWS Security Hub, Azure Defender, and open-source tools.

Community
Advanced
jimwellerjimweller

k8s-steampipe

Query Kubernetes cluster resources using Steampipe SQL.

Community
Intermediate
mf-dynatracemf-dynatrace

dt-obs-aws

Monitor and optimize AWS cloud resources using Dynatrace Smartscape and DQL.

Community
Advanced