stackql

Query, provision and operate Cloud, SaaS, API and Model Context Protocol (MCP) resources through a unified SQL-based framework for humans and AI agents.

What is stackql?

Query, provision and operate Cloud, SaaS, API and Model Context Protocol (MCP) resources through a unified SQL-based framework for humans and AI agents.

Overview of stackql

What it is

StackQL is an open-source project built with Golang. It allows users to create, modify and query the state of services and resources across different local and remote interfaces using SQL semantics. These interfaces include cloud and SaaS providers such as Google, AWS, Azure, Okta, and GitHub. StackQL is a standalone application that can be used in client mode via exec or shell commands, or accessed via a Postgres wire protocol client using server mode (srv). It parses SQL statements and transpiles them into API requests to the resource provider. Provider interfaces are defined in OpenAPI extensions stored in the StackQL Registry. StackQL is also an MCP server, allowing AI agents to query and provision cloud resources over SQL.

Key features

  • Provides a unified SQL-based framework for querying, provisioning, and operating cloud, SaaS, API, and MCP resources.
  • Supports client mode (exec, shell) and server mode (srv) using the Postgres wire protocol.
  • Works with over 40 cloud and SaaS providers.
  • Offers output formats including json, csv, table, and text.
  • Can be used with MCP-capable clients (Claude, VS Code, Cursor) and is published to the Official MCP Registry.
  • Distributed via npm, PyPI, Docker, a GitHub Action, and .mcpb bundles.

Use cases

  • Querying and managing cloud resources interactively or in scripts.
  • Automating cloud infrastructure provisioning, IaC assurance, and compliance/security checks using GitHub Actions.
  • Running read-only cross-cloud security and FinOps audits via Docker.
  • Integrating with AI agents and MCP clients for agentic workflows.

Getting started

To install StackQL on MacOS via Homebrew: sh brew install stackql Or download the latest MacOS PKG installer from the releases page and run it. For Windows, download the MSI installer or use Chocolatey: sh choco install stackql For Linux, download and extract the ZIP archive: sh curl -L https://bit.ly/stackql-zip -O && unzip stackql-zip To run StackQL as an MCP server over stdio: sh stackql mcp --mcp.server.type=stdio For full installation and usage details, see the repository README.

License and pricing

Distributed under the MIT License. The pricing type is open source. For third-party licenses, see the /docs/licenses directory in the repository.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/stackqlstackql.svg)](https://yunodb.com/tools/stackqlstackql?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/stackqlstackql?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/stackqlstackql.svg" alt="Featured on YunoDB" height="20"></a>