from Hacker News

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

by nathanwallace on 10/2/23, 12:42 PM with 1 comments

• by nathanwallace on 10/2/23, 12:42 PM

  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/