# StackQL MCP Server

> StackQL MCP Server is an open-source MCP server for cloud and infrastructure. Query and provision cloud and SaaS resources with SQL, exposed to AI agents over MCP. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, macOS, Linux, Windows, self-hosted
- **Website:** https://stackql.io
- **Repository:** https://github.com/stackql/stackql
- **MCP Registry name:** io.github.stackql/stackql-mcp
- **Categories:** cloud and infrastructure, developer tools
- **Listing updated:** 2026-11-14

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "stackql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@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

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/stackql-mcp-server
