Stackql

MCP数据服务

提供方 stackql

数据服务 未标注 会话登录 社区 / 第三方 Claude DesktopClaudeCursorCodex

Open source SQL-native query and provisioning engine for cloud and SaaS infrastructure. Ships as a single signed binary with MCP tools for provider discovery, schema exploration, queries, and lifecycle operations.

一句话选型结论

按资料字段整理

Stackql 属于数据服务类 MCP 服务器,传输方式未标注,会话登录,可直接接入 Claude Desktop、Claude、Cursor 等,没有现成安装命令,需按官方文档接入。接入前先确认权限范围;涉及写入、删除或付款的操作,建议先在测试环境验证。

分类数据服务 传输方式未标注 鉴权会话登录 部署方式未标注
GitHub 星标 未标注 仓库热度,无公开仓库时显示未标注
工具数 未标注 暴露给模型的工具数量
资源 / 提示词 0 / 0 资源与提示词模板数量
维护方 社区 / 第三方 核验等级 仅资料核对

工具与能力

数据服务
数量来自来源目录的标注,具体工具清单以官方文档为准
工具数量未标注暴露给模型可调用的工具个数
资源数量0可读取的资源条目
提示词数量0内置提示词模板数量

能力标签

支持客户端

适用场景

cloudsqlinfrastructure

安装与配置

未标注 会话登录
上游未给出传输方式
  1. 1
    准备运行环境

    按官方文档确认运行环境(常见为 Node.js 或 Python),装好后再执行安装命令。

  2. 2
    安装服务

    复制上面的安装命令执行;命令里带占位符的位置,换成自己的密钥或路径。

  3. 3
    写入客户端配置

    在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,让新配置生效。

  4. 4
    验证是否可用

    连接成功后随便调一个只读工具,确认能返回结果,再接入正式流程。

典型使用场景

3 类
按分类与标签整理的常见用法,具体以官方文档为准
数据库查询

用自然语言查库、取数,不用手写 SQL。

数据同步与清洗

把多来源数据拉到一处做整理。

报表取数

按口径快速拉出统计结果。

选择建议

选之前先看这几条
按条目字段给出的判断,不替你决定用不用

值得选的地方

  • 已适配 Claude Desktop、Claude、Cursor,换客户端不用重新研究配置。

先想清楚的地方

  • 没有现成安装命令,需要按官方文档自己填启动命令和参数。
  • 使用前要准备好会话登录对应的凭据,并按最小权限配置。
  • 资料没标注工具数量,实际能力要装好后确认。
  • 版本更新与行为细节以官方仓库为准。

更适合

  • 需要在数据服务场景里让模型直接调用外部能力的人。
  • 已经在用 Claude Desktop、Claude 的用户,接入路径最短。
  • 想先快速试一下、能接受在本地或自有环境跑服务的人。

不太适合

  • 不方便管理密钥或第三方授权的人。
  • 需要厂商级 SLA 和技术支持的生产环境。

同类对比

6 个同类
同分类里挑最接近的几条,字段以各自详情页为准
MCP 服务器工具数传输方式部署方式安装命令最后核验
Stackql当前 未标注 未标注 未标注 无 未标注
Memory 9d25f64e 9 未标注 未标注 无 2026-05-17
Getzep MCP 9 stdio · 本地进程 本地部署 有 2026-05-17
anything-llm 未标注 stdio · 本地进程 本地部署 有 2026-04-11
Prisma MCP Server 未标注 stdio · 本地进程 本地部署 有 2026-05-17
Astr Bot 未标注 stdio · 本地进程 本地部署 有 2026-05-17

服务器档案

数据服务
字段来自项目仓库与公开索引,中文说明由本站标注
提供方stackql上游标注的维护方 stackql
分类数据服务本站按上游分类展示
连接方式未标注上游未给出传输方式
鉴权方式会话登录远程服务建议用最小权限凭据
维护方社区 / 第三方核验等级 仅资料核对
包名 / 运行时未标注 · Cross-platform本地安装时用到的包标识与运行时
部署类型未标注上游给出的部署形态
最近核验未标注上游最后核验时间

详细介绍

7.3 KB
来自项目仓库与上游目录的原文,未做删改

[![logo]][homepage]

![platforms]
![license]
![build]

![stars]

Deploy, manage and query cloud resources and interact with APIs using SQL

The Universal Interface for the Agentic Era. Configuration-as-Data. Infrastructure-as-Context.

Read the docs »
Raise an Issue ·
Request a Feature ·
Developer Guide ·
BYO Providers

Contents

  • About The Project

  • MCP Server

  • Installation

  • Usage

  • Contributing

  • License

  • Contact

  • Acknowledgements

About The Project

StackQL is an open-source project built with Golang that allows you to create, modify and query the state of services and resources across different local and remote interfaces, using SQL semantics. Such interfaces canonically include, but are not limited to, cloud and SaaS providers (Google, AWS, Azure, Okta, GitHub, etc.).

How it works

StackQL is a standalone application that can be used in client mode (via exec or shell) or accessed via a Postgres wire protocol client (psycopg2, etc.) using server mode (srv).

StackQL parses SQL statements and transpiles them into API requests to the (cloud) resource provider. The API calls are then executed and the results are returned to the user.

StackQL provider interfaces are canonically defined in OpenAPI extensions to the providers' specification. These definitions are then used to generate the SQL schema and the API client. The source for the provider definitions are stored in the StackQL Registry. The semantics of provider interactions are defined in our any-sdk library. For more detail on nuts and bolts, please see the local AGENTS.md file and that of any-sdk.

StackQL Context Diagram

The following context diagram describes the StackQL architecture at a high level:```mermaid
flowchart LR
subgraph StackQL
direction BT
subgraph ProviderDefs
Registry[Provider Registry Docs]
end
subgraph App
Proc[$ stackql exec\n$ stackql shell\n$ stackql srv]
style Proc fill:#000,stroke:#000,color:#fff,text-align:left;

    %% ,font-family:'Courier New', Courier, monospace
end

end
User((User)) <--> StackQL <--> Provider[Cloud Provider API]
ProviderDefs --> App


More detailed design documentation can be found in the here.

## MCP Server

StackQL is an MCP server - SQL over 40+ cloud and SaaS providers for AI agents.  Point any MCP-capable client (Claude, VS Code, Cursor, etc.) at StackQL and it can query and provision cloud resources using SQL.

Run it over stdio:```sh
stackql mcp --mcp.server.type=stdio

StackQL MCP is published to the Official MCP Registry as io.github.stackql/stackql-mcp and distributed via npm, PyPI, Docker, a GitHub Action and .mcpb bundles. Pick an install vector and add the matching block to your MCP client config:

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


PyPI (uvx)```json
{
  &quot;mcpServers&quot;: {
    &quot;stackql&quot;: {
      &quot;command&quot;: &quot;uvx&quot;,
      &quot;args&quot;: [&quot;stackql-mcp-server&quot;]
    }
  }
}

Docker```json
{
"mcpServers": {
"stackql": {
"command": "docker",
"args": ["run", "-i", "--rm", "stackql/stackql-mcp"]
}
}
}


.mcpb bundle

&gt; Download the bundle for your platform from the latest release and install it in your MCP client (one-click in clients that support `.mcpb`).

- `stackql-mcp-linux-x64.mcpb`
- `stackql-mcp-linux-arm64.mcpb`
- `stackql-mcp-windows-x64.mcpb`
- `stackql-mcp-darwin-universal.mcpb`

GitHub Actions

&gt; Wire StackQL MCP into agentic CI workflows.  Defaults to `read_only` mode, the safe default for CI.```yaml
- uses: stackql/setup-stackql-mcp@v1
  with:
    mode: read_only

For client-specific setup, authentication and server modes, see the full MCP install and usage docs.

Installation

StackQL is available for Windows, MacOS, Linux, Docker, GitHub Actions and more. See the installation instructions below for your platform.

Installing on MacOS

  • Homebrew (amd64 and arm64)
  • brew install stackql or brew tap stackql/tap &amp;&amp; brew install stackql/tap/stackql
  • MacOS PKG Installer (amd64 and arm64)
  • download the latest MacOS PKG installer for StackQL
  • run the installer and follow the prompts

Installing on Windows

  • MSI Installer
  • download the latest MSI installer for StackQL
  • run the installer and follow the prompts
  • Chocolatey
  • install Chocolatey
  • run choco install stackql
  • ZIP Archive
  • download the latest Windows ZIP archive for StackQL
  • extract the archive (code signed stackql.exe file) to a directory of your choice
  • add the directory to your PATH environment variable (optional)

Installing on Linux

  • ZIP Archive
  • download the latest Linux ZIP archive for StackQL
    • or via curl -L https://bit.ly/stackql-zip -O &amp;&amp; unzip stackql-zip
  • extract the archive (stackql file) to a directory of your choice
  • add the directory to your PATH environment variable (optional)

Getting StackQL from DockerHub

> View all available StackQL images on DockerHub. Images available include stackql, stackql-jupyter-demo and more. Pull the latest StackQL base image using:bash docker pull stackql/stackql

> Want findings, not infrastructure? Run a read-only cross-cloud security &
> FinOps audit with the standard image in one command — see the
> Docker audit quickstart.

Using StackQL with GitHub Actions

> Use StackQL in your GitHub Actions workflows to automate cloud infrastructure provisioning, IaC assurance, or compliance/security. Available GitHub Actions include: setup-stackql, stackql-exec and more

Usage

StackQL can be used via the interactive REPL shell, or via the exec command or ran as a server using the Postgres wire protocol.

> ℹ️ StackQL does not require or install a database.

  • Interactive Shellsh # run interactive stackql queries stackql shell --auth=&quot;${AUTH}&quot;
  • Execute a statement or file```sh
    stackql exec --auth="${AUTH}" -i myscript.iql --iqldata vars.jsonnet --output json

# or

stackql exec --auth="${AUTH}" "SELECT id, status FROM aws.ec2.instances WHERE region = 'us-east-1'"
```

> ℹ️ output options of json, csv, table and text are available for the exec command using the --output flag

> ℹ️ StackQL supports passing parameters using jsonnet or json, see Using Variables
* Serversh # serve client requests over the Postgres wire protocol (psycopg2, etc.) # clients are not authenticated unless mTLS is configured via --pgsrv.tls, so keep the listener on loopback otherwise stackql srv --pgsrv.address=127.0.0.1 --auth=&quot;${AUTH}&quot;

For more examples, please check our Blog

Contributing

Contributions are welcome and encouraged. For more information on how to contribute, please see our contributing guide.

License

Distributed under the MIT License. See LICENSE for more information. Licenses for third party software we are using are included in the /docs/licenses directory.

Contact

Get in touch with us via Twitter at @stackql, email us at info@stackql.io or start a conversation using discussions.

Acknowledgements

Forks of the following support our work:

  • vitess
  • kin-openapi
  • gorilla/mux
  • readline
  • psql-wire
  • mcp-postgres
  • the golang MCP SDK
  • ...and more. Please excuse us for any omissions.

We gratefully acknowledge these pieces of work.

常见问题

7 问
答案由本站依据条目字段整理,不引用上游原文
Stackql 怎么安装?

资料没有给出安装命令,请到官方仓库或文档按说明接入;这类条目多数是生态应用,或尚未发布可安装包。

Stackql 怎么在 Claude Desktop、Claude、Cursor 里配置?

它的传输方式未标注,在客户端的 MCP 配置里填好启动命令和参数,保存后完全退出客户端再打开,配置才会生效。

Stackql 收费吗?

本站不代收费用,也没有标注具体价格。是否收费取决于服务本身和背后的接口额度,正式使用前按官方说明确认。

Stackql 需要 API Key 吗?

资料标注需要会话登录认证,使用前准备好对应凭据,并按最小权限配置。

Stackql 支持哪些客户端?

资料标注支持 Claude Desktop、Claude、Cursor、Codex、Zed;其他客户端只要能配置 MCP Server,也能用同样的命令或地址接入。

Stackql 能提供哪些能力?

资料显示能力标签包括 cloud、sql、infrastructure、devops、database。具体工具清单以官方文档为准。

Stackql 需要什么运行环境?

运行时为 Cross-platform。

热门专题

按标签挑服务器
全部专题 →

服务器信息以作者仓库与官方文档为准;分类、传输方式与鉴权方式的中文说明为中文整理,最近核验 未标注。