Show HN: Steampipe – select * from cloud; | Hacker News Reader

Show HN: Steampipe – select * from cloud;

steampipe.io

24 pointsdboeke4 comments

Hello HN! Steampipe is an open-source tool for querying cloud metadata with SQL. We currently have 230+ tables across 13 plugins (e.g. AWS, Azure, GCP, GitHub, Zendesk, Slack & more) see the plugin registry for a full list: https://hub.steampipe.io/plugins.

Why we think it's cool:

  * Open source & extensible with plugins
  * Fast live queries & caching (no ETL to a DB)
  * Embedded Postgres with a Golang based FDW
  * Easy to use (well, you be the judge!)

We can't wait to see what queries you come up with, and would really appreciate your feedback!

edit: format of bullet list

I like this idea, and it is similar to something that I had wanted before (although in my case, what I wanted was mainly for public data without API keys, needing API keys for private data or for writing). But: Are joins with local data supported? Are writes supported? Can it be used with SQLite at all (perhaps this might be possible with a plugin)?

Joins are supported, both between the cloud tables and with local data. Local data can be created in the public schema, which is available for writing & table creation. Writing & updates to cloud tables are not supported. It works using an embedded Postgres instance with foreign data wrappers implemented by Steampipe ... you could try adding SQLite to it as a Postgres FDW. Hope that answers your questions and helps!

Looks an awesome innovation here

Reply on news.ycombinator.com