execute_script
Execute multi-statement SQL scripts against databases to run sequential queries and return results in JSON or CSV format.
Instructions
Execute a multi-statement SQL script against a database. All statements are executed in sequence.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection_string | No | Database connection URL or configured connection name (e.g., "oracle" for USQL_ORACLE) | |
| output_format | No | Output format for results (default: json) | |
| script | Yes | Multi-line SQL script with one or more SQL statements separated by semicolons | |
| timeout_ms | No | Optional timeout in milliseconds for this call (overrides defaults). Use null for unlimited. |
Input Schema (JSON Schema)
{
"properties": {
"connection_string": {
"description": "Database connection URL or configured connection name (e.g., \"oracle\" for USQL_ORACLE)",
"type": "string"
},
"output_format": {
"description": "Output format for results (default: json)",
"enum": [
"json",
"csv"
],
"type": "string"
},
"script": {
"description": "Multi-line SQL script with one or more SQL statements separated by semicolons",
"type": "string"
},
"timeout_ms": {
"description": "Optional timeout in milliseconds for this call (overrides defaults). Use null for unlimited.",
"minimum": 1,
"type": [
"number",
"null"
]
}
},
"required": [
"script"
],
"type": "object"
}