Explain Engine Statement
explainEngineStatementPlans a database statement without executing it, using read-only EXPLAIN on Postgres or MySQL, and flags sequential scans on large tables to suggest an index from plan columns.
Instructions
Plans a statement from streamEngineStatements without running it: EXPLAIN (GENERIC_PLAN) in a read-only transaction on Postgres 16 and later, EXPLAIN FORMAT=JSON on the digest's sample text on MySQL. Flags a sequential scan with a filter on a table of 10,000 rows or more and suggests an index built from the plan's columns.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workspaceSlug": "<workspaceSlug>",
"appSlug": "<appSlug>",
"serviceName": "<serviceName>"
},
"name": "explainEngineStatement"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| env | No | ||
| region | No | ||
| appSlug | Yes | ||
| requestBody | No | The JSON request body. | |
| serviceName | Yes | ||
| workspaceSlug | Yes |