mysql_execute_batch
Execute multiple SQL queries in sequence on one connection, preserving session variables and temporary tables, and receive results for each query.
Instructions
Execute multiple SQL queries sequentially on a single connection. Useful for running several queries at once. All queries share the same connection, so SET variables and temporary tables persist across queries. Returns an array of { query, result } pairs.
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": {
"queries": "<queries>"
},
"name": "mysql_execute_batch"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alias | No | MySQL connection alias (optional, uses default if omitted) | |
| queries | Yes | Array of SQL queries to execute sequentially |