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).

1 - https://steampipe.io/docs/cloud/integrations/overview