# StackQL MCP Server (oci · docker.io/stackql/stackql-mcp:0.11.669)

SQL-native query and provisioning engine for cloud infrastructure, served over MCP.

- Trust score: 44/100 (low)
- Change this week: +5
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-09-20

## Components

- mcpb · `stackql-mcp-darwin-universal.mcpb`: 6/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-darwin.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-darwin)
- mcpb · `linux-arm64`: 14/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-linux-a.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-linux-a)
- mcpb · `linux-x64`: 14/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-linux-x.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-linux-x)
- mcpb · `win-x64`: 14/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-windows.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-11-669-stackql-mcp-windows)
- npm · `@stackql/mcp-server`: 35/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/stackql-mcp-server.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/stackql-mcp-server)
- oci · `docker.io/stackql/stackql-mcp:0.11.669`: 44/100 (this document), [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-11-669.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-11-669)
- pypi · `stackql-mcp-server`: 22/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/stackql-mcp-server-2.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/stackql-mcp-server-2)

## Channel facts

- Registry: `oci`
- Package: `docker.io/stackql/stackql-mcp:0.11.669`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-09-20.

- **Supply Chain Security**: 0/100
  - Malware scan not yet available for this package.
  - Known CVEs could not be checked: this artifact ships no SBOM, so there is no dependency list to read. Publishing one would let us assess it.
  - Install-script risk not yet assessed.
  - Dependency health could not be checked: this artifact ships no SBOM, so there is no dependency list to read. Publishing one would let us assess it.
- **Provenance & Transparency**: 48/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 12 days ago).
  - Publishes a security disclosure policy (SECURITY.md).
- **Schema Quality & AI Usability**: 72/100
  - 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).
  - AI-judged instruction clarity (good).
  - Context-footprint check failed: tool/resource definitions use about 5236 tokens (~261/item across 20 items; 16 tools + 4 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 40/100
  - Stability observed for 12 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 83/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 39% of tool parameters carry a description.
  - Structured output schemas are declared (100% of tools); any adoption earns full credit.
- **Tool Safety**: 92/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - 2 of 3 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "run_select_query" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default.
  - An AI judge read all 18 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a current MCP spec version (2026-07-28).

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### How do I install the StackQL MCP Server server?

StackQL MCP Server runs locally as a container image, launched with docker run --rm -i docker.io/stackql/stackql-mcp:0.11.669. Ready-made configuration for Claude, Cursor, VS Code, Codex and 3 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add stackql-stackql-mcp -- docker run --rm -i docker.io/stackql/stackql-mcp:0.11.669
```

### Cursor

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

### VS Code

```json
{
  "servers": {
    "stackql-stackql-mcp": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "docker.io/stackql/stackql-mcp:0.11.669"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add stackql-stackql-mcp -- docker run --rm -i docker.io/stackql/stackql-mcp:0.11.669
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "stackql-stackql-mcp": {
      "type": "local",
      "command": [
        "docker",
        "run",
        "--rm",
        "-i",
        "docker.io/stackql/stackql-mcp:0.11.669"
      ],
      "enabled": true
    }
  }
}
```

### Hermes

```yaml
mcp_servers:
  stackql-stackql-mcp:
    command: "docker"
    args: ["run", "--rm", "-i", "docker.io/stackql/stackql-mcp:0.11.669"]
```

### Netclaw

```json
{
  "McpServers": {
    "stackql-stackql-mcp": {
      "Transport": "stdio",
      "Command": "docker",
      "Arguments": [
        "run",
        "--rm",
        "-i",
        "docker.io/stackql/stackql-mcp:0.11.669"
      ]
    }
  }
}
```

### Other

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

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-09-19 (score 44, +1)

No change was recorded against any check on this day. Stability & Change Management went from 33 to 37. That category is still filling its 30-day observation window: 10 days of observed history at the previous scan, 11 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-16 (score 43, +1)

No change was recorded against any check on this day. Stability & Change Management went from 23 to 27. That category is still filling its 30-day observation window: 7 days of observed history at the previous scan, 8 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-09-15 (score 42, +3)

- [functional improvement] Stability: unverified → 0.23

### 2026-09-08 (score 39)

First indexed and scored.

## MCP tools (16)

### `describe_method` (~79 tokens)

Full I/O contract for one method. Requires provider, service, resource, method.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `method` (string)
- `provider` (string)
- `resource` (string)
- `row_limit` (integer)
- `service` (string)

Output parameters:

- `rows` (null|array)

### `describe_resource` (~79 tokens)

Output fields for a resource's primary read method. Requires provider, service, resource.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `method` (string)
- `provider` (string)
- `resource` (string)
- `row_limit` (integer)
- `service` (string)

Output parameters:

- `rows` (null|array)

### `list_methods` (~85 tokens)

Access methods (HTTP operations) for a resource. Call before writing any query. Requires provider, service, resource.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `method` (string)
- `provider` (string)
- `resource` (string)
- `row_limit` (integer)
- `service` (string)

Output parameters:

- `rows` (null|array)

### `list_providers` (~24 tokens)

Available cloud/SaaS providers (top of the hierarchy). No inputs.

Output parameters:

- `rows` (null|array)

### `list_registry` (~75 tokens)

Providers (and their versions) available in the configured registry. Distinct from list_providers, which lists only providers already pulled. Optional provider arg lists versions for that provider.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `provider` (string)
- `version` (string)

Output parameters:

- `rows` (null|array)

### `list_resources` (~73 tokens)

Resources under a provider.service. Requires provider and service.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `method` (string)
- `provider` (string)
- `resource` (string)
- `row_limit` (integer)
- `service` (string)

Output parameters:

- `rows` (null|array)

### `list_services` (~70 tokens)

Services under a provider. Requires provider.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `method` (string)
- `provider` (string)
- `resource` (string)
- `row_limit` (integer)
- `service` (string)

Output parameters:

- `rows` (null|array)

### `pull_provider` (~81 tokens)

Install a single provider from the registry into the local approot cache. Requires provider; version is optional (latest published is pulled when empty). Writes only local cache state; no cloud control/data plane effect.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `provider` (string)
- `version` (string)

### `query_library_get` (~130 tokens)

Retrieve a query library entry by id. Without params: returns the raw template, param declarations and notes (adapt from it when no exact match exists). With params: the server validates values and returns rendered SQL plus which tool to execute it with (run_select_query or run_mutation_query). Read-only, no credentials.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `id` (string, required): query id from search results, eg aws/ec2/regions-enabled
- `params` (object): parameter values; when supplied the server validates and returns rendered SQL

Output parameters:

- `auth` (null|array): env vars the template's providers need resolved
- `cost` (null|object)
- `description` (string)
- `doc_url` (string)
- `errors` (null|array)
- `id` (string)
- `missing_params` (null|array)
- `mutation` (boolean)
- `next_tool` (string): run_select_query, run_mutation_query or run_lifecycle_operation
- `notes` (string)
- `outputs` (null|array)
- `params` (null|array)
- `permissions` (null|array): provider-native permissions or actions required to execute the template (eg iam:ListUsers)
- `related` (null|array): related library entry ids
- `rendered` (boolean)
- `source_tier` (string)
- `source_url` (string): citation: URL or embedded path the document was loaded from
- `sql` (string): rendered SQL, present when rendered and valid
- `stale` (boolean)
- `template` (string): raw template with {{param}} placeholders
- `title` (string)
- `unknown_params` (null|array)
- `valid` (boolean)
- `verb` (string): select, mutation or lifecycle

### `query_library_search` (~149 tokens)

Search the curated StackQL query library by natural-language intent. Returns ranked template ids with required param names. Consult this before composing SQL from scratch; follow up with query_library_get. Read-only, no credentials.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `include_mutations` (boolean)
- `intent` (string, required): natural language description of what the user wants
- `limit` (integer): max hits, default 5, max 20
- `provider` (string): filter by provider, eg aws
- `service` (string): filter by service, eg ec2
- `tags` (null|array): filter by tags

Output parameters:

- `guidance` (string): authoring guidance returned on the miss path
- `hits` (null|array)
- `miss` (boolean): true when no hit cleared the score threshold
- `source_tier` (string): primary, fallback or snapshot
- `source_url` (string): citation: URL or embedded path the catalogue was loaded from
- `stale` (boolean): true when served from cache or snapshot after fetch failure

### `reload_credentials` (~91 tokens)

Re-source provider credentials from the server's configured env file into the process environment, then report per-provider credential resolution status. Call after fixing or rotating credentials (eg a query failed with a credential resolution error), then retry the query. Never returns secret values. Optional provider arg scopes the report.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `provider` (string)

Output parameters:

- `env_file` (string): configured dotenv file path, empty when none configured
- `env_file_sourced` (boolean): true when the env file was found and sourced on this call
- `providers` (null|array)
- `sourced_vars` (null|array): names of environment variables set from the env file (values are never returned)

### `run_lifecycle_operation` (~84 tokens)

Execute a stackql EXEC lifecycle operation. Returns {messages, timestamp}. Gated by server mode.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `row_limit` (integer)
- `source` (string): query library id when the SQL originated from a library entry; attribution only
- `sql` (string, required)

### `run_mutation_query` (~122 tokens)

Execute INSERT/UPDATE/REPLACE/DELETE against the provider. Real side effects. Returns {messages, timestamp}. Gated by server mode. Consult query_library_search for a vetted template before composing SQL from scratch; when the SQL came from a library entry, pass its id as source.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `row_limit` (integer)
- `source` (string): query library id when the SQL originated from a library entry; attribution only
- `sql` (string, required)

### `run_select_query` (~103 tokens)

Execute a SELECT. Returns {rows}. Reads only. Consult query_library_search for a vetted template before composing SQL from scratch; when the SQL came from a library entry, pass its id as source.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `row_limit` (integer)
- `source` (string): query library id when the SQL originated from a library entry; attribution only
- `sql` (string, required)

Output parameters:

- `rows` (null|array)

### `server_info` (~38 tokens)

Get server identity and runtime: stackql version, backing SQL engine, provider registry location, mode, read-only flag. Call once at session start.

Output parameters:

- `build_date` (string)
- `commit` (string)
- `is_read_only` (boolean)
- `mode` (string)
- `platform` (string)
- `provider_registry` (string)
- `sql_backend` (string)
- `transport` (string)
- `version` (string)

### `validate_select_query` (~80 tokens)

Parse and plan a SELECT without executing. Returns {valid, errors}. SELECT only.

Input parameters:

- `format` (string): text content render format: markdown (default) or json
- `row_limit` (integer)
- `source` (string): query library id when the SQL originated from a library entry; attribution only
- `sql` (string, required)

Output parameters:

- `errors` (null|array)
- `valid` (boolean)

## Diagnostics

Captured diagnostic sections: Provenance. The full working is on the page: https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-11-669#diagnostics

## Score history

- 2026-09-20: 44
- 2026-09-19: 44
- 2026-09-18: 43
- 2026-09-17: 43
- 2026-09-16: 43
- 2026-09-15: 42
- 2026-09-14: 39
- 2026-09-13: 39
- 2026-09-12: 39
- 2026-09-11: 39
- 2026-09-10: 39
- 2026-09-09: 39
- 2026-09-08: 39

## Common questions

### What is the StackQL MCP Server server?

StackQL MCP Server is listed in the public MCP registry as io.github.stackql/stackql-mcp. SQL-native query and provisioning engine for cloud infrastructure, served over MCP. This page covers its container image (docker.io/stackql/stackql-mcp:0.11.669).

### Is the StackQL MCP Server server safe to use?

StackQL MCP Server scores 44 out of 100 on VerifyMCP. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.

### What tools does the StackQL MCP Server server expose?

StackQL MCP Server exposes 16 tools: describe_method, describe_resource, list_methods, list_providers, list_registry, and 11 more. Their descriptions and schemas cost roughly 1,363 tokens of context every time the server is loaded.

### Is the StackQL MCP Server server still maintained?

StackQL MCP Server is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.

### What licence is the StackQL MCP Server server under?

StackQL MCP Server declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.

## Links

- Repository: https://github.com/stackql/stackql
- Website: https://stackql.io/
- Changelog RSS feed: https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-11-669.xml
- Changelog JSON feed: https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-11-669.json
- HTML version of this page: https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-11-669