StackQL MCP Server logo

StackQL MCP Server

Query, inspect, and provision cloud and SaaS resources through SQL-based MCP tools.

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 connects AI agents to cloud and SaaS provider APIs through StackQL's SQL interface. It exposes discovery tools for providers, services, resources, methods, and query templates, alongside read, validation, mutation, and lifecycle-operation tools. Use it when an agent needs to inspect or manage infrastructure across supported providers without addressing each API directly. The server runs over stdio and can be installed through npm, PyPI, Docker, or an .mcpb bundle.

Use cases

  • Query cloud resources with SQL
  • Inspect provider APIs and method contracts
  • Find and execute curated infrastructure query templates
  • Validate SELECT plans before execution
  • Provision or modify resources through SQL mutations

Key features

  • SQL access to cloud and SaaS provider APIs
  • Provider, service, resource, and method discovery
  • Curated query-library search and rendering
  • SELECT validation and execution
  • Mutation and lifecycle-operation execution
  • Credential reload and runtime inspection

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.

41/41 checks healthy over the last 62d

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 9d 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 downloads1.1kPackage downloads in the last 30 days.
Last commit3d agoMost recent push to the default branch.
Tools exposed15Callable tools this server registers over MCP.
Directory activity5 viewsConfig copies, upvotes, and views on AllMCPs.

How StackQL MCP Server works

What StackQL MCP Server does

StackQL MCP Server gives MCP clients an SQL-based interface to cloud and SaaS providers. StackQL translates SQL statements into API requests, sends them to the selected provider, and returns rows or operation messages. The underlying provider definitions come from the StackQL provider registry and describe the APIs, resources, inputs, and outputs available to the SQL layer.

The server supports both read-only inspection and operations that change remote state. SELECT queries return rows, while INSERT, UPDATE, REPLACE, and DELETE statements can make provider-side changes. Lifecycle actions are available through StackQL EXEC operations, such as starting an instance, when the server mode allows them.

How it works

Provider access follows a hierarchy of provider, service, resource, and method. Agents can list installed providers, inspect registry contents, enumerate services and resources, then retrieve the HTTP methods available for a resource. describe_method supplies the exact input and output contract for a method, including required parameters and fields that can be selected or returned.

For query construction, query_library_search finds curated templates by natural-language intent. query_library_get can return a raw template or validate supplied parameters and produce rendered SQL together with the execution tool. Agents can also validate a SELECT plan before executing it. Query-library operations are read-only and do not require credentials.

Provider credentials resolve at query time. If credentials have been changed, reload_credentials can re-source the configured environment file, clear cached authentication contexts, and report resolution status without exposing secret values. pull_provider installs a provider into the local application cache and has no cloud control-plane effect.

Setup and configuration

The server can run over stdio with:

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

MCP clients can launch it through npm using npx -y @stackql/mcp-server, through PyPI using uvx stackql-mcp-server, or through Docker with the stackql/stackql-mcp image. Platform-specific .mcpb bundles are also distributed through the latest release. The project supports Windows, macOS, and Linux.

Add the selected launch command to the client's MCP server configuration. Provider credentials and the provider registry determine which APIs can be queried and which operations can be performed.

Tools and capabilities

  • Discover installed providers with list_providers, or inspect registry providers and versions with list_registry.
  • Browse provider services and resources with list_services and list_resources.
  • Inspect method contracts with list_methods and describe_method.
  • Find and render vetted SQL templates with query_library_search and query_library_get.
  • Execute reads with run_select_query and preflight SELECT statements with validate_select_query.
  • Apply SQL mutations with run_mutation_query or execute lifecycle actions with run_lifecycle_operation.
  • Install providers locally using pull_provider and inspect runtime details with server_info.
  • Refresh changed credentials with reload_credentials after correcting the configured environment file.

Limitations and notes

Mutation and lifecycle tools can have real cloud side effects and are gated by server mode. SQL must match the provider method contracts, including required parameters. describe_method is method-specific because different methods on the same resource can return different shapes. Credential reloads should follow a credential-resolution failure or an explicit credential rotation, rather than being called at the start of every session.

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 clients to cloud and SaaS provider APIs through StackQL's SQL interface. Its main tools discover providers and method contracts, search query templates, execute SELECT statements, validate plans, apply mutations, and run lifecycle operations when enabled.

Install it through npm, PyPI, Docker, or an .mcpb bundle. For stdio, configure `npx -y @stackql/mcp-server`, `uvx stackql-mcp-server`, or the `stackql/stackql-mcp` Docker image in the MCP client configuration.

Yes, StackQL MCP Server works with Cursor through its stdio MCP configuration. Add one of the supported npm, PyPI, or Docker launch commands to Cursor's MCP server settings.

Use `list_providers`, then `list_services` and `list_resources` to navigate the provider hierarchy. Call `list_methods` for a resource and `describe_method` before composing a query against an unfamiliar method.

Related MCP servers

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>