select * from shell; Use SQL to exec commands across hostssteampipe.io 14 pointsnathanwallace2 years ago1 commentSaveHideCopy link On HNComments−nathanwallaceOP2yUse 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.ioexec plugin - https://hub.steampipe.io/plugins/turbot/execIt's a Postgres FDW - https://www.postgresql.org/docs/14/ddl-foreign-data.htmlUses 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/
Comments
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/