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 universal SQL-based interface to manage, query, and deploy cloud resources and SaaS APIs. 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 using standard SQL semantics.

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 provider. It uses provider definitions (based on OpenAPI extensions) from a central registry to generate the necessary SQL schemas and API clients. Users can interact with it via an interactive shell, a command-line execution tool, or as a server using the Postgres wire protocol.

Who it’s for

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

Highlights

  • MCP Server Support: Implements the Model Context Protocol (MCP), allowing AI agents (like Claude or Cursor) to query and provision cloud resources via SQL.
  • Multi-Provider Support: Works across 40+ cloud and SaaS providers.
  • Flexible Interfaces: Accessible via a REPL shell, exec command, or a Postgres-compatible server mode.
  • No Database Required: Operates directly against APIs without needing to install or maintain a local database.

Related

  • Project
    haydenbleasel/files-sdk

    A unified storage SDK that provides a single API for interacting with multiple object and blob backends like S3, GCS, and Azure.

  • Project
    withcoral/coral

    A single SQL query interface for AI agents to access multiple data sources, reducing tool-call complexity and improving accuracy and cost efficiency.

  • Project
    sdcb/chats

    A flexible LLM frontend and API gateway that unifies 22+ AI model providers into a single interface with built-in code execution and enterprise management tools.

  • Project
    stanford-oval/suql

    A query language that extends SQL with free-text primitives to enable conversational search over databases containing both structured and unstructured data.

  • Project
    slothflowlabs/duckle

    An open-source ETL platform that compiles visual pipelines to SQL and runs them on DuckDB, allowing teams to deploy and own their data infrastructure without per-row billing.