📖 Read the docs »📝 Visit our blog »
👥 About Us·
🚀 Use Cases·
🗂️ Key Repositories·
👐 Getting Involved·
🛠️ Services We Provide
StackQL Studios maintainsstackqland related projects. We are software and data engineers who consider cloud and SaaS services, resources, and assets data sources. The best way to interact with data is throughSQL.
We are building a unified analytics and IaC framework using SQL for interacting with cloud and SaaS resources and APIs. Our provider registry is based OpenAPI and GraphQL definitions for cloud and SaaS providers; seestackql-provider-registry.
Our config file-based provider plugin approach lowers the entry barrier for contributions compared to traditional code-intensive plugin frameworks. Our SQL-based framework enables a broader audience of users without requiring them to learn yet another DSL.
🌐 Simplifying multi-cloud cloud resource management, XOps, and observability using familiarity and power of SQL.
- Simplified Cloud Auditing and Compliance:Audit resource deployments and configurations across multiple cloud and SaaS providers using a simple SQL-based framework
- Federated Entitlements and Identity Management:Generate reports joining data from an IdP with entitlements in a SaaS, PaaS, or IaaS resource provider
- FinOps and Cost Optimization:Analyze global resource deployment across multiple providers to identify opportunities for cost recovery or savings
- Custom Reporting and Dashboarding:Create custom multi-cloud inventory reports
- Multi-cloud Resource Management:One consistent SQL-based framework for XOps across all cloud, IdP and SaaS providers
- Automated Infrastructure as Code (IaC):Transactional multi-cloud infrastructure-as-code framework using a SQL ETL approach
- CI/CD Integration for Deployment Validation:Integrate StackQL in your CI/CD workflows to validate resource state or enforce compliance
| Repository | Languages | Description |
|---|---|---|
stackql |
 |
StackQL core project that enables users to interact with cloud resources using SQL. |
stackql-provider-registry |
  |
A registry for cloud and SaaS providers for StackQL, generated from extensions to the providers' OpenAPI3 specifications. |
stackql-deploy |
  |
Declarative, state-file-less, infrastructure-as-code using StackQL, see it onpypi. |
stackql-deploy-action |
 |
GitHub Action to deploy or test stacks usingstackql-deploy. |
stackql-demo |
  |
Sample StackQL queries for CSPM, FinOps, inventory and more |
stackql-jupyter-demo |
|
Jupyter hub image with StackQL, including%stackqlmagic commands along with some sample notebooks to get started |
stackql-actions-demo |
 |
Demonstration of the StackQL GitHub Marketplace Actions to use StackQL in GitHub Actions workflows |
stackql-codespaces-notebook |
|
Template repository to use StackQL in GitHub Codespaces, along with sample notebooks to get started |
stackql-server |
 |
Self contained StackQL server with a Postgres backend for relational algebra and temporary storage, seestackql/stackql-server |
stackqljs |
   |
StackQL client library for Deno and Node.js, seenpmjs |
pystackql |
|
PyPi package to use StackQL within Python or IPython applications, seereadthedocs |
setup-stackql |
|
GitHub Action to setup StackQL in an Actions workflow; see overview in the GitHub Actionsmarketplace |
stackql-assert |
|
GitHub Action to run compliance or validation checks using StackQL in an Actions workflow; see overview in the GitHub Actionsmarketplace |
stackql-exec |
|
GitHub Action to execute StackQL queries in an Actions workflow; see overview in the GitHub Actionsmarketplace |
google-discovery-to-openapi |
|
Extracts compliant OpenAPI3 specification from Google discovery docs |
aws-cfn-schema-to-openapi |
|
Creates compliant OpenAPI3 specifications with StackQL extensions from AWS CloudFormation schema documents |
stackql-azure-openapi |
|
Creates compliant OpenAPI3 specifications from Microsoft AutoRest |
openapisaurus |
|
StackQL provider development studio using Deno/TypeScript |
stackql-middleware |
|
Use StackQL with a public or private registry to submit SQL queries in APIPOSTbodies to extract, project or mutate data (similar to GraphQL, but using SQL) |
stackql-playground |
 |
Front end application connecting to astackql-middlewareserver |
any-sdk |
|
Golang library to support traversal algorithms on StackQL augmented openapi doc structure and SQL semantics. |
We welcome contributions and community involvement in StackQL. Whether you're interested in contributing code (including SQL queries or new providers), reporting bugs, or requesting features, your input is valuable to us.
📜 StackQL is released under theMIT License.
StackQL Studios provides custom audit services to create and automate client reports for Cloud Security Posture Management, Entitlements or User Access Management, FinOps/Cost Optimization, Network Analysis, Multi-Cloud Inventory Analysis, and more. Contact us at[email protected]
🌍 For more information, visit ourwebsite,follow us onX,or join ourDiscord Server.
