Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

get_all_stored_procedure_definitions

Retrieve full SQL definitions for all stored procedures within a specified schema in Microsoft SQL Server. Includes options to filter system procedures and limit results.

Instructions

Get complete SQL definitions for all stored procedures in a schema

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
includeSystemProceduresNoInclude system stored procedures (default: false)
maxResultsNoMaximum number of procedures to return (default: 50, max: 100)
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" }, "includeSystemProcedures": { "description": "Include system stored procedures (default: false)", "type": "boolean" }, "maxResults": { "description": "Maximum number of procedures to return (default: 50, max: 100)", "type": "number" }, "schema": { "description": "Schema name (default: dbo)", "type": "string" } }, "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