github.com/turbot/steampipe

Published

13 Oct 2025

Postgres FDW

This plugin is available as a native Postgres FDW . Unlike Steampipe CLI, which ships with an embedded Postgres server instance, the Postgres FDW can be installed in any supported Postgres database version.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_postgres_installer.sh script:

The installer will prompt you for the plugin name and version, download and install the appropriate files for your OS, system architecture, and Postgres version.

To configure the Postgres FDW , you will create an extension, foreign server, and schema and import the foreign schema.

SQLite Extension

This plugin is available as a SQLite Extension , making the tables available as SQLite virtual tables.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_sqlite_installer.sh script:

The installer will prompt you for the plugin name, version, and destination directory. It will then determine the OS and system architecture, and it will download and install the appropriate package.

To configure the SQLite extension , load the extension module and then run the steampipe_configure_hackernews function to configure it with plugin-specific options.

Export

This plugin is available as a standalone Export CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

You can pass the configuration to the command with the --config argument:

Bug fixes

• Fix issue where steampipe was returning 0 exit-code in batch mode even incase of API failures. (#4551)

Dependencies

• Update FDW to 1.12.7 to remediate high vulnerabilities.

Bug fixes

• Fix intermittent Reattachment process not found error when starting steampipe service. (#4507)

Bug fixes

• Fix issue where system-ingestible output format(csv) was humanised(comma separated) leading to a breaking change in query outputs. (#4525)

Bug fixes

• Fix issue where query batch mode outputs(json, csv, line) were not printing the rows received to stdout when any of the other rows returned an API error. (#4516)
• Fix issue where query batch mode table output always returned a 0 row count when timing was enabled. (#4520)

Whats new

• Update database version to PostgreSQL 14.17. (#4461)

Bug fixes

• Fix issue where plugin start timeout was getting limited to 60s. (#4477)

Bug fixes

• Update FDW to 1.12.2 to remediate critical and high vulnerabilities. (#533)

Dependencies

• Upgrade crypto, net and go-git packages to remediate critical and high vulnerabilities.

Bug fixes

• Fix issue where the steampipe interactive meta-command .cache clear was not clearing the cache. (#4443)

Breaking changes

The mod functionality, which was previously deprecated and moved to Powerpipe, has been removed in this version.

• Removed the check, dashboard, mod, and variable commands. (#4413)
• Removed support for running named queries. (#4416)
• Removed the watch and mod-location CLI args from the query command. (#4417)
• Removed the dashboard, dashboard-listen, and dashboard-port CLI args from the service command. (#4418)
• Removed the STEAMPIPE_MOD_LOCATION and STEAMPIPE_INTROSPECTION env vars. (#4419)
• Removed support for deprecated STEAMPIPE_CLOUD_HOST and STEAMPIPE_CLOUD_TOKEN env vars. (#4420)
• Removed the watch, introspection, and mod-location workspace profile args. (#4421)
• Removed the check and dashboard options from workspace profiles. (#4422)
• Removed the dashboard option from global options (default.spc). (#4423)

Bug fixes

• Fix incorrect versioning in v0.24.1. (#4388)

Bug fixes

• Fix issue where steampipe failed to download embedded PostgreSQL database and FDW during installation. (#4382)

Whats new

• Add ability to configure plugin startup timeout. (#4320)
• Install FDW and embedded postgres database from GHCR instead of GCP. (#4344)
• Update query JSON output format to add a columns property containing the column information. This allows us to handle duplicate column names by appending a unique suffix to duplicate column name (#4317)

Existing query JSON format:

$ steampipe query "select account_id, arn from aws_account" --output json
{
 "rows": [
  {
   "account_id": "123456789012",
   "arn": "arn:aws:::123456789012"
  }
 ]
}

New query JSON format(with new columns property):

$ steampipe query "select account_id, arn from aws_account" --output json
{
 "columns": [
  {
   "name": "account_id",
   "data_type": "text"
  },
  {
   "name": "arn",
   "data_type": "text"
  }
 ],
 "rows": [
  {
   "account_id": "123456789012",
   "arn": "arn:aws:::123456789012"
  }
 ]
}

Bug fixes

• Fix issue where plugin manager was incorrectly reporting a shutdown. (#4365)

Bug fixes

• Fix issue where refresh connections was not creating a new connection if it was not in the search path. (#4353)