It was on the TODO list for some time now but were finally here!
Our project stackql uses OpenAPI definition documents from cloud and SaaS providers to enable developers and analysts to query and interact with cloud resources using SQL. Use cases include CSPM, asset inventory and analysis, finops, and general cloud/SaaS estate observability using SELECT statements. The product also exposes IaC and config management operations using DML grammar (INSERT, etc), and lifecycle operations (like starting and stopping instances) using an EXEC statement.
StackQL can operate as a client or a server using the Postgres wire protocol (it does not require or implement a Postgres database, however) and is designed to integrate with reporting and BI systems as a data source. We also have full support for JOIN statements including cross-provider joins.
With our low code approach to provider plugin development (extensions to the provider's OpenAPI specs) we welcome developers to connect and contribute to existing providers or create new ones for your desired cloud (including public and private) or SaaS provider.
We have existing blog properties, including stackql.io/blog and fullstackchronicles.io, if you want to get up to speed with our journey.
Please reach out here or via GitHub if you want to know more.
Top comments (0)