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/
