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!
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!
Why we think it's cool:
We can't wait to see what queries you come up with, and would really appreciate your feedback!edit: format of bullet list