Skip to main content
Glama

get_all_stored_procedure_definitions

Retrieve SQL definitions for all stored procedures in a specified schema. Customize by including system procedures, setting max results, and using named connections or direct connection strings.

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/c0h1b4/mssql-mcp-server'

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