Log inSubmit server
StackQL MCP Server logo

StackQL MCP Server

Query and manage cloud and SaaS resources through SQL-based MCP tools backed by StackQL providers.

InstallRepositoryWebsite
Full README Compare alternatives Embed widget Claim this listing

Install StackQL MCP Server

Pick your client, then add it in one click or paste the config.

STDIONode.js
~/Library/Application Support/Claude/claude_desktop_config.json
claude_desktop_config.json
{
  "mcpServers": {
    "stackql-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@stackql/mcp-server"
      ]
    }
  }
}

Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.

Install not yet sandbox-tested— the server itself is confirmed live (we called its tools/list endpoint). The stdio install command is a separate, ongoing check.

Overview

StackQL MCP Server exposes StackQL’s SQL interface to cloud and SaaS APIs through MCP. It lets agents discover providers, services, resources, and method contracts before running read queries, mutations, or lifecycle operations. StackQL translates SQL into provider API requests, with registry-backed provider definitions and local provider caching. Reach for it when an agent needs a structured way to inspect or provision resources across supported providers.

Use cases

  • Query cloud resources with SQL
  • Discover provider APIs and required parameters
  • Render vetted query templates
  • Validate SELECT plans before execution
  • Provision or modify resources through gated mutations

Key features

  • SQL access to cloud and SaaS APIs
  • Provider, service, resource, and method discovery
  • Curated query library with parameter validation
  • Read queries, mutations, and lifecycle operations
  • Local provider installation and registry versioning
  • Credential reload and runtime diagnostics

Tools15

What StackQL MCP Server lets your agent do. Expand a tool for its parameters.

Verified live~2.1k tokens of context

Security & health

What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.

ActiveLast checked Today

Recent health check succeeded.

12/12 checks healthy over the last 44d

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 8d ago via OSV.dev · @stackql/mcp-server (npm)

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars1.1kStargazers on the source repository.
npm downloads921Package downloads in the last 30 days.
Last commitTodayMost recent push to the default branch.
Tools exposed15Callable tools this server registers over MCP.
Directory activity3 viewsConfig copies, upvotes, and views on AllMCPs.

How StackQL MCP Server works

What StackQL MCP Server does

StackQL MCP Server brings StackQL’s SQL-based cloud and SaaS interface to MCP clients. StackQL can query, modify, and manage resources across more than 40 cloud and SaaS providers, including examples such as AWS, Google Cloud, Azure, Okta, and GitHub. The MCP layer exposes discovery, query execution, provider management, credential reloading, and runtime inspection tools.

Read operations use run_select_query and return rows. run_mutation_query handles SQL mutations such as INSERT, UPDATE, REPLACE, and DELETE; lifecycle actions are handled separately by run_lifecycle_operation. Mutations and lifecycle operations can affect real cloud resources and are subject to server mode controls.

How it works

StackQL parses SQL and converts it into API requests for the selected provider. Provider definitions come from StackQL’s registry and describe the API-backed schema and client behavior. The MCP discovery tools reflect the provider hierarchy: providers contain services, services contain resources, and resources expose HTTP methods.

A typical agent workflow is to search the query library, retrieve and parameterize a matching template, then execute the returned SQL with the indicated tool. For unfamiliar resources, the agent can call list_methods, select a method whose verb and required parameters match the task, and call describe_method before composing a query. validate_select_query can preflight a read query without executing it, although provider credentials still need to resolve.

Setup and configuration

The server runs over stdio with:

sh
stackql mcp --mcp.server.type=stdio

It can be installed or launched through several distribution paths. The npm package uses npx -y @stackql/mcp-server; the PyPI package uses uvx stackql-mcp-server; and Docker uses the stackql/stackql-mcp image with an interactive container. Platform-specific .mcpb bundles are also distributed through releases.

A client configuration maps an MCP server name to the selected command and arguments. The project identifies Claude, VS Code, and Cursor as MCP-capable client examples. Provider packages can be installed into the local approot cache with pull_provider; an empty version selects the latest published version.

Tools and capabilities

  • Discover providers, services, resources, methods, and method contracts.
  • Search and render curated StackQL query-library templates.
  • Run read-only SELECT statements and validate their syntax and plans.
  • Execute SQL mutations and provider lifecycle operations when permitted by server mode.
  • Reload provider credentials after environment-file changes without returning secret values.
  • Inspect StackQL version, SQL engine, registry location, mode, and read-only status.

Limitations and notes

Provider discovery has two scopes: list_providers reports providers already pulled locally, while list_registry reports providers and versions available from the configured registry. Provider credentials must resolve for query execution and for select-query validation. Credential reload is intended after a credential-resolution failure or an explicit credential rotation, rather than as a routine session-start action.

Mutation and lifecycle tools produce real side effects and are gated by server mode. Query-library entries are read-only, but rendered templates can be passed to execution tools. server_info and credential reload are on-demand operations rather than prerequisites for every query.

Read the full README View source on GitHub

Reviews

No reviews yet — be the first to share how it worked for you.

Frequently Asked Questions about StackQL MCP Server

StackQL MCP Server is an MCP server that connects AI agents to cloud and SaaS provider APIs through StackQL’s SQL interface. Its main tools discover providers and API methods, search and render query templates, run SELECT or mutation queries, execute lifecycle operations, validate SELECT statements, and inspect runtime details.

Install it through npm, PyPI, Docker, or an .mcpb bundle. The stdio npm configuration runs `npx -y @stackql/mcp-server`, PyPI uses `uvx stackql-mcp-server`, and Docker runs `stackql/stackql-mcp` with an interactive container.

Yes, StackQL MCP Server works with Cursor. The project lists Cursor among MCP-capable clients; configure the client to launch the server over stdio using one of the supported installation commands.

Use `list_methods` to find the resource’s HTTP methods and required parameters, then call `describe_method` for the selected method. The description includes input types and output fields that can be referenced by SELECT or RETURNING clauses.

Call `reload_credentials` after updating the configured environment file and after a credential-resolution failure or reported credential rotation. It refreshes provider authentication contexts and returns resolution status without exposing secret values.

Related MCP servers

All in Databases All alternatives
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewStackQL MCP Server AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/stackql-mcp-server?style=directory)](https://allmcps.com/mcp/stackql-mcp-server)
HTML Embed
<a href="https://allmcps.com/mcp/stackql-mcp-server"><img src="https://allmcps.com/api/badge/stackql-mcp-server?style=directory" alt="StackQL MCP Server on AllMCPs" /></a>