Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Steampipe

steampipe.io

  • Free plan
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
7.6 Club score Visit steampipe.io

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.