Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

describe_stored_procedure

Retrieve detailed metadata, parameters, and definitions of a specific stored procedure in Microsoft SQL Server to simplify database analysis and debugging.

Instructions

Get detailed information about a specific stored procedure including parameters and definition

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
includeDefinitionNoInclude the procedure definition/body (default: true)
procedureNameYesName of the stored procedure to describe
schemaNoSchema 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" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/dperussina/mssql-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server