Describe Stored Procedure
describe_stored_procedureRetrieve detailed information about SQL Server stored procedures, including parameters and definitions, to understand database logic and dependencies.
Instructions
Get detailed information about a specific stored procedure including parameters and definition
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": {
"procedureName": "<procedureName>"
},
"name": "describe_stored_procedure"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| procedureName | Yes | Name of the stored procedure to describe | |
| schema | No | Schema name (default: dbo) | |
| includeDefinition | No | Include the procedure definition/body (default: true) |