Steampipe

No entries match these filters. Clear filters

1. v2.3.0 Oct 30, 2025 · release notes

   Steampipe v2.3.0 upgrades the embedded database to PostgreSQL 14.19.

   └──▷ GET THIS VERSION

   copy

   $ git clone --branch v2.3.0 https://github.com/turbot/steampipe.git
   # already have the repo? check out this version:
   $ git checkout v2.3.0

2. v2.2.0 Sep 24, 2025 · release notes

   Steampipe v2.2.0 adds context functions in connection config and clearer startup messaging for Postgres mode.

   └──▷ GET THIS VERSION

   copy

   $ git clone --branch v2.2.0 https://github.com/turbot/steampipe.git
   # already have the repo? check out this version:
   $ git checkout v2.2.0

   • Supports context functions inside Steampipe connection config files, enabling dynamic credential resolution at runtime.
   • Displays a startup message indicating whether Steampipe launched its own Postgres instance or connected to an existing service.

   2 details in Everything

3. 0.57.0 Sep 13, 2024 · release notes

   Steampipe GCP plugin 0.57.0 adds seven new resource tables for Composer, Dataplex, Dataproc, and VPCVPCA logically isolated virtual network inside a public cloud provider's infrastructure, letting tools deploy resources with private addressing, controlled routing, and firewall rules without managing physical hardware. Access.

   • gcp_composer_environment table added to query Google Cloud Composer environment configurations
   • gcp_dataplex_lake table added to list and inspect Dataplex lake resources
   • gcp_dataplex_zone table added to list and inspect Dataplex zone resources
   • gcp_dataplex_task table added to list and inspect Dataplex task resources
   • gcp_dataplex_asset table added to list and inspect Dataplex asset resources

   +2 more show less

   • gcp_dataproc_metastore_service table added to query Dataproc Metastore service configurations
   • gcp_vpc_access_connector table added to query VPC Access connector details

   7 details in Everything

4. v0.24.0 Sep 5, 2024 · release notes

   Steampipe v0.24.0 adds configurable plugin startup timeout and enriches JSON query output with column metadata.

   └──▷ GET THIS VERSION

   copy

   $ git clone --branch v0.24.0 https://github.com/turbot/steampipe.git
   # already have the repo? check out this version:
   $ git checkout v0.24.0

   └──▷ TRY IT
   Parse column type metadata from query results — useful when scripting against APIs that return duplicate column names or when you need data-type-aware processing.
   copy

   $ steampipe query "select account_id, arn from aws_account" --output json | jq '.columns'

   • Adds ability to configure plugin startup timeout, giving operators control over slow-starting plugins.
   • Enriches --output json query results with a new columns property containing column name and data type metadata, enabling correct handling of duplicate column names.
   • Installs FDW and embedded Postgres database from GHCRGHCRGitHub Container Registry, GitHub's hosted service for storing and distributing OCI-compatible container images, giving cyber tools a versioned, access-controlled image store tied directly to a GitHub repository. instead of GCP, reducing dependency on GCP infrastructure.

   3 details in Everything

   └──▷ BREAKING ON UPGRADE

   • !The JSON output format for steampipe query --output json now includes a top-level columns array alongside rows; scripts or tools that parse the JSON output and expect only a rows key will need to be updated.
5. v0.23.0 May 9, 2024 · release notes

   Steampipe v0.23.0 adds connection key columns for filtered aggregator queries and verbose timing output.

   └──▷ GET THIS VERSION

   copy

   $ git clone --branch v0.23.0 https://github.com/turbot/steampipe.git
   # already have the repo? check out this version:
   $ git checkout v0.23.0

   • Add support for connection key column which maps 1-1 to a Steampipe connection and can be used to filter connections when executing an aggregator query
   • Adds support for verbose timing information

   2 details in Everything

6. v0.22.2 Apr 5, 2024 · release notes

   Steampipe v0.22.2 adds nested dashboard support

   └──▷ GET THIS VERSION

   copy

   $ git clone --branch v0.22.2 https://github.com/turbot/steampipe.git
   # already have the repo? check out this version:
   $ git checkout v0.22.2

7. AWS plugin 0.134.0 Mar 29, 2024 · release notes

   Steampipe AWS plugin 0.134.0 adds AWS tables for backup jobs, EBSEBSAmazon's block-storage service for EC2 instances, providing persistent network-attached volumes that survive instance restarts and can be snapshotted, giving cyber tools durable, scalable disk without managing physical drives. snapshots pagination fixes

   • Adds aws_backup_job table to query AWS Backup job details.
   • Adds aws_elastic_beanstalk_application_version table to inspect Elastic Beanstalk application versions.
   • Adds aws_rds_db_engine_version table to retrieve RDS database engine version information.
   • Adds aws_s3_object_version table to list S3 object versions.
   • Adds aws_servicequotas_service table to query service quotas.

   5 details in Everything

8. GCP plugin 0.50.0 Mar 29, 2024 · release notes

   GCP plugin 0.50.0 adds gcp_vertex_ai_model table for Vertex AI model metadata

   └──▷ TRY IT
   Query details of all Vertex AI models in a GCP project.
   copy

   $ select * from gcp_vertex_ai_model

9. Azure plugin 0.55.0 Mar 22, 2024 · release notes

   Steampipe Azure plugin 0.55.0 adds Azure VM memory metric tables for cloud auditing

   • Adds azure_compute_virtual_machine_metric_available_memory, azure_compute_virtual_machine_metric_available_memory_daily, and azure_compute_virtual_machine_metric_available_memory_hourly tables to query Azure compute virtual machine memory utilization metrics.

   1 detail in Everything

10. v0.22.1 Mar 15, 2024 · release notes

    Steampipe v0.22.1 adds database SSLSSLA cryptographic protocol for encrypting network connections, now deprecated in favor of TLS but whose name persists colloquially. Cyber tools reference it when handling HTTPS or other encrypted-channel inspection and termination. password support for encrypted private keys and parallelizes plugin startup.

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.22.1 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.22.1

    • Add database SSL password support for encrypted private key in order to handle your own certificates
    • Improve startup performance with high plugin count - parallelize plugin startup

    2 details in Everything

11. AWS plugin 0.133.0 Mar 15, 2024 · release notes

    Steampipe AWS plugin 0.133.0 adds AWS tables for ACM PCA, DMS, DocDB snapshots, and Transfer User.

    └──▷ TRY IT
    List all ACM Private CA certificate authorities in the current AWS profile.
    copy

    $ steampipe query "SELECT * FROM aws_acmpca_certificate_authority"

    • Adds aws_acmpca_certificate_authority table
    • Adds aws_dms_endpoint table
    • Adds aws_dms_replication_task table
    • Adds aws_docdb_cluster_snapshot table
    • Adds aws_transfer_user table

    5 details in Everything

12. v0.22.0 Mar 6, 2024 · release notes

    Adds version column to steampipe_plugin table and redirects errors to stderr.

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.22.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.22.0

    └──▷ TRY IT
    Check the installed version of the AWS plugin directly via the CLI.
    copy

    $ steampipe query "select version from steampipe_plugin where name = 'aws'"

    Filter only error logs from a scan by redirecting stderr to a file while keeping valid SQL output on stdout.
    copy

    $ steampipe query "select 1" 2> steampipe_errors.log

    • Adds the version column to the steampipe_plugin table to inspect installed plugin versions via SQL queries
    • Directs all error messages and warnings to standard error (stderr) for cleaner stdout output in pipelines

    2 details in Everything

    └──▷ BREAKING ON UPGRADE

    • !The steampipe mod, steampipe check and steampipe dashboard commands are deprecated and will be removed in a future version; users should migrate to Powerpipe.
    • !Deprecated cloud-host and cloud-token CLI args are replaced with pipes-host and pipes-token respectively; old flags will no longer work.
    • !Deprecated STEAMPIPE_CLOUD_HOST and STEAMPIPE_CLOUD_TOKEN environment variables are replaced with PIPES_HOST and PIPES_TOKEN; old vars will be ignored.
    • !Deprecated cloud_host and cloud_token workspace config keys are replaced with pipes_host and pipes_token; old keys will be ignored.
    • !Removed support for the deprecated terminal options configuration block.
    • !Removed support for the deprecated max_parallel property within general options.
    • !Removed support for the deprecated connection options configuration block.
    • !Removed the deprecated version property from the mod require block in .steampipe/mods/spmpc/*.spmod.json.
13. AWS plugin 0.131.0 Feb 15, 2024 · release notes

    Steampipe AWS plugin 0.131.0 adds seven new AWS resource tables.

    • Adds aws_api_gateway_method table
    • Adds aws_dms_certificate table
    • Adds aws_emr_security_configuration table
    • Adds aws_iot_thing table
    • Adds aws_organizations_organizational_unit table

    +2 more show less

    • Adds aws_ssmincidents_response_plan table
    • Adds aws_trusted_advisor_check_summary table

    7 details in Everything

14. GCP plugin 0.48.0 Jan 22, 2024 · release notes

    Steampipe GCP plugin v0.48.0 adds gcp_cloud_asset table and fixes columns in gcp_kubernetes_cluster

    └──▷ USE IT
    Query GCP Cloud Asset Inventory using the new table
    shell copy

    steampipe query "select * from gcp_cloud_asset;"

    • Adds the gcp_cloud_asset table to query Google Cloud Asset Inventory data

    1 detail in Everything

15. Azure plugin 0.53.0 Jan 22, 2024 · release notes

    Steampipe Azure plugin v0.53.0 adds audit_policy column and fixes camelCase key vault retrieval

    • Adds audit_policy column to azure_sql_database and azure_sql_server tables to expose SQL auditing configuration directly in queries.

    1 detail in Everything

16. v0.21.3 Jan 5, 2024 · release notes

    Adds STEAMPIPE_FDW_PPROF environment variable to enable pprof profiling for the Postgres FDW

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.21.3 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.21.3

    • Allow using pprof on FDW when STEAMPIPE_FDW_PPROF environment variable is set

    1 detail in Everything

17. v0.21.2 Dec 12, 2023 · release notes

    Adds steampipe_internal.steampipe_plugin_column introspection table for plugin metadata

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.21.2 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.21.2

    └──▷ USE IT
    List column definitions for any plugin to inspect its schema programmatically.
    shell copy

    steampipe query 'SELECT * FROM steampipe_internal.steampipe_plugin_column'

18. v0.21.0 Oct 2, 2023 · release notes

    Steampipe v0.21.0 adds plugin concurrency/rate limiting, multi-instance configs, new introspection tables, and service listen host support

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.21.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.21.0

    └──▷ TRY IT
    Query the new introspection table to see all configured plugin limiters.
    copy

    $ steampipe query "SELECT * FROM steampipe_plugin_limiter;"

    Install plugins defined in mod.sp without generating default config files.
    copy

    $ steampipe plugin install --skip-config

    • Adds plugin connection config block allowing multiple instances of a plugin version to be defined in .steampipe/config/plugins.hcl.
    • Enables defining rate and concurrency limits for plugin execution via the limits key within plugin instance definitions or a new top-level options.plugin block.
    • Adds new introspection tables steampipe_plugin, steampipe_plugin_limiter, and steampipe_server_settings to query configured plugin instances, limiters, and server settings respectively.
    • Adds --output json flag to steampipe plugin list command to export plugin data in JSON format.
    • Allows running steampipe plugin install with no arguments to install all plugins referenced in the current mod file.

    +2 more show less

    • Adds skip-config flag to steampipe plugin install to prevent writing default plugin configuration during installation.
    • Enables selecting listen hosts for the steampipe service via the listen_hosts setting in the server configuration.

    7 details in Everything

    └──▷ BREAKING ON UPGRADE

    • !Table steampipe_connection_state is renamed to steampipe_connection.
    • !Backward compatibility for data files from v0.13.0 is removed; migration scripts are no longer provided.
    • !The deprecated workspace-chdir flag has been removed.
    • !Support for plugins using SDK < v4.0.0 (which do not support multiple connections) has been removed.
19. v0.20.6 Jun 14, 2023 · release notes

    Steampipe v0.20.6 enables fully qualified variable setting and transitive mod updates

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.20.6 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.20.6

    • Adds support for setting variable values using fully qualified names (e.g., mod::var) in the root or top-level dependency mods.
    • Updates steampipe mod update to propagate changes into transitive dependencies, resolving variables via parent mod require block args.

    2 details in Everything

20. v0.20.2 May 19, 2023 · release notes

    Steampipe v0.20.2 re-adds support for legacy command-schema

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.20.2 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.20.2

21. v0.20.0 May 18, 2023 · release notes

    Steampipe v0.20.0 adds time-series charts, steampipe_connection_state table, meta_cache() SQL functions, and import_schema config support

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.20.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.20.0

    └──▷ TRY IT
    Query connection states directly from SQL without relying on CLI status commands.
    copy

    $ SELECT * FROM steampipe_connection_state;

    Install plugins silently in CI environments by suppressing progress output.
    copy

    $ steampipe plugin install aws --progress=false

    Disable caching for both the service and client by setting the environment variable.
    copy

    $ export STEAMPIPE_CACHE=disabled && steampipe serve

    • Adds steampipe_connection_state table to indicate the loading state of connections
    • Add support for import_schema property in connection config, controlling whether to create a postgres schema for a steampipe connection
    • Introduce SQL functions meta_cache() and meta_cache_ttl() to easily manipulate caching functionality
    • Adds a --progress flag to plugin install to disable progress bars
    • Updates in cache configuration to allow disabling of all caching on server via the STEAMPIPE_CACHE environment variable

    5 details in Everything

22. v0.19.0 Mar 9, 2023 · release notes

    Steampipe v0.19.0 introduces dynamic aggregator connections, configurable DB timeout, and improved progress reporting.

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.19.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.19.0

    • Adds support for aggregator connections with dynamic tables to combine multiple child connections.
    • Adds ability to update dynamic plugin schemas in real-time based on file watching events.
    • Makes workspace loading asynchronous to reduce startup latency.
    • Exposes a configurable database start timeout via the new database.start_timeout setting.
    • Shows current status message instead of generic text during interactive mode initialization.

    +1 more show less

    • Adds exported file path output when the --progress flag is enabled.

    6 details in Everything

23. v0.18.0 Jan 12, 2023 · release notes

    v0.18.0 adds graph visualizations, with blocks, param runtime deps, dashboard panel logs, and --max-parallel CLI flag.

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.18.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.18.0

    └──▷ USE IT
    Run dashboard panels in parallel to speed up execution, leveraging the new default concurrency of 10.
    shell copy

    steampipe dashboard run --max-parallel 20

    Use with blocks in your HCL configuration to define reusable data structures for queries.
    📍# Example HCL snippet mod example { with my_data { source = query.my_query } }
    View the execution history and logs for a specific dashboard panel in the UI.
    📍In the Steampipe Dashboard UI, click on a dashboard panel to expand the detail view, then check the Panel Log section.
    • Adds support for graph visualisations of your data with easily composable data structures using nodes and edges
    • Add support for with blocks
    • Add support for param runtime dependencies
    • Add dashboard panel log to panel detail to get an understanding of the execution history of a panel
    • Update steampipe_reference introspection table to include references from with blocks

    +1 more show less

    • Add a --max-parallel flag to dashboard command and set default to 10

    6 details in Everything

    └──▷ BREAKING ON UPGRADE

    • !Exit codes have been updated to specific constants (e.g. ExitCodeControlsAlarm = 1, ExitCodeQueryExecutionFailed = 41) replacing previous logic
    • !Remove search_path and search_path_prefix from control and query resources
24. v0.16.0 Aug 24, 2022 · release notes

    Steampipe v0.16.0 adds memory limit env var and multi-connection plugin processes

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.16.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.16.0

    • Limit the maximum memory used by the plugin query cache can using the environment variable STEAMPIPE_CACHE_MAX_SIZE_MB
    • Add support for plugin processes to handle multiple connections (rather than a process per connection)
    • Add support for single and multi-select combo inputs in dashboards

    3 details in Everything

25. v0.15.0 Jun 23, 2022 · release notes

    Steampipe v0.15.0 adds OpenTelemetryOpenTelemetryAn open standard and set of tools for collecting traces, metrics and logs from applications. It lets services export observability data without tying instrumentation to one monitoring vendor. support, scan_metadata table, --show-password flag, and optional dashboard block names.

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.15.0 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.15.0

    └──▷ USE IT
    Enable OpenTelemetry tracing for a steampipe query execution.
    shell copy

    OTEL_SERVICE_NAME=steampipe OTEL_TRACES_EXPORTER=otlp steampipe query 'select * from aws_ec2_instance'

    Query the scan metadata to see how many hydrate functions were called for a specific check.
    shell copy

    steampipe check my_control --output json > /tmp/timing.json && steampipe query 'select * from steampipe_command.scan_metadata where timing_file = '"'"'/tmp/timing.json'"'"''

    Reveal the password used for the internal database connection during a check run.
    shell copy

    steampipe check my_check --show-password

    • Adds Open Telemetry support for tracing queries.
    • Updates .timing output to include hydrate function counts and cache status.
    • Adds steampipe_command.scan_metadata table to access .timing command metadata via SQL.
    • Enables auto-vacuum in postgres config by default.
    • Adds --show-password CLI flag to reveal the database user password, disabling visibility by default.

    +2 more show less

    • Supports optional names for dashboard child blocks.
    • Updates json control output template to use Go templating instead of simple serialization.

    7 details in Everything

26. v0.0.16 Jan 20, 2021 · release notes

    Adds autocomplete for meta-commands and restricts query sessions to a single running instance.

    └──▷ GET THIS VERSION

    copy

    $ git clone --branch v0.0.16 https://github.com/turbot/steampipe.git
    # already have the repo? check out this version:
    $ git checkout v0.0.16

    └──▷ TRY IT
    Enable tab-completion for meta-commands to speed up interactive sessions.
    copy

    $ steepipe --autocomplete

    Allow concurrent queries by starting the background service first.
    copy

    $ steampipe service start

    • Adds autocomplete support for meta-commands in the CLI
    • Enforces a single query session limit unless service start was previously executed

    2 details in Everything