<2-3 sentences summarising what the project addresses and solves, the target audience, and the benefit.> StackQL provides a unified SQL-based framework for querying, provisioning, and operating resources across cloud providers, SaaS applications, and APIs. It targets both human users and AI agents, simplifying complex infrastructure management by abstracting provider-specific APIs into familiar SQL semantics.

How It Works

StackQL operates as a standalone application, supporting client modes (exec, shell) and a server mode via the Postgres wire protocol. It parses SQL statements and transpiles them into the necessary API requests for target resource providers. Provider interfaces are defined using OpenAPI extensions, stored in the StackQL Registry, which are then used to generate SQL schemas and API clients. The architecture leverages the any-sdk library for defining provider interaction semantics.

Quick Start & Requirements

StackQL offers diverse installation methods across platforms: MacOS (Homebrew, PKG), Windows (MSI, Chocolatey, ZIP), Linux (ZIP), Docker (stackql/stackql), and GitHub Actions (setup-stackql). Official documentation is accessible at [__Read the docs »__][docs]. No specific hardware or software prerequisites beyond OS compatibility are detailed.

Highlighted Details

• MCP Server: Functions as an MCP server, enabling SQL-based interaction with over 40 cloud and SaaS providers for AI agents (e.g., Claude, VS Code, Cursor).
• Provider Support: Integrates with numerous cloud and SaaS providers (Google, AWS, Azure, Okta, GitHub, etc.) through a registry of provider definitions.
• Execution Modes: Offers an interactive REPL shell, an exec command for single statements or scripts (supporting JSON, CSV, table, text output), and a Postgres wire protocol server (srv).
• AI Integration: Designed for AI agents via the Model Context Protocol (MCP), with distribution options including npm, PyPI, Docker, and GitHub Actions.

Maintenance & Community

Community engagement is facilitated via Twitter (@stackql), email (info@stackql.io), and GitHub Discussions. Contributions are welcomed following the provided contributing guide. Release information and download statistics are available via GitHub badges.

Licensing & Compatibility

The project is distributed under the MIT License, generally permitting commercial use and integration without copyleft restrictions.

Limitations & Caveats

The provided README does not explicitly detail known limitations, alpha/beta status, or specific unsupported platforms.