Steampipe is a cloud infrastructure query engine and API-to-SQL mapper that translates REST and GraphQL API responses into relational rows and columns. It allows for the retrieval and joining of real-time data from multiple cloud service providers using a relational database interface.
The project functions as a PostgreSQL foreign data wrapper and an SQLite API extension, mapping external API endpoints to virtual tables. This enables the use of standard SQL to query live cloud services and aggregate data from different providers and service accounts into a single unified dataset.
The system includes capabilities for cloud resource monitoring, configuration visualization, and log data analysis. It provides an interactive SQL shell and supports the integration of new data sources through a gRPC-based plugin architecture.
The engine can be run as a standalone binary with an embedded database or integrated into existing Postgres and SQLite installations.