stackql/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 it solves

StackQL provides a unified way to deploy, manage, and query cloud resources and SaaS APIs using SQL semantics. It eliminates the need to learn multiple proprietary APIs or CLI tools by allowing users to interact with various providers (like AWS, Azure, Google Cloud, Okta, and GitHub) through a single, standardized SQL interface.

How it works

StackQL is a standalone Golang application that acts as a transpiler. It parses SQL statements and converts them into the corresponding API requests for the target cloud or SaaS provider. These provider interfaces are defined using OpenAPI extensions, which StackQL uses to generate the necessary SQL schemas and API clients.

Users can interact with the system in three ways:

  1. Client Mode: Using an interactive shell or the exec command.
  2. Server Mode: Using the Postgres wire protocol, allowing it to be accessed by any Postgres-compatible client.
  3. MCP Server: Acting as a Model Context Protocol (MCP) server, enabling AI agents (like Claude or Cursor) to query and provision cloud resources via SQL.

Who it’s for

It is designed for developers, DevOps engineers, and AI agent builders who need to manage multi-cloud infrastructure, perform cross-cloud audits, or provide AI agents with a structured way to interact with cloud environments.

Highlights

  • Universal SQL Interface: Use SQL to create, modify, and query resources across 40+ cloud and SaaS providers.
  • AI Agent Integration: Native MCP server support allows AI agents to interact with cloud infrastructure as context.
  • Database-less: Does not require the installation or management of a traditional database.
  • Flexible Access: Supports interactive shells, command-line execution, and the Postgres wire protocol.