MCP serverSafeDeploy & DevOpsSome setup

stackql

This SQL-based framework allows AI agents to query, provision, and operate Cloud, SaaS, API, and MCP resources using standard SQL commands.

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

1.1k stars87License: MITUpdated 3 days ago0 opens

Preview

▍

What you can do with it

Provision new cloud infrastructure components like virtual machines or databases using SQL queries.
Query the status and configuration of your SaaS applications or cloud services through an agent.
Automate compliance checks by using SQL to audit cloud resource configurations.

Safety check

Safe

No risky patterns found in the files we scanned.

Automated scan of the repo files. Always review code you run.

From the README

stars

Deploy, manage and query cloud resources and interact with APIs using SQL

The Universal Interface for the Agentic Era. Configuration-as-Data. Infrastructure-as-Context.

Read the docs »
Raise an Issue · Request a Feature · Developer Guide · BYO Providers

Contents

About The Project

StackQL is an open-source project built with Golang that allows you to create, modify and query the state of services and resources across different local and remote interfaces, using SQL semantics. Such interfaces canonically include, but are not limited to, cloud and SaaS providers (Google, AWS, Azure, Okta, GitHub, etc.).

stackql-shell

How it works

StackQL is a standalone application that can be used in client mode (via exec or shell) or accessed via a Postgres wire protocol client (psycopg2, etc.) using server mode (srv).

StackQL parses SQL statements and transpiles them into API requests to the (cloud) resource provider. The API calls are then executed and the results are returned to the user.

StackQL provider interfaces are canonically defined in OpenAPI extensions to the providers' specification. These definitions are then used to generate the SQL schema and the API client. The source for the provider definitions are stored in the StackQL Registry. The semantics of provider interactions are defined in our any-sdk library. For more detail on nuts and bolts, please see the local AGENTS.md file and that of any-sdk.

StackQL Context Diagram

The following context diagram describes the StackQL architecture at a high level:

flowchart LR
  subgraph StackQL
    direction BT
    subgraph ProviderDefs
        Registry[Provider Registry Docs]    
    end
    subgraph App
        Proc[$ stackql exec\n$ stackql shell\n$ stackql srv]
        style Proc fill:#000,stroke:#000,color:#fff,text-align:left;

        %% ,font-family:'Courier New', Courier, monospace
    end
  end
  User((User)) <--> StackQL <--> Provider[Cloud Provider API]
  ProviderDefs --> App

More detailed design documentation can be found in the here.

MCP Server

StackQL is an MCP server - SQL over 40+ cloud and SaaS providers for AI agents. Point any MCP-capable client (Claude, VS Code, Cursor, etc.) at StackQL and it can query and provision cloud resources using SQL.

Run it over stdio:

stackql mcp --mcp.server.type=stdio

StackQL MCP is published to the Official MCP Registry as `io.github.stackql/st

View source on GitHub