call_stored_proc
Execute stored procedures in SQL Server databases to retrieve data, perform operations, or automate database tasks with parameterized inputs.
Instructions
Execute a stored procedure.
Args:
procedure: Procedure name, optionally with schema (e.g., 'dbo.sp_GetUser' or 'sp_GetUser')
params: Input parameter values as dictionary (parameter names without @)
Returns:
Dictionary with:
- procedure: Full procedure name
- result_sets: List of result sets (each is a list of row dictionaries)
- status: 'success' or errorInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| procedure | Yes | ||
| params | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||