from Hacker News

SQL based OpenAPI client for cloud and SaaS providers

by jeffreyaven on 1/3/23, 6:17 AM with 1 comments

• by jeffreyaven on 1/3/23, 6:17 AM

  We are working on a new project called StackQL, which makes it easier for developers to query and manipulate data from cloud and SaaS providers using SQL grammar and semantics.

  StackQL is an API client built on top of provider OpenAPI specs with future support for GraphQL and gRPC/proto defs.

  Some links are here:

  https://github.com/stackql/stackql https://github.com/stackql/stackql-provider-registry https://registry.stackql.io/ https://stackql.io/docs https://stackql.io/blog/

  StackQL can be used to query cloud resources (including cross-provider JOIN queries) as well as provisioning and de-provisioning (using INSERT and DELETE) and lifecycle methods (like starting or stopping VM instances - using EXEC).

  There is a client mode and a server mode, which serves over the Postgres wire protocol; this is not a Postgres server - nor does it require one. It is not FDW based; we implement our own parser, planner, and executor. It is a self-contained dev tool that could be used in GitHub actions, standalone, or with a visualization solution (such as Tableau, Superset etc.).

  We seek feedback and suggestions for features and improvements (and contributors).

  Thanks for your help!