I presume so: "You can also use psql, pgcli, Metabase, Tableau, or any client that can connect to Postgres."
Correct - it's just Postgres, so all your favorite clients / tools work as usual. We have docs for a number of example integrations [1] that work with Steampipe CLI (or cloud).