StackQL

MCP server by StackQL

Query and provision cloud and SaaS resources across 40+ providers using SQL statements.

Runs locally (Runs on your machine: its page has the install command)Runs with npx

Install StackQL

Runs on your machine. Your client starts it with this command:

npx -y @stackql/mcp-server

Needs Node.js on your computer. The setup steps below show where the command goes in each client.

Share this server

Opens this page, with the install command and setup steps.

mcp.tc/i/stackql

About

StackQL turns SQL statements into API calls against cloud and SaaS providers such as Google, AWS, Azure, Okta and GitHub. Through MCP, an assistant can query the state of resources and provision or change them using SQL, based on provider definitions from the StackQL provider registry.

It runs locally over stdio. Install it with npx (@stackql/mcp-server), uvx (stackql-mcp-server), Docker (stackql/stackql-mcp) or a platform-specific .mcpb bundle. A GitHub Action is available for CI and defaults to read-only mode. Provider credentials are needed for the clouds you query.

What you can do

  • Query cloud and SaaS resources using SQL
  • Provision and modify resources through SQL statements
  • Work across 40+ providers including Google, AWS, Azure, Okta and GitHub
  • Run in read-only mode for CI workflows
  • Install via npm, PyPI, Docker or .mcpb bundle

Tools

Local servers list their tools once they’re running, and this one doesn’t publish its list in advance. Your client shows them after you add it.

Example prompts

  • List all my AWS EC2 instances that are stopped, using StackQL.

  • Query Google Cloud storage buckets and show which are public.

  • Show GitHub repositories in my organization with no recent pushes.

  • Use SQL to list Azure virtual machines grouped by region.

Set up

Every client starts StackQL on your machine with the same command. Pick yours; the page remembers your choice.

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport stdio stackql -- npx -y @stackql/mcp-server
  1. Start Claude Code and type /mcp. stackql should show as connected.

Add --scope user to make it available in every project.

Claude Desktop

  1. Open Settings → Developer → Edit Config. It opens claude_desktop_config.json. Add:
claude_desktop_config.json
{
  "mcpServers": {
    "stackql": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}
  1. Save the file and restart Claude Desktop.

Needs Node.js on your computer. The file lives in ~/Library/Application Support/Claude/ on macOS and %APPDATA%\Claude\ on Windows.

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

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

Needs Node.js on your computer.

VS Code

Or from a terminal:

code --add-mcp '{"name":"stackql","type":"stdio","command":"npx","args":["-y","@stackql/mcp-server"]}'

Or commit it to the repo in .vscode/mcp.json:

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

Needs Node.js on your computer.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "stackql": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}
  1. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf.

Codex

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

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.stackql]
command = "npx"
args = ["-y", "@stackql/mcp-server"]

Needs Node.js on your computer.

Gemini CLI

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

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients that start local servers accept this shape:

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

Zed puts servers under context_servers in its settings, with the same command, args and env fields.

Needs Node.js on your computer.

FAQ

Can I paste mcp.tc/i/stackql into my MCP client?

No. StackQL runs on your own computer, started by your client, so it has no web address to connect to. The quick link is the page to share; the install command is npx -y @stackql/mcp-server.

Does StackQL need an API key?

No. It doesn’t declare any keys or environment variables. It runs with your user account’s permissions, so check what its tools can reach.

Is StackQL a remote or a local server?

Local. Your client starts it as a process on your computer with npx -y @stackql/mcp-server, which needs Node.js.

What can StackQL do?

You can query cloud and SaaS resources using SQL, provision and modify resources through SQL statements and work across 40+ providers including Google, AWS, Azure, Okta and GitHub.

Which clients can use it?

Any client that starts local servers: Claude Code, Claude Desktop, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. claude.ai and ChatGPT only connect to remote servers.

Who wrote this page?

mcp.tc’s robot read StackQL’s public metadata (its package and repository pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

Embed

Show StackQL in a README or on your site. Each embed links to this page, uses the server’s own install command, and sets no cookies. How embeds work

README badge

Badge preview, lightBadge preview, dark
Markdown
[![StackQL on mcp.tc](https://mcp.tc/i/stackql/badge.svg)](https://mcp.tc/i/stackql)
HTML
<a href="https://mcp.tc/i/stackql"><img src="https://mcp.tc/i/stackql/badge.svg" alt="StackQL on mcp.tc" height="20"></a>

It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.

Website card

HTML
<script src="https://mcp.tc/w/stackql.js" async></script>

The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.

iframe

HTML
<iframe src="https://mcp.tc/embed/stackql" title="StackQL on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.

JSON

The listing as data for your own pages and tools: name, tagline, install command, tools and the “Add to” links. Any site can read it (CORS is open).

https://mcp.tc/i/stackql.json

What each field means

mcp.tc isn’t affiliated with StackQL. This page was built from StackQL’s public metadata, last checked on 4 Oct 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.