Skip to content
MCP server

StackQL MCP Server

Query and provision cloud and SaaS resources with SQL, exposed to AI agents over MCP

Runs locallyStatus and history
Install
Pricing
Open source
Platforms
CLI, macOS, Linux
Runs
Locally
Version
1.0.888
Listing updated
3 days ago

About StackQL MCP Server

StackQL MCP Server is an open-source MCP server for cloud and infrastructure. It runs locally on your machine and is started by your AI client.

StackQL treats provider APIs as tables. A query such as a GROUP BY over aws.ec2.instances returns live state, and an INSERT into google.compute.disks creates a resource, with no state file to manage and no per-cloud SDK. The MCP server hands AI agents that same SQL interface, so one grammar covers reading inventory, asserting desired state and making changes.

The server is built from the open-source StackQL engine, written in Go, and ships as an mcpb bundle for Linux, macOS and Windows, an OCI image, an npm package and a PyPI package, all over stdio. Providers include AWS, Azure, Google Cloud, Okta and GitHub, with more in a provider registry.

It suits platform and SRE teams, security and FinOps teams who need live inventory or compliance answers, and developers building agents that must query and change cloud resources. Typical jobs are asset inventory, drift detection and compliance attestation. The MCP tool names are not listed in the registry entry.

Install

Run in a terminal

claude mcp add stackql-mcp -- npx -y @stackql/mcp-server

Add to claude_desktop_config.json

{
  "mcpServers": {
    "stackql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "stackql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "stackql-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "stackql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "stackql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}

What it does

SQL over cloud APIs
SELECT, INSERT, UPDATE and DELETE statements map to provider API calls.
No state file
Reads live state each time instead of keeping a separate state store.
Many install routes
Available as mcpb bundles, an OCI image, npm and PyPI packages.
Beyond MCP
The same engine also runs as a CLI, in CI, in Docker and as a PostgreSQL-compatible server for BI tools.
Provider registry
Cloud and SaaS providers are described in a registry you can extend with your own.

Good for

  • Count running instances by state across a region
  • Detect configuration drift between desired and live state
  • Produce cloud asset inventory and compliance reports
  • Let an agent provision a resource with an INSERT statement
  • Query SaaS APIs such as GitHub or Okta as tables

Pricing

Open source

MIT licensed; commercial support by enquiry

Prices change. Check stackql.io before you buy.

StackQL MCP Server FAQ

What license does StackQL use?

MIT, free to use for any purpose; commercial support is available through StackQL Studios.

Which providers can it query?

Examples named include AWS, Azure, Google Cloud, Okta and GitHub; the site links a list of available providers.

Does it need Terraform or a state file?

No. It queries and changes live state through provider APIs without a state file.

How is it installed as an MCP server?

Through an mcpb bundle, a Docker image, `@stackql/mcp-server` on npm or `stackql-mcp-server` on PyPI, all over stdio.

Is StackQL MCP Server free?

Yes. StackQL MCP Server is open source, so you can use and self-host it for free.

How do I add StackQL MCP Server to Claude Code?

Run this command in your terminal: claude mcp add stackql-mcp -- npx -y @stackql/mcp-server

What are the best alternatives to StackQL MCP Server?

The closest alternatives to StackQL MCP Server are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

Alternatives to StackQL MCP Server

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Ouroboros

    MCP server

    Spec-first layer that pins requirements and verifies results of AI coding agent work

    Runs locally
    • Open source
    • 6.4K GitHub stars
    • Developer tools