steampipe-aws

Name: steampipe-aws
Availability: InStock
Author: pypeaday

Query AWS resources across accounts using Steampipe SQL.

2|Updated Jun 29, 2021

Search Tags:#security #aws #compliance #cloud #query #inventory #steampipe

Ready to run

npx skills add https://github.com/pypeaday/dotfiles --skill steampipe-aws

💬 Prompt for ChatGPT / Claude Chat▼

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.