stackql/stackql

What it solves

StackQL provides a universal interface to deploy, manage, and query cloud resources and SaaS APIs using SQL semantics. It eliminates the need to learn multiple provider-specific APIs or CLI tools by allowing users to interact with services like AWS, Azure, Google Cloud, Okta, and GitHub through a standardized SQL-like language.

How it works

StackQL is a standalone Golang application that acts as a transpiler. It parses SQL statements and converts them into 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 StackQL 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 agents who need to manage multi-cloud infrastructure, perform cross-cloud audits (security and FinOps), or automate cloud provisioning within agentic workflows.

Highlights

• Multi-Provider Support: Works across 40+ cloud and SaaS providers.
• AI Agent Integration: Native MCP server implementation for seamless use with AI agents.
• Postgres Compatibility: Accessible via the Postgres wire protocol without requiring an actual database installation.
• Flexible Execution: Supports interactive shells, command-line execution, and GitHub Actions integration.