StackQL
Query, provision, and operate cloud and SaaS resources and APIs using an extensible SQL-based framework.
StackQL is an open-source Go-based tool that enables users to create, modify, and query the state of various cloud and SaaS resources and APIs using standard SQL semantics. It acts as an extensible framework, transpiling SQL statements into API requests for providers like Google, AWS, Azure, Okta, and GitHub, and returning the results. It can be used via an interactive shell, direct execution, or as a server supporting the Postgres wire protocol, effectively allowing SQL to manage and observe diverse infrastructure without requiring a database.
Key Features
01Manage cloud and SaaS resources with SQL semantics
02841 GitHub stars
03Supports interactive shell, direct execution, and Postgres wire protocol server mode
04Transpiles SQL statements into native API requests for cloud providers
05Parameterize operations using variables defined in JSON or Jsonnet
06Extensible through OpenAPI-defined provider interfaces in a centralized registry
Use Cases
01Automating cloud infrastructure for IaC assurance, compliance, and security
02Querying the real-time state of various cloud services and APIs using SQL
03Provisioning and operating cloud and SaaS infrastructure