describe_stored_procedure
Retrieve detailed insights about a stored procedure's parameters and definition on MSSQL Server. Use this tool to analyze procedures, including their schema, body, and required inputs, for efficient database management.
Instructions
Get detailed information about a specific stored procedure including parameters and definition
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| includeDefinition | No | Include the procedure definition/body (default: true) | |
| procedureName | Yes | Name of the stored procedure to describe | |
| schema | No | Schema name (default: dbo) |