Steampipe

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.

Features

API to SQL Mapping - Maps external service data to virtual database tables using a foreign data wrapper for standard SQL access.
SQL Query Interfaces - Executes standard SQL queries against live cloud services and APIs to retrieve data as relational records.
API-to-Relational Mappers - Wraps external API endpoints as virtual database tables to enable standard relational queries and joins.
Cloud Infrastructure Query Engines - Provides a relational database interface to retrieve and join real-time data from multiple cloud service providers.
Database Connectivity Interfaces - Exposes live API data via a Postgres-compatible interface for third-party database client connectivity.
Embedded Database Engines - Bundles a database core within a standalone binary to provide SQL capabilities without a separate server.
Foreign Data Wrappers - Implements a foreign data wrapper interface to map external API endpoints to virtual relational tables.
HTTP-to-SQL Mappers - Translates HTTP API endpoints into virtual tables to allow standard SQL queries against live data.
PostgreSQL Foreign Data Wrappers - Installs as a foreign data wrapper in an external database to enable standard SQL querying of APIs.
PostgreSQL Integrations - Maps external API endpoints to virtual PostgreSQL tables to enable standard SQL queries.
PostgreSQL Protocol Compatibility - Implements the PostgreSQL wire protocol to ensure interoperability with standard relational database drivers.
SQLite Extensions - Loads as an extension to make API data available as virtual tables within SQLite.
Virtual Tables - Translates non-relational API responses into virtual rows and columns on the fly.
Cloud Infrastructure Querying - Uses SQL to retrieve and filter real-time data from cloud service APIs and infrastructure.
Multi-Cloud Data Aggregation - Combines information from different cloud providers and service accounts into a single unified dataset.
Multi-Cloud Data Aggregations - Combines data from multiple service accounts or subscriptions into a single unified dataset for simplified analysis.
Provider Plugin Architectures - Uses a gRPC-based plugin architecture to decouple core logic from cloud service-specific APIs.
Data Source Extensions - Allows the integration of new external systems by implementing provider-specific code in gRPC-based plugins.
Natural Language Querying - Provides interfaces for querying cloud infrastructure data using natural language processing.
Database Connectivity - Runs a local service that enables connections from any compatible database client.
Standalone Data Exports - Extracts data from cloud services into standalone formats using a binary without requiring a database installation.
Interactive Shells - Provides an interactive command-line shell for running SQL queries with autocomplete and batch mode.
Cloud Infrastructure Automation - Allows defining operational workflows as code to coordinate personnel and pipelines for cloud infrastructure management.
Cloud Monitoring Dashboards - Creates custom dashboards to monitor security posture and track resource status against benchmarks.
Infrastructure Configuration Visualization - Creates dashboards and reports by querying cloud resource configurations through SQL.
API Workflow Automation - Integrates SQL data access with visualization and workflow tools to automate cloud environment processes.
Model Context Protocol Integrations - Maps cloud infrastructure data to a standardized context format for consumption by conversational AI models.
Cloud Resource Monitoring - Creates dashboards and runs automated queries to track security posture and resource status.
Query Engines - Queries cloud services using SQL.
Cloud Security - SQL-based querying for cloud infrastructure and security benchmarks.
Penetration Testing and Analysis - Queries cloud and cluster resources using SQL.
Security Assessment Tools - Queries cloud service configurations using SQL.

Star-Verlauf

turbotsteampipe

Name: turbot/steampipe
Author: turbot

View on GitHub

7,701 Stars326 ForksGoagpl-3.04 Aufrufesteampipe.io

Steampipe

The engine can be run as a standalone binary with an embedded database or integrated into existing Postgres and SQLite installations.

Features

API to SQL Mapping - Maps external service data to virtual database tables using a foreign data wrapper for standard SQL access.
SQL Query Interfaces - Executes standard SQL queries against live cloud services and APIs to retrieve data as relational records.
API-to-Relational Mappers - Wraps external API endpoints as virtual database tables to enable standard relational queries and joins.
Cloud Infrastructure Query Engines - Provides a relational database interface to retrieve and join real-time data from multiple cloud service providers.
Database Connectivity Interfaces - Exposes live API data via a Postgres-compatible interface for third-party database client connectivity.
Embedded Database Engines - Bundles a database core within a standalone binary to provide SQL capabilities without a separate server.
Foreign Data Wrappers - Implements a foreign data wrapper interface to map external API endpoints to virtual relational tables.
HTTP-to-SQL Mappers - Translates HTTP API endpoints into virtual tables to allow standard SQL queries against live data.
PostgreSQL Foreign Data Wrappers - Installs as a foreign data wrapper in an external database to enable standard SQL querying of APIs.
PostgreSQL Integrations - Maps external API endpoints to virtual PostgreSQL tables to enable standard SQL queries.
PostgreSQL Protocol Compatibility - Implements the PostgreSQL wire protocol to ensure interoperability with standard relational database drivers.
SQLite Extensions - Loads as an extension to make API data available as virtual tables within SQLite.
Virtual Tables - Translates non-relational API responses into virtual rows and columns on the fly.
Cloud Infrastructure Querying - Uses SQL to retrieve and filter real-time data from cloud service APIs and infrastructure.
Multi-Cloud Data Aggregation - Combines information from different cloud providers and service accounts into a single unified dataset.
Multi-Cloud Data Aggregations - Combines data from multiple service accounts or subscriptions into a single unified dataset for simplified analysis.
Provider Plugin Architectures - Uses a gRPC-based plugin architecture to decouple core logic from cloud service-specific APIs.
Data Source Extensions - Allows the integration of new external systems by implementing provider-specific code in gRPC-based plugins.
Natural Language Querying - Provides interfaces for querying cloud infrastructure data using natural language processing.
Database Connectivity - Runs a local service that enables connections from any compatible database client.
Standalone Data Exports - Extracts data from cloud services into standalone formats using a binary without requiring a database installation.
Interactive Shells - Provides an interactive command-line shell for running SQL queries with autocomplete and batch mode.
Cloud Infrastructure Automation - Allows defining operational workflows as code to coordinate personnel and pipelines for cloud infrastructure management.
Cloud Monitoring Dashboards - Creates custom dashboards to monitor security posture and track resource status against benchmarks.
Infrastructure Configuration Visualization - Creates dashboards and reports by querying cloud resource configurations through SQL.
API Workflow Automation - Integrates SQL data access with visualization and workflow tools to automate cloud environment processes.
Model Context Protocol Integrations - Maps cloud infrastructure data to a standardized context format for consumption by conversational AI models.
Cloud Resource Monitoring - Creates dashboards and runs automated queries to track security posture and resource status.
Query Engines - Queries cloud services using SQL.
Cloud Security - SQL-based querying for cloud infrastructure and security benchmarks.
Penetration Testing and Analysis - Queries cloud and cluster resources using SQL.
Security Assessment Tools - Queries cloud service configurations using SQL.

Open-Source-Alternativen zu Steampipe

Ähnliche Open-Source-Projekte, sortiert nach der Anzahl der gemeinsamen Funktionen mit Steampipe.

dbcli/pgcli
dbcli/pgcli
13,231Auf GitHub ansehen
pgcli is an interactive command-line interface and database management tool for PostgreSQL. It functions as an interactive SQL shell and query editor that allows users to inspect schemas, manage connections, and run queries against PostgreSQL data sources. The tool is distinguished by its real-time, schema-aware autocompletion for keywords, tables, and columns, as well as dynamic SQL syntax highlighting. It provides safety mechanisms through transaction-aware guardrails that warn against or block destructive statements when no active transaction is detected. Broad capabilities include secure
Pythondatabasepostgrespostgresql
Auf GitHub ansehen13,231
tstack/lnav
tstack/lnav
9,630Auf GitHub ansehen
lnav is a terminal-based log viewer and analyzer designed for aggregating, filtering, and analyzing multiple log files in a single chronological view. It functions as a console application that can replace the system pager, providing syntax highlighting and document navigation for system or application logs. The project distinguishes itself by mapping unstructured log data to virtual SQLite tables, enabling the use of SQL and PRQL for structured data analysis, aggregations, and relational queries. It further differentiates its capability set through native integration for retrieving and taili
C++command-line-toollesslog-analysis
Auf GitHub ansehen9,630
tursodatabase/libsql
tursodatabase/libsql
16,887Auf GitHub ansehen
LibSQL is a high-performance, distributed SQL database engine that extends SQLite to support remote network access, edge computing, and real-time synchronization. It functions as an embedded database library that integrates directly into application processes while providing the infrastructure to maintain consistency across multiple geographic regions. The platform distinguishes itself by enabling database interaction over standard HTTP protocols, allowing applications to query remote data sources in serverless and edge environments without requiring local filesystem access. It includes nativ
Cdatabaseembedded-databaserust
Auf GitHub ansehen16,887
mlabouardy/komiser
mlabouardy/komiser
4,133Auf GitHub ansehen
Komiser is a multi-cloud infrastructure inspector and asset inventory manager. It provides a centralized system for auditing, cataloging, and analyzing deployed services and assets across AWS, GCP, and Azure environments. The project transforms disparate resource schemas from different cloud vendors into a unified structural representation through a provider-based plugin architecture. It uses agentless API inspection and polling-based resource discovery to retrieve metadata and configuration states without requiring agents on target resources. The platform covers financial management via cos
Go
Auf GitHub ansehen4,133

Alle 30 Alternativen zu Steampipe anzeigen

Häufig gestellte Fragen

Was macht turbot/steampipe?

Was sind die Hauptfunktionen von turbot/steampipe?

Die Hauptfunktionen von turbot/steampipe sind: API to SQL Mapping, SQL Query Interfaces, API-to-Relational Mappers, Cloud Infrastructure Query Engines, Database Connectivity Interfaces, Embedded Database Engines, Foreign Data Wrappers, HTTP-to-SQL Mappers.

Welche Open-Source-Alternativen gibt es zu turbot/steampipe?

Open-Source-Alternativen zu turbot/steampipe sind unter anderem: dbcli/pgcli — pgcli is an interactive command-line interface and database management tool for PostgreSQL. It functions as an… tstack/lnav — lnav is a terminal-based log viewer and analyzer designed for aggregating, filtering, and analyzing multiple log files… tursodatabase/libsql — LibSQL is a high-performance, distributed SQL database engine that extends SQLite to support remote network access,… mlabouardy/komiser — Komiser is a multi-cloud infrastructure inspector and asset inventory manager. It provides a centralized system for… rusqlite/rusqlite — Rusqlite is an embedded database interface and relational database driver that provides a client library for… boto/boto3 — Boto3 is the AWS SDK for Python, providing a programmatic interface for managing and automating AWS cloud…