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

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

- Trust score: 41/100 (low)
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-09-26

## 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-12-718-stackql-mcp-darwin.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-darwin)
- mcpb · `linux-arm64`: 10/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-linux-a.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-linux-a)
- mcpb · `linux-x64`: 10/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-linux-x.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-linux-x)
- mcpb · `win-x64`: 10/100, [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-windows.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/https-github-com-stackql-stackql-releases-download-v0-12-718-stackql-mcp-windows)
- npm · `@stackql/mcp-server`: 40/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.12.718`: 41/100 (this document), [markdown](https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-12-718.md), [page](https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-12-718)
- pypi · `stackql-mcp-server`: 25/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.12.718`
- 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-26.

- **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.
  - 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.
- **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 4 days ago).
  - Publishes a security disclosure policy (SECURITY.md).
- **Schema Quality & AI Usability**: 73/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 5401 tokens (~270/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**: 13/100
  - Stability observed for 4 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.12.718. 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.12.718
```

### Cursor

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

### VS Code

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

### Codex

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

### 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.12.718"
      ],
      "enabled": true
    }
  }
}
```

### Hermes

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

### Netclaw

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

### Other

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

## 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-26 (score 41, +1)

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

### 2026-09-25 (score 40, +1)

- [functional improvement] Stability: unverified → 0.10
- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-09-22 (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` (~104 tokens)

Access methods (HTTP operations) and their required params for a resource. Call when composing SQL from scratch against an unfamiliar resource; not needed when executing a vetted query library template. 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` (~154 tokens)

Search the curated StackQL query library by natural-language intent. Returns ranked template ids. Consult before composing SQL from scratch; follow with query_library_get, which validates params and surfaces any the index omits. 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` (~167 tokens)

Live-reload provider credentials: re-sources the server's configured env file into the process environment, invalidates cached auth contexts, and reports resolution status for every installed provider (optional provider arg filters the report; changed field flags values that differ from before). Never returns secret values. Credentials resolve automatically at query time - never call this at session start or before queries. Call only after a query fails with a credential resolution error (fix the env file first, then reload, then retry) or when the user says credentials have been rotated or changed. If the report shows changed: false after a failure, the file was not updated - ask the user rather than retrying.

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` (~112 tokens)

Execute a stackql EXEC lifecycle operation (eg EXEC aws.ec2.instances.start_instances ...). Real cloud side effects. Discover available operations and required params via list_methods and describe_method. 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` (~59 tokens)

Get server identity and runtime: stackql version, backing SQL engine, provider registry location, mode, read-only flag. Call on demand - eg to diagnose a refused/gated operation or check version-specific behavior. Not needed at session start or before queries.

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` (~121 tokens)

Parse and plan a SELECT without executing; the provider's credentials must still resolve, as for execution. Returns {valid, errors}. Use when iterating on syntax or plan errors, or pre-flighting complex/expensive queries - don't validate routinely; run_select_query surfaces the same errors.

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-12-718#diagnostics

## Score history

- 2026-09-26: 41
- 2026-09-25: 40
- 2026-09-24: 39
- 2026-09-23: 39
- 2026-09-22: 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.12.718).

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

StackQL MCP Server scores 41 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,553 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 26 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-12-718.xml
- Changelog JSON feed: https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-12-718.json
- HTML version of this page: https://verifymcp.io/servers/stackql-stackql-mcp/docker-io-stackql-stackql-mcp-0-12-718