Using different client/frontend (pgcli, IntelliJ/DataGrip, etc.)

[j-martin]

Hi,

I was wondering if anybody figured out how (or if it was possible) to use a different query client/frontend on top of steampipe. The steampipe query completion and understanding of the schema are fairly barebone compared to more sophisticated tools.

My understanding is that steampipe is using SQLite in the background, but is it a stretch to be able to query steampipe from a different client? Due to the file-centric nature of SQLite, I doubt it is possible though. It seems to be PostgreSQL, so that should make it easier, maybe.

• https://github.com/dbcli/pgcli
• https://github.com/dbcli/litecli
• https://www.jetbrains.com/datagrip/

[e-gineer]

Thanks for using Steampipe @j-martin!

You can run Steampipe in service mode with steampipe service start, which prints out Postgres endpoint information. You can then connect from any Postgres compatible client! We use pgcli, datagrip, TablePlus and many other tools every day.

Docs:

• https://steampipe.io/docs/using-steampipe/service
• https://steampipe.io/docs/using-steampipe/third-party

[j-martin]

Awesome! I should RT*M next time.

[j-martin]

For Intellij/DataGrip users you will need to enable all (or at least the ones you care about) in order to actually be able to get proper autocompletion. pgcli worked out of the box.