StackQL is an open source tool enabling developers and analysts to query and interact with cloud and SaaS services using a SQL grammar and an ORM that maps to the particular cloud or SaaS provider.
StackQL includes a SQL parser, DAG planner, and executor, which transpiles SQL statements to provider API requests, returning responses as tabular data (with support for complex objects and arrays).
StackQL can be used for cloud/SaaS inventory, reporting, and analysis, with the ability to correlate data across cloud providers using SQL JOIN operations.
StackQL can also be used for traditional infrastructure-as-code operations such as scaffolding, provisioning, and de-provisioning, as well as lifecycle operations such as starting or stopping VM instances, activating/deactivating users, etc. StackQL routines can source configuration data or variables from json or jsonnet files.
StackQL providers are defined by extensions to the providers OpenAPI specification, more information can be found at stackql/stackql-provider-registry and stackql/openapi-doc-util.
Query, provision and operate Cloud and SaaS resources and APIs using an extensible SQL based framework
Registry for cloud and SaaS providers for StackQL, generated from extensions to the providers OpenAPI3 specification
GitHub Actions for using `stackql` in workflows, for more information see https://github.com/stackql/stackql and give us a ⭐ while you're there!
DEPRECATED: Replaced by https://github.com/stackql/openapisaurus
StackQL Jupyter Notebook Demo
StackQL provider documentation for cloud and SaaS providers available in the StackQL Provider Registry, built with Docusaurus.
Middleware solution to allow clients to query back end APIs using SQL
Sets up the stackql cli in your GitHub Actions workflow.
Run stackql queries in GitHub Codespaces
Generates a single OpenAPI document for each Azure Resource Manager service from a set of OpenAPI specifications sourced from Azure REST API specs
GCP foundations using StackQL
Model driven resource provisioning and deployment framework using StackQL.
Real time notifications for open source project maintainers
REPLACED BY https://github.com/stackql/stackql-registry-docs
Created by Jeffrey Aven and Kieran Rimmer
Released July 2021