SkillFoxx

StackQL MCP

An MCP server and CLI that lets an agent query and provision cloud, SaaS and API resources with plain SQL

  • 1,080 ★ on the repository
  • Last commit
  • MIT
MCP serverOfficial

Broad access

Why this level

  • Can create and change real cloud resources
  • Handles provider credentials
All reasons and checks

stackql/stackqlAuthor:StackQL

Install

In your terminal, with SkillFoxx CLI

npx skillfoxx add mcp/stackql

Detects the agents on your machine, shows the access level and pins the version.

Other ways to install

Access and checks

How we review

Broad accessThe tool can change data, run commands or handle secrets.

  • Can create and change real cloud resources
  • Handles provider credentials

This is third-party code. Review the repository files before installing.

What it does

StackQL exposes cloud and SaaS providers as tables you query with SQL: SELECT to inventory resources, INSERT and other operations to create and change them. The MCP server hands this to an agent, so it can build infrastructure reports, find config problems and provision resources through one language. The npm package downloads the signed stackql binary on first run and speaks stdio. Providers come from a separate registry, and cloud auth uses each provider's usual environment variables. Besides MCP, the project ships a CLI and is packaged as a Codex plugin.

Who it is for. For infrastructure engineers and developers who want one way to read and change cloud resources from an agent.

Good fit when

  • You need to inventory resources across several clouds
  • You need to check configuration against rules
  • You want to provision resources with a SQL query from an agent

Not a fit when

  • You have no cloud credentials for the needed providers
  • The task is simpler with the cloud's own CLI

Example request

Use stackql to list all running virtual machines in the project and their public addresses

MCP

Transport
stdio
Authentication
not required

Environment variables

PROVIDER_CREDENTIALS secret
Cloud and SaaS provider credentials via their usual environment variables, depending on the provider

Limitations

The server itself needs no key, but querying providers requires their credentials via environment variables, and some operations change real resources. Providers come from a registry, so coverage depends on it. On first run the npm package downloads the stackql binary.

How to disable. Remove the stackql server from your MCP config or uninstall the @stackql/mcp-server package.

FAQ

Does the server itself need a key?

No, but calling clouds needs their credentials, usually the same environment variables as the native CLIs.

Can it change resources, not just read?

Yes, StackQL supports not only SELECT but also create and change operations.

Discussion

No questions or reviews yet.

MCP servers
Official

The agent starts LocalStack, deploys Terraform, CDK and SAM, reads logs, fixes IAM policies and injects faults to test resilience

MCP serverBroad access29
Official

Keyless Domainstack MCP server: an agent checks registrar, DNS, hosting, certificate, headers and SEO of a domain

MCP serverExtended access294

Self-hosted MCP server for running commands on remote servers over SSH, with tokens and roles

MCP serverBroad access2

A self-hosted gateway that merges several MCP servers into one endpoint with auth and tool selection

MCP serverBroad access2.8K
Official

The official Alibaba Cloud MCP server manages ECS, RDS, OSS and VPC, reads metrics and deploys an app to ECS from an agent.

MCP serverBroad access137

ACK MCP Server

alibabacloud-ack-mcp-server

Official

The official Alibaba Cloud MCP server for ACK clusters: kubectl, Prometheus metrics, SLS logs and diagnostics.

MCP serverBroad access121

README in short

The README describes StackQL as a SQL engine for cloud, SaaS and APIs, for both humans and agents. It shows binary installs across operating systems, Docker usage and MCP setup. Providers come from a separate registry, with GitHub Actions and Jupyter integrations. The MCP server is packaged for npm and PyPI, plus a Codex plugin. MIT licensed.

README badge

Report a problem