GitHub - turbot/steampipe: Use SQL to instantly query your cloud services (AWS,...

Steampipe is the universal interface to APIs. Use SQL to query cloud infrastructure, SaaS, code, logs, and more.

With Steampipe you can:

• Query → Use SQL to query (and join across!) APIs.

• Check → Ensure that cloud resources comply with security benchmarks such as CIS, NIST, and SOC2.

• Visualize → View prebuilt dashboards or build your own.

Steampipe CLI: The SQL console for API queries

The Steampipe community has grown a suite of plugins that map APIs to tables.

The interactive query shell is one way you can query those tables.

You can also use psql, pgcli, Metabase, Tableau, or any client that can connect to Postgres.

Get started with the CLI

Install Steampipe

sudo /bin/sh -c 

brew tap turbot/tap
brew install steampipe

Add a plugin

steampipe plugin install net

Run steampipe query
Launch the interactive shell.

steampipe query

  

  net_certificate

  domain  ;

Learn more about the CLI

Steampipe Mods: Dashboards and benchmarks

The Steampipe community has also grown a suite of mods which are sets of dashboards that visualize your resources and benchmarks that check your cloud resources for compliance.

Compliance	Check AWS, Azure, GCP, etc for compliance with HIPAA, PCI, etc
Cost	Review what AWS, Azure, GCP, and other clouds are costing you
Insights	Visualize cloud resources with charts, tables, and interactive widgets
Security	Use CIS, NIST, FedRAMP etc to assess the security of AWS, Azure, GCP, etc
Tags	Verify the consistency of tags applied to AWS, Azure, and GCP resources
Your mod	Build your own benchmarks and dashboards

Running dashboards and benchmarks

Dashboards and benchmarks use SQL to gather data and HCL to flow the data into dashboard widgets and benchmark controls. You can use the existing suites of benchmarks and dashboards, or build derivative versions, or create your own.

Get started with dashboards and benchmarks

Install the Net Insights mod
The Net Insights mod works with the Net plugin shown above. To run it, first clone its repo and change to that directory.

git clone https://github.com/turbot/steampipe-mod-net-insights
 steampipe-mod-net-insights

Run benchmarks in the CLI

steampipe check all

steampipe check benchmark.dns_best_practices

steampipe check control.dns_ns_name_valid

Run benchmarks as dashboards
Launch the dashboard server: `steampipe dashboard`, then open `http://localhost:9194` in your browser.

Use dashboards to explore your resources
Dashboards use charts, tables, and interactive widgets to help you explore and visualize your resources.

Community

We thrive on feedback and community involvement!

Have a question? → Join our Slack community or open a GitHub issue.

Want to get involved? → Learn how to contribute.

Want to work with the team? → We are hiring!

Steampipe Cloud

Want a hosted version of Steampipe? Bring your team to Steampipe Cloud.