StackQL Studios maintainsstackql and 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.

The three pillars of StackQL Studios are:

• Relevance. Make users more productive and empowered.
• Reliability. Do what it says on the outside of the box.
• Elegance. As simple as possible, but no simpler. Ease of uptake and use.

These are the key streams in ongoing development:

1. RDBMS functionality, centred onthestackql core. SQL logic and ACID semantics atop TCP/IP, local process calls.
2. Generic foreign system CRUD viaany-sdk.
3. IAC support throughstackql-deploy andthev2 bleeding edgerust implementation. Because the core is lacking some ACID support and other useful constructs such asinsert... returning..., there are retries and checks etc. Eventually these will migrate to the core, coherently.
4. The coverage and testing ofprovider interface definition documents. These leverageany-sdk and are a key link in the chain.
5. Full support for thepostgres wire protocol. This will require coherent uplifts in the core.
6. Analytics. For now, this is managed in private repositories.

• 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%stackql magic 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 APIPOST bodies to extract, project or mutate data (similar to GraphQL, but using SQL)
stackql-playground		Front end application connecting to astackql-middleware server
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.

• Contributing Guidelines
• Discussions & Support

📜 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 atinfo@stackql.io

🌍 For more information, visit ourwebsite, follow us onX, or join ourDiscord Server.

Repositories