Steampipe | select * from cloud;

select * from cloud;

Dynamically query APIs, code and more with SQL.
Zero-ETL from 140 data sources.

Open source. No DB required.

Cloud. Free for developers!

Fall in love with our huge plugin library, and stay for our incredible community!

Steampipe provides a common SQL interface so I can work faster and avoid writing one-off scripts.
François de Metz
Software Developer
it gives you a uniform interface to not just AWS, Azure, & GCP, but all sorts of other clouds.
Chris Farris
Cloud Security Guy
No complex integrations needed, simple to use and configure!
Anusha
@piece_of_irony
Steampipe is without a doubt one of the best open source tools for security compliance, operations and API orchestration.
Ashish Bansal
Security Engineering Open Source Contributor
Everything our users ask for, Steampipe already provides
Shyam Krishnaswamy
CTO Deepfence
This thing is cool!
Jamie Finnigan
Product security @hashicorp
An example of a hidden gem 💎 is steampipe.
Danny Steenman
Consultant: Towards the Cloud
Yes. Use this. I'm a fan.
Andy Hunt
Forms infrastructure lead @gdsteam
I recently started using Steampipe and it has made my life about 30x better.
@bearjaws
Hackernews Comment

I recently started using Steampipe and it has made my life about 30x better.
@bearjaws
Hackernews Comment
It integrates with all our services, & gives us granular mapping from business objectives to SQL statements. That's the magic of Steampipe
Ciaran Finnegan
Security Practice Lead: CMD Solutions
Steampipe is the Swiss Army knife for information gathering from different cloud sources
Martin Berger
Tech Architecture Associate Manager, Accenture
Quickly find resources you can target for cost savings, leveraging the familiarity and flexibility of SQL.
Ryan Ryke
Cloud Life Consulting
Trivial to connect live cloud configuration data with internal or external data sets...
Thoughtworks Radar
thoughtworks.com
Powerful & flexible way to analyze your data, and scale to meet the needs of even the largest organizations.
Kai Jian Tan
CCOE Senior Manager
Lastly, I just wanted to mention the documentation for Steampipe is great.
Robby Boney
Director of Product Development @ Interject
Steampipe is freaking rad. Makes it so easy to audit resources in one place
James Booth
@absolutejam
This fills my cloud developer tools heart with joy.
Justin Beckwith
Director of Developer Oppression @Discord

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.

Why SQL?

SQL has been the data access standard for decades. It levels the playing field for your team, easily integrates with other systems and accelerates delivery.

Explore, connect and join data

Painlessly join live cloud configuration data with internal or external data sets to create new insights.

What is Zero-ETL?

Your cloud is a live database that changes fast. Don't wait on ETL to sync, or rely on old data. Crunch it where it's born, fueling new use cases and swift decisions.

Use Cases

You've got questions,
Steampipe has answers.

Which users have MFA enabled right now?

Compliance

What security groups are open to the world?

Security

Which resources aren't tagged correctly?

Operations

What storage volumes are not in use?

Cost

How It Works

Get Zero-ETL superpowers in < 60 seconds

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!

Browse available tables

Use one of Steampipe's 500+ data sources or roll your own. Explore metadata and documentation for our community plugins on the Steampipe Hub.

Explore some metadata

Steampipe organizes your cloud metadata into tables and fields that are easily discoverable and readable by humans!

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.

Run from your own DB

Install Steampipe as a PostgreSQL FDW or SQLite extension and instantly query your infrastructure and other cloud APIs Zero-ETL.

Demos

See Steampipe in Action