select * from cloud;
Dynamically query APIs, code and more with SQL.
Zero-ETL from 140 data sources.
Zero-ETL from 140 data sources.
![Turbot logo](/_next/image?url=%2Fimages%2Fsteampipe-sql-demo.gif&w=1920&q=75)
Fall in love with our huge plugin library, and stay for our incredible community!
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?
ComplianceWhat security groups are open to the world?
SecurityWhich resources aren't tagged correctly?
OperationsWhat storage volumes are not in use?
CostHow 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](/_next/image?url=%2Fimages%2Fsteampipe-sql-demo.gif&w=16&q=75)
select * from cloud;
Drill deep into the table schemas and discover helpful example queries for 140 plugins.
select * from logs;
Open source SIEM for instant log insights, powered by DuckDB. Analyze millions of events in seconds, right from your terminal.
Dashboards for DevOps.
Visualize cloud configurations. Assess security posture against a massive library of benchmarks. Build custom dashboards with code.
Workflow for DevOps.
Automate cloud operations. Coordinate people and pipelines. Build workflows as code.