What is Steampipe?

SELECT title, instance_id, instance_state, instance_status, subnet_id, vpc_id, public_dns_name, public_ip_address, placement_availability_zone, launch_time
FROM aws_ec2_instance
ORDER BY launch_time DESC
LIMIT 100;

How do I get started?

steampipe plugin install aws
nano ~/.steampipe/config/aws.spc
AWS IAM ReadOnlyAccess permissions screen
[zercurity_ro]
aws_access_key_id=AZA...
aws_secret_access_key==btD...
connection "aws" {
plugin = "aws"
region = ["eu-west-1"]
profile = "zercurity_ro"
}
steampipe query "select instance_id, title, instance_state FROM aws_ec2_instance ORDER BY launch_time DESC LIMIT 10;"+---------------------+----------+----------------+
| instance_id | title | instance_state |
+---------------------+----------+----------------+
| i-1234567890abcdef0 | test | running |
+---------------------+----------+----------------+

Steampipe Mods

steampipe mod init
steampipe mod install github.com/turbot/steampipe-mod-aws-compliance
steampipe check aws_compliance.benchmark.cis_v140
steampipe dashboard
Steampipe dashboard showing AWS CIS 1.4.0 compliance

Steampipe internals

Steampipe service

steampipe service start
psql -U steampipe -h localhost -p 9193steampipe=> SELECT instance_id FROM aws_ec2_instance;     instance_id     
---------------------
i-1234567890abcdef0
(1 row)

Want to schedule and automate queries via the web?

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store