select * from shell; Use SQL to exec commands across hosts

Use SQL to run shell commands against any host - local or remote, Linux or Windows, through proxies & bastions. Aggregates results from multiple hosts.

Steampipe - https://steampipe.io

exec plugin - https://hub.steampipe.io/plugins/turbot/exec

It's a Postgres FDW - https://www.postgresql.org/docs/14/ddl-foreign-data.html

Uses Terraform provisioner code - https://developer.hashicorp.com/terraform/language/resources...

See also osquery, which runs on the host & has more structure - https://www.osquery.io/