StackQL MCP Server
OCI · DOCKER.IO/STACKQL/STACKQL-MCP · 8 COMPONENTS
SQL-native query and provisioning engine for cloud infrastructure, served over MCP.
Last scanned (5 hours ago)
Scores higher than 74% of OCI servers
Category Cloud Infrastructure
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
- No malware scan is available for this kind of package: the supply-chain vendors we use do not cover it. This is a permanent gap in our coverage, not a finding about the package.Unverified
- Known CVEs could not be checked: this artifact ships no SBOM or dependency manifest, 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 or dependency manifest, 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 0 days ago).Pass
- Publishes a security disclosure policy (SECURITY.md).Pass
Schema Quality & AI Usability72
- 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 5436 tokens (~286/item across 19 items; 15 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 Management77
- Stability observed for 23 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
- 41% 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 17 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.
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.
- 23 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 73 to 77. That category is still filling its 30-day observation window: 22 days of observed history at the previous scan, 23 at this one. The score rises as the window fills, whether or not the server changes.
- 22 Oct 26 0
- Package version: 0.12.778 → 0.12.824 functional
- 21 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 67 to 70. That category is still filling its 30-day observation window: 20 days of observed history at the previous scan, 21 at this one. The score rises as the window fills, whether or not the server changes.
- 19 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 60 to 63. That category is still filling its 30-day observation window: 18 days of observed history at the previous scan, 19 at this one. The score rises as the window fills, whether or not the server changes.
- 17 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 53 to 57. That category is still filling its 30-day observation window: 16 days of observed history at the previous scan, 17 at this one. The score rises as the window fills, whether or not the server changes.
- 15 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 47 to 50. That category is still filling its 30-day observation window: 14 days of observed history at the previous scan, 15 at this one. The score rises as the window fills, whether or not the server changes.
- 14 Oct 26 +35
- Injection markers: unverified → pass ▲ security
- MCP protocol: unverified → pass ▲ functional
- Tool coverage: unverified → 100 ▲ functional
- Schema quality: unverified → 100 ▲ functional
- Stability: unverified → 0.47 ▲ functional
- Package version: 0.12.732 → 0.12.778 functional
- 13 Oct 26 0
- Package version: 0.12.732 → 0.12.778 functional
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 23 Oct 2026 · Analysed oci/docker.io/stackql/stackql-mcp@0.12.824
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 ~147
Full I/O contract for one method: every input with its param_type (input_required params become exact-match WHERE predicates; input_optional ones may be added) and every output field, which are the columns a SELECT or RETURNING can reference. Call it after list_methods and before the first query against a method; there is no resource-level equivalent because each method returns its own shape. 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.
list_methods ~128
Access methods (HTTP operations) for a resource with their SQL verb and required params. Pick the method whose verb matches the intent and whose required params you can supply, then describe_method it. 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.
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.824. 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
claude mcp add stackql-stackql-mcp -- docker run --rm -i docker.io/stackql/stackql-mcp:0.12.824
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).
Is the StackQL MCP Server server safe to use?
StackQL MCP Server scores 50 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 15 tools: describe_method, list_methods, list_providers, list_registry, list_resources, and 10 more. Their descriptions and schemas cost roughly 1,566 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 23 October 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.