StackQL MCP Server
Query and provision cloud and SaaS resources with SQL, exposed to AI agents over MCP
- Pricing
- Open source
- Platforms
- CLI, macOS, Linux
- Runs
- Locally
- Version
- 1.0.888
- Listing updated
- 3 days ago
About StackQL MCP Server
StackQL MCP Server is an open-source MCP server for cloud and infrastructure. It runs locally on your machine and is started by your AI client.
StackQL treats provider APIs as tables. A query such as a GROUP BY over aws.ec2.instances returns live state, and an INSERT into google.compute.disks creates a resource, with no state file to manage and no per-cloud SDK. The MCP server hands AI agents that same SQL interface, so one grammar covers reading inventory, asserting desired state and making changes.
The server is built from the open-source StackQL engine, written in Go, and ships as an mcpb bundle for Linux, macOS and Windows, an OCI image, an npm package and a PyPI package, all over stdio. Providers include AWS, Azure, Google Cloud, Okta and GitHub, with more in a provider registry.
It suits platform and SRE teams, security and FinOps teams who need live inventory or compliance answers, and developers building agents that must query and change cloud resources. Typical jobs are asset inventory, drift detection and compliance attestation. The MCP tool names are not listed in the registry entry.
Install
Run in a terminal
claude mcp add stackql-mcp -- npx -y @stackql/mcp-serverAdd to claude_desktop_config.json
{
"mcpServers": {
"stackql-mcp": {
"command": "npx",
"args": [
"-y",
"@stackql/mcp-server"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"stackql-mcp": {
"command": "npx",
"args": [
"-y",
"@stackql/mcp-server"
]
}
}
}Add to .vscode/mcp.json
{
"servers": {
"stackql-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@stackql/mcp-server"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"stackql-mcp": {
"command": "npx",
"args": [
"-y",
"@stackql/mcp-server"
]
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"stackql-mcp": {
"command": "npx",
"args": [
"-y",
"@stackql/mcp-server"
]
}
}
}What it does
- SQL over cloud APIs
- SELECT, INSERT, UPDATE and DELETE statements map to provider API calls.
- No state file
- Reads live state each time instead of keeping a separate state store.
- Many install routes
- Available as mcpb bundles, an OCI image, npm and PyPI packages.
- Beyond MCP
- The same engine also runs as a CLI, in CI, in Docker and as a PostgreSQL-compatible server for BI tools.
- Provider registry
- Cloud and SaaS providers are described in a registry you can extend with your own.
Good for
- Count running instances by state across a region
- Detect configuration drift between desired and live state
- Produce cloud asset inventory and compliance reports
- Let an agent provision a resource with an INSERT statement
- Query SaaS APIs such as GitHub or Okta as tables
Pricing
Open source
MIT licensed; commercial support by enquiry
Prices change. Check stackql.io before you buy.
StackQL MCP Server FAQ
What license does StackQL use?
MIT, free to use for any purpose; commercial support is available through StackQL Studios.
Which providers can it query?
Examples named include AWS, Azure, Google Cloud, Okta and GitHub; the site links a list of available providers.
Does it need Terraform or a state file?
No. It queries and changes live state through provider APIs without a state file.
How is it installed as an MCP server?
Through an mcpb bundle, a Docker image, `@stackql/mcp-server` on npm or `stackql-mcp-server` on PyPI, all over stdio.
Is StackQL MCP Server free?
Yes. StackQL MCP Server is open source, so you can use and self-host it for free.
How do I add StackQL MCP Server to Claude Code?
Run this command in your terminal: claude mcp add stackql-mcp -- npx -y @stackql/mcp-server
What are the best alternatives to StackQL MCP Server?
The closest alternatives to StackQL MCP Server are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.
Alternatives to StackQL MCP Server

REA
MCP serverCLI and MCP server that lets coding agents reverse engineer apps and binaries
Runs locally- Open source
- 464K GitHub stars
- Developer tools

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

GitHub
MCP serverOfficial MCP server connecting AI assistants to GitHub repos, issues and workflows
Not checked yet- Remote
- Open source
- 34.5K GitHub stars
- Developer tools

Serena MCP: the IDE for your agent
MCP serverMCP toolkit giving coding agents symbol-level code retrieval and editing
Runs locally- Open source
- 31.5K GitHub stars
- Developer tools

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Ouroboros
MCP serverSpec-first layer that pins requirements and verifies results of AI coding agent work
Runs locally- Open source
- 6.4K GitHub stars
- Developer tools