select * from cloud;
Dynamically query APIs, code and more with SQL.Zero-ETL from 140 data sources.
Turbot logo
logologologologologologologologologologo
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.
    Profile pic
    François de Metz
    Software Developer
  • it gives you a uniform interface to not just AWS, Azure, & GCP, but all sorts of other clouds.
    Profile pic
    Chris Farris
    Cloud Security Guy
  • No complex integrations needed, simple to use and configure!
    Profile pic
    Anusha
    @piece_of_irony
  • Steampipe is without a doubt one of the best open source tools for security compliance, operations and API orchestration.
    Profile pic
    Ashish Bansal
    Security Engineering Open Source Contributor
  • Everything our users ask for, Steampipe already provides
    Profile pic
    Shyam Krishnaswamy
    CTO Deepfence
  • This thing is cool!
    Profile pic
    Jamie Finnigan
    Product security @hashicorp
  • An example of a hidden gem 💎 is steampipe.
    Profile pic
    Danny Steenman
    Consultant: Towards the Cloud
  • Yes. Use this. I'm a fan.
    Profile pic
    Andy Hunt
    Forms infrastructure lead @gdsteam
  • I recently started using Steampipe and it has made my life about 30x better.
    Profile pic
    @bearjaws
    Hackernews Comment
  • I recently started using Steampipe and it has made my life about 30x better.
    Profile pic
    @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
    Profile pic
    Ciaran Finnegan
    Security Practice Lead: CMD Solutions
  • Steampipe is the Swiss Army knife for information gathering from different cloud sources
    Profile pic
    Martin Berger
    Tech Architecture Associate Manager, Accenture
  • Quickly find resources you can target for cost savings, leveraging the familiarity and flexibility of SQL.
    Profile pic
    Ryan Ryke
    Cloud Life Consulting
  • Trivial to connect live cloud configuration data with internal or external data sets...
    Profile pic
    Thoughtworks Radar
    thoughtworks.com
  • Powerful & flexible way to analyze your data, and scale to meet the needs of even the largest organizations.
    Profile pic
    Kai Jian Tan
    CCOE Senior Manager
  • Lastly, I just wanted to mention the documentation for Steampipe is great.
    Profile pic
    Robby Boney
    Director of Product Development @ Interject
  • Steampipe is freaking rad. Makes it so easy to audit resources in one place
    Profile pic
    James Booth
    @absolutejam
  • This fills my cloud developer tools heart with joy.
    Profile pic
    Justin Beckwith
    Director of Developer Oppression @Discord
pipe-connector

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
pipe-connector

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

Turbot logo
Steampipe logoGitHub Steampipe

select * from cloud;

Drill deep into the table schemas and discover helpful example queries for 140 plugins.
Tailpipe logoGitHub Tailpipe

select * from logs;

Open source SIEM for instant log insights, powered by DuckDB. Analyze millions of events in seconds, right from your terminal.
Powerpipe logoGitHub Powerpipe

Dashboards for DevOps.

Visualize cloud configurations. Assess security posture against a massive library of benchmarks. Build custom dashboards with code.
Flowpipe logoGitHub Flowpipe

Workflow for DevOps.

Automate cloud operations. Coordinate people and pipelines. Build workflows as code.