Stackql is an MCP server tool built with Golang, designed for managing cloud infrastructure. It functions as an open-source cloud-service query engine and an infrastructure-as-code tool. Distributed via platform-specific binaries, Docker images, GitHub Actions, npm, PyPI, and .mcpb bundles, Stackql enables developers, engineers, and operators to interact with cloud and SaaS providers using SQL. It connects to various resources, offering a unified interface for diverse cloud environments and AI agent integration.

What does Stackql connect to?

Stackql connects to Cloud, SaaS, API, and Model Context Protocol (MCP) resources. This includes major cloud providers such as AWS, GCP, Azure, and Kubernetes. It also integrates with SaaS providers like GitHub, accessing their functionalities through their REST APIs. Stackql operates as an MCP server tool, an open-source cloud-service query engine, and an infrastructure-as-code tool, providing a unified interface across these diverse platforms.

Core features and tools

Stackql provides several callable tools for interaction. Users can access an interactive REPL using stackql shell, execute SQL statements or files with stackql exec, or run it as a server via the Postgres wire protocol using stackql srv. As an MCP server, it exposes tools for AI agents, including list_resources, describe_resource, and run_select_query. It supports standard SQL CRUDL operations (SELECT, INSERT, UPDATE, REPLACE, DELETE) and EXEC for lifecycle operations. Specific GitHub Actions such as setup-stackql are also available.

Who is it for?

Stackql is designed for developers, AI agents, engineers, and operators who manage cloud infrastructure across multiple providers. It helps these users interact with various cloud and SaaS resources using a familiar SQL interface, simplifying tasks like asset inventory, infrastructure management, and security audits. Its integration with AI clients and CI/CD pipelines positions it as a tool for automated cloud operations and compliance. Skip this if your workflow does not involve managing multi-cloud resources or interacting with REST APIs via SQL.

How to get started

The server authenticates using an API key passed as an environment variable. For MCP server mode, bearer authentication is used, with credentials resolved server-side.

Use cases

• Cloud Asset Inventory and Reporting: Query live state across various providers using SQL to generate reports and inspect infrastructure, such as auditing a GitHub organization.
• Infrastructure as Code (IaC) and Lifecycle Management: Provisioning, de-provisioning, and performing lifecycle operations on cloud resources using SQL statements like INSERT, UPDATE, DELETE, and EXEC.
• Cloud Security Posture Management (CSPM) and Compliance: Running cross-cloud security and FinOps audits, validating system states, and performing compliance checks within CI/CD pipelines using SQL queries.

Stackql offers a unified SQL interface for managing diverse cloud and SaaS resources, appealing to engineers and AI agents. Its ability to perform CRUDL operations and lifecycle management across multiple providers makes it a versatile tool for cloud operations. The support for various authentication methods and deployment options adds to its adaptability. Try auditing a GitHub organization by querying its live state using Stackql's SQL capabilities.