Execute Stored Procedure
mssql_execute_stored_procedureExecute a stored procedure by name in SQL Server, providing schema and input parameters, to trigger the intended database action or retrieve data.
Instructions
Executes a stored procedure by name. ⚠️ May modify data — use only when an action is intended. Schema and procedure names are validated as safe identifiers. Pass all value parameters via 'parameters'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| parameters | No | Procedure input parameters (key-value pairs) | |
| schemaName | No | Schema name (default: dbo) | dbo |
| procedureName | Yes | Stored procedure name | |
| response_format | No | Output format: 'json' for structured data, 'markdown' for human-readable tables | json |