StackQL Studios

StackQL Studios maintains stackql 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 through SQL.

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; see stackql-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.

🔍 Looking for StackQL Provider Dev Projects Head to the stackql-registry GitHub org.

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 on the stackql core. SQL logic and ACID semantics atop TCP/IP, local process calls.
2. Generic foreign system CRUD via any-sdk.
3. IAC support through stackql-deploy and the v2 bleeding edge rust implementation. Because the core is lacking some ACID support and other useful constructs such as insert... returning..., there are retries and checks etc. Eventually these will migrate to the core, coherently.
4. The coverage and testing of provider interface definition documents. These leverage any-sdk and are a key link in the chain.
5. Full support for the postgres 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
• ✨ AI Control Plane Automation - Use StackQL as an MCP server to give AI agents and LLMs direct, SQL-based access to cloud and SaaS APIs for querying, provisioning, and managing resources
• ✨ Self-Describing Observability for AI Agents - StackQL's provider registry and SQL interface are inherently discoverable, enabling AI agents to introspect available resources, operations, and schemas without external documentation
• ✨ AI-Native Infrastructure Tooling - Integrate StackQL into agentic workflows, copilots, and chat-driven operations as a unified tool for multi-cloud infrastructure reasoning and action

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 on pypi.
stackql-deploy-action		GitHub Action to deploy or test stacks using stackql-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, see stackql/stackql-server
stackqljs		StackQL client library for Deno and Node.js, see npmjs
pystackql		PyPi package to use StackQL within Python or IPython applications, see readthedocs
setup-stackql		GitHub Action to setup StackQL in an Actions workflow; see overview in the GitHub Actions marketplace
stackql-assert		GitHub Action to run compliance or validation checks using StackQL in an Actions workflow; see overview in the GitHub Actions marketplace
stackql-exec		GitHub Action to execute StackQL queries in an Actions workflow; see overview in the GitHub Actions marketplace
stackql-middleware		Use StackQL with a public or private registry to submit SQL queries in API POST bodies to extract, project or mutate data (similar to GraphQL, but using SQL)
stackql-playground		Front end application connecting to a stackql-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 the MIT 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 info@stackql.io

🌍 For more information, visit our website, follow us on X, or join our Discord Server.