execute_procedure
Execute a stored procedure in SQL Server by providing procedure name, schema, and parameters. Requires readwrite or admin access.
Instructions
Execute a stored procedure with parameters. Requires readwrite or admin security mode.
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": {
"procedure": "<procedure>"
},
"name": "execute_procedure"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| procedure | Yes | Stored procedure name (without schema prefix) | |
| schema | No | Schema name (default: dbo) | |
| parameters | No | Key-value pairs of parameter names and values (without @ prefix) | |
| database | No | Database name (uses connection default if omitted) | |
| server | No | Target server name (uses default if omitted) |