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
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) |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"connectionName": {
"description": "Named connection to use (e.g., 'production', 'staging')",
"type": "string"
},
"connectionString": {
"description": "SQL Server connection string (uses default if not provided)",
"type": "string"
},
"includeDefinition": {
"description": "Include the procedure definition/body (default: true)",
"type": "boolean"
},
"procedureName": {
"description": "Name of the stored procedure to describe",
"type": "string"
},
"schema": {
"description": "Schema name (default: dbo)",
"type": "string"
}
},
"required": [
"procedureName"
],
"type": "object"
}