StackQL MCP Server
OCI · DOCKER.IO/STACKQL/STACKQL-MCP:0.12.718 · 7 COMPONENTS · SCANNED SEP 26
SQL-native query and provisioning engine for cloud infrastructure, served over MCP.
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. How we score → Why this is hard to score →
Supply Chain Security0
- Malware scan not yet available for this package.Unverified
- Known CVEs could not be checked: this artifact ships no SBOM, so there is no dependency list to read.Unverified
- Install-script risk not yet assessed.Unverified
- Dependency health could not be checked: this artifact ships no SBOM, so there is no dependency list to read.Unverified
Provenance & Transparency48
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 4 days ago).Pass
- Publishes a security disclosure policy (SECURITY.md).Pass
Schema Quality & AI Usability73
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (good).Pass
- 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. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management13
- Stability observed for 4 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage83
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 39% of tool parameters carry a description.Partial
- Structured output schemas are declared (100% of tools); any adoption earns full credit.Pass
Tool Safety92
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 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. See how to fix → Partial
- An AI judge read all 18 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a current MCP spec version (2026-07-28).Pass
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.
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.
oci · docker.io/stackql/stackql-mcp:0.12.718
claude mcp add stackql-stackql-mcp -- docker run --rm -i docker.io/stackql/stackql-mcp:0.12.718
{
"mcpServers": {
"stackql-stackql-mcp": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"docker.io/stackql/stackql-mcp:0.12.718"
]
}
}
} {
"servers": {
"stackql-stackql-mcp": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"docker.io/stackql/stackql-mcp:0.12.718"
]
}
}
} codex mcp add stackql-stackql-mcp -- docker run --rm -i docker.io/stackql/stackql-mcp:0.12.718
{
"$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
}
}
} mcp_servers:
stackql-stackql-mcp:
command: "docker"
args: ["run", "--rm", "-i", "docker.io/stackql/stackql-mcp:0.12.718"] {
"McpServers": {
"stackql-stackql-mcp": {
"Transport": "stdio",
"Command": "docker",
"Arguments": [
"run",
"--rm",
"-i",
"docker.io/stackql/stackql-mcp:0.12.718"
]
}
}
} {
"mcpServers": {
"stackql-stackql-mcp": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"docker.io/stackql/stackql-mcp:0.12.718"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 26 Sept 26 +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.
- 25 Sept 26 +1
- Stability: unverified → 0.10 ▲ functional
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 22 Sept 26 39
First indexed and scored.
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 26 Sept 2026 · Analysed oci/docker.io/stackql/stackql-mcp:0.12.718
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | oci |
| Reason | No attestation published |
Background: How many MCP packages publish verified provenance →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
describe_method ~79
Full I/O contract for one method. Requires provider, service, resource, method.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| method | string | – | – |
| provider | string | – | – |
| resource | string | – | – |
| row_limit | integer | – | – |
| service | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
describe_resource ~79
Output fields for a resource's primary read method. Requires provider, service, resource.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| method | string | – | – |
| provider | string | – | – |
| resource | string | – | – |
| row_limit | integer | – | – |
| service | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
list_methods ~104
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.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| method | string | – | – |
| provider | string | – | – |
| resource | string | – | – |
| row_limit | integer | – | – |
| service | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
list_providers ~24
Available cloud/SaaS providers (top of the hierarchy). No inputs.
Input schema present but exposes no named parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
list_registry ~75
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.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| provider | string | – | – |
| version | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
list_resources ~73
Resources under a provider.service. Requires provider and service.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| method | string | – | – |
| provider | string | – | – |
| resource | string | – | – |
| row_limit | integer | – | – |
| service | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
list_services ~70
Services under a provider. Requires provider.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| method | string | – | – |
| provider | string | – | – |
| resource | string | – | – |
| row_limit | integer | – | – |
| service | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
pull_provider ~81
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.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| provider | string | – | – |
| version | string | – | – |
Structured output declared, but exposes no named fields.
No examples provided.
query_library_get ~130
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.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| id | string | yes | query id from search results, eg aws/ec2/regions-enabled |
| params | object | – | parameter values; when supplied the server validates and returns rendered SQL |
| Name | Type | Req | Description |
|---|---|---|---|
| auth | null|array | – | env vars the template's providers need resolved |
| cost | null|object | – | – |
| description | string | – | – |
| doc_url | string | – | – |
| errors | null|array | – | – |
| id | string | yes | – |
| missing_params | null|array | – | – |
| mutation | boolean | yes | – |
| next_tool | string | yes | 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 | yes | – |
| 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 | yes | – |
| verb | string | – | select, mutation or lifecycle |
No examples provided.
query_library_search ~154
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.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| include_mutations | boolean | – | – |
| intent | string | yes | 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 |
| Name | Type | Req | Description |
|---|---|---|---|
| guidance | string | – | authoring guidance returned on the miss path |
| hits | null|array | yes | – |
| miss | boolean | yes | 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 |
No examples provided.
reload_credentials ~167
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.
| Name | Type | Req | Description |
|---|---|---|---|
| format | string | – | text content render format: markdown (default) or json |
| provider | string | – | – |
| Name | Type | Req | Description |
|---|---|---|---|
| env_file | string | – | configured dotenv file path, empty when none configured |
| env_file_sourced | boolean | yes | true when the env file was found and sourced on this call |
| providers | null|array | yes | – |
| sourced_vars | null|array | – | names of environment variables set from the env file (values are never returned) |
No examples provided.
run_lifecycle_operation ~112
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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 | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
run_mutation_query ~122
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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 | yes | – |
Structured output declared, but exposes no named fields.
No examples provided.
run_select_query ~103
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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 | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| rows | null|array | yes | – |
No examples provided.
server_info ~59
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.
Input schema present but exposes no named parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| build_date | string | – | – |
| commit | string | – | – |
| is_read_only | boolean | yes | – |
| mode | string | – | – |
| platform | string | – | – |
| provider_registry | string | – | – |
| sql_backend | string | – | – |
| transport | string | – | – |
| version | string | – | – |
No examples provided.
validate_select_query ~121
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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 | yes | – |
| Name | Type | Req | Description |
|---|---|---|---|
| errors | null|array | – | – |
| valid | boolean | yes | – |
No examples provided.
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.