Steampipe
steampipe.io
- Free plan
- Windows
- macOS
- Linux
- API
- Self-hosted
What Steampipe is
Steampipe provides tools for querying live data from APIs and services with SQL. Its CLI presents connected resources as relational data and includes its own PostgreSQL database, so the CLI offering does not require a separate database. Plugins supply the interface for each cloud service, file, or other resource being queried. Steampipe can join live cloud configuration data with internal or external datasets, with compliance, security, operations, and cost among its listed use cases. It is also available as PostgreSQL Foreign Data Wrappers, SQLite extensions that turn queries into API calls, and standalone export tools that extract information without a database. The hosted Turbot Pipes option provides database instances, shared dashboards, and snapshots. Downloads are offered for macOS, Linux, and Windows, and API and self-hosted use are listed. Steampipe is described as open source and has a free plan. Its plugin hub includes integrations across public cloud, SaaS, security, and software development categories.
Who it suits
Steampipe suits teams and practitioners who need SQL access to live API or cloud configuration data for compliance, security, operations, or cost work. Users need a plugin for each resource they want to query.
Good to know, and what to watch
- Queries live API and service data with SQL.
- Can join cloud configuration data with other datasets.
- Offers PostgreSQL, SQLite, and standalone export formats.
- Free and open source.
- Downloads available for macOS, Linux, and Windows.
- Each queried resource requires an implementing plugin.
- Hosted database instances and dashboards are through Turbot Pipes.
The verdict
Steampipe offers several ways to query or export live service data, from its CLI to database extensions. Choose the relevant plugin for each resource, or consider the hosted Turbot Pipes option.
What the maker publishes
- Company
- Turbot says it was founded in 2014 and is bootstrapped. source
- Credentials
- The AWS tutorial says Steampipe uses default AWS credentials from the user's credential file or environment variables out of the box. source
- Data joins
- Steampipe can join live cloud configuration data with internal or external datasets. source
- Export
- Steampipe Export CLIs are standalone binaries for extracting information from cloud services and APIs without a database. source
- Founded
- 2021 source
- Hosted option
- Turbot Pipes provides hosted Steampipe database instances, shared dashboards, and snapshots. source
- Live data
- Steampipe queries live cloud configuration data and can join it with internal or external data sets. source
- Maker
- Turbot says it was founded in 2014 and is 100% bootstrapped. source
- Open source
- The Steampipe site describes the product as open source and requiring no database for its CLI offering. source
- Open source
- Steampipe is described as an open-source zero-ETL engine, and its GitHub repository identifies its license as Apache 2.0. source
- Other distributions
- Steampipe is also available as PostgreSQL FDWs, SQLite extensions, and standalone export CLIs. source
- Plugin library
- The Steampipe Hub lists 157 plugins across categories including public cloud, SaaS, security, and software development. source
- Plugins
- Plugins implement interfaces to cloud services, files, and other resources, and the Hub lists 158 plugins. source
- PostgreSQL
- Steampipe is available as PostgreSQL Foreign Data Wrappers that can be installed in supported PostgreSQL versions. source
- Query engine
- The Steampipe CLI exposes APIs and services as a relational database and includes its own PostgreSQL database. source
- Security maintenance
- The changelog lists dependency upgrades to remediate security vulnerabilities in Steampipe CLI releases. source
- Security reports
- Turbot says SOC 2 reports are available on request under NDA and that its annual SOC examinations take place each April. source
- Setup requirement
- Steampipe requires a plugin to implement the interface for each cloud service, file, or other resource being queried. source
- SQLite
- Steampipe SQLite Extensions provide virtual tables that translate queries into API calls. source
- SQL queries
- The Steampipe CLI exposes APIs and services as a relational database for SQL queries over dynamic data. source
- Support
- The site links to a Slack community of more than 3,200 practitioners. source
- Support
- The maker directs users to documentation, the Steampipe Hub, and its Slack community. source
- Supported platforms
- The downloads page provides installers for macOS, Linux, and Windows. source
- Use cases
- The site lists compliance, security, operations, and cost as Steampipe use cases. source
Checked against the maker's pages on 3 Oct 2026.