validate_select_query
Parses and plans a SELECT statement without executing it. Returns {valid, errors}. Useful when an agent wants to verify its query compiles and binds against the discovered method before committing to a real API call.
SELECT only. Mutations and lifecycle operations are not accepted.
See also:
[ MCP overview ] [ list_methods ] [ run_select_query ]
Inputs
| Argument | Required | Description |
|---|---|---|
sql | Yes | A SELECT statement. |
Output
| Renderer | Shape |
|---|---|
| KV | valid (bool) and errors (array of strings, empty when valid) |
Gating
Allowed in every server mode. No API calls are made.
Example
Try this prompt with any elicitation-capable MCP client with the StackQL MCP server registered:
Can you validate this query before I run it:
select name, network
from google.compute.subnetworks
where project = 'my-project' and region = 'us-central1';
Here's an example in Claude Desktop: