Skip to main content
Glama
dperussina

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

TableJSON 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)

Latest Blog Posts

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