generate_report
Turn natural language questions into validated SQL, execute them against a database connection, and export the results as XLSX, PDF, CSV, JSON, or HTML.
Instructions
Generate SQL, execute it under full revalidation and export it inline.
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": {
"connection_id": "<connection_id>",
"question": "<question>",
"format": "<format>"
},
"name": "generate_report"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | Yes | File formats a report can be exported to. | |
| max_rows | No | ||
| question | Yes | ||
| connection_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | Yes | File formats a report can be exported to. | |
| period | No | ||
| message | Yes | ||
| outcome | Yes | Terminal outcome of one SQL generation attempt. | |
| payload | No | ||
| is_empty | No | ||
| question | Yes | ||
| row_count | No | ||
| error_code | No | ||
| truncation | No | ||
| generated_at | Yes | ||
| clarification | No | ||
| connection_id | Yes | ||
| applied_filters | No | ||
| contract_version | No | 1.0.0 |