select * from cloud;

Features
Query like it's 1992
Stop hacking around with scripts; get real work done with
the data access standard that's been rocking it for 4 decades.
select runtime, count(*)from aws_lambda_functiongroup by runtime;
+------------+-------+ | runtime | count | +------------+-------+ | nodejs12.x | 1 | | python3.7 | 1 | | python3.8 | 2 | +------------+-------+
SQL? Really?
Yes, SQL. It is an elegant and powerful tool that makes working with multiple APIs simple. SQL levels the playing field for your team, easily integrates with other systems and accelerates delivery.
select aws.name aws_user_name, slack.id as slack_user_id, slack.display_name as slack_namefrom aws_iam_user as aws, slack_user as slackwhere aws.name = slack.email;
+--------------------------+---------------+------------+ | aws_user_name | slack_user_id | slack_name | +--------------------------+---------------+------------+ | dwight@dundermifflin.com | U2EMB8HLP | dwight | | jim@dundermifflin.com | U02HE4Z7E | jim | +--------------------------+---------------+------------+
Explore, connect and join data.
Painlessly join live cloud configuration data with internal or external data sets to create new insights.
select domain, expiration_date from whois_domain where domain in ('apple.com','steampipe.io');
+--------------+---------------------+ | domain | expiration_date | +--------------+---------------------+ | apple.com | 2021-02-20 05:00:00 | | steampipe.io | 2021-10-13 19:28:29 | +--------------+---------------------+
The cloud is a live database.
Stop building and maintaining out-of-sync lists and point-in-time environment snapshots; Steampipe's live tables give you the current view of any resource right now.
Use Cases
You've got questions, Steampipe has answers.
select id, display_name, real_name, has_2fafrom slack_user;
select group_name, group_idfrom aws_vpc_security_group_rulewhere type = 'ingress' and cidr_ip = '0.0.0.0/0';
select id, namefrom azure_compute_imagewhere tags -> 'owner' is null or tags -> 'app_id' is null;
select volume_id, volume_typefrom aws_ebs_volumewhere attachments is null;
How it works
Get SQL Superpowers in < 60 Seconds
steampipe plugin install aws
ā Installing plugin aws... Installed plugin: aws
Install your first plugin
Steampipe relies on plugins to implement the specific interfaces to cloud services, files, and other resources. Without a plugin, there is nothing to query!
.tables
+----------------------+-------------------------+ | Table | Description | +----------------------+-------------------------+ | aws_ebs_snapshot | AWS EBS Snapshots | | aws_ebs_volume | AWS EBS Volumes | | aws_iam_user | AWS IAM Users | | aws_iam_role | AWS IAM Roles | ... ... | aws_vpc_route_table | AWS VPC Route Tables | | aws_vpc_subnet | AWS VPC Subnets | +------------------+-----------------------------+
Browse available tables
Use one of Steampipe's 300+ data sources or roll your own. Explore metadata and documentation for our community plugins on the SteampipeĀ Hub.
.inspect aws.aws_iam_role
+----------------------+------------+-------------- | Column | Type | Description +----------------------+------------+-------------- | name | text | The friendly | role_id | text | The stable an | path | text | The path asso | arn | text | The AWS resou | create_date | timestamp | The date and | assume_role_policy | jsonb | The IAM Polic
Explore some metadata
Steampipe organizes your cloud metadata into tables and fields that are easily discoverable and readable by humans!
select create_date, arn from aws_iam_role;
+----------------------+--------------------------- | Create Date | ARN +----------------------+--------------------------- | 2019-08-12 16:42 EST | arn:aws:iam::123456789012: | 2020-02-29 12:12 EST | arn:aws:iam::123456789012: | 2020-10-11 13:24 EST | arn:aws:iam::123456789012: | 2020-12-02 18:01 EST | arn:aws:iam::123456789012: +----------------------+---------------------------
Write your first query
Every journey begins with the first step. Let us know what your first query was @steampipeio and we will send you a steampipe sticker.
Get cloud
work done.
Get cloud
work done.
