Steampipe

Steampipe is the zero-ETL way to query APIs and services with SQL, instead of moving data into a database first. It exposes cloud accounts, code, logs, and other services as live SQL tables, so you can interrogate your infrastructure in place and answer security and posture questions on demand.

It queries APIs in real time, runs many data sources in parallel, and ships as a single binary for local use or CI/CD pipelines. A growing community plugin suite maps APIs from AWS, Azure, GCP, Kubernetes, GitHub, and many more services to thousands of documented tables.

Build on open-source benchmarks and dashboards to check cloud accounts against security frameworks, or write your own SQL to inspect resources. Install it on macOS with Homebrew or on Linux and Windows via WSL2, then add the plugins you need.