Skip to main content
Glama

get_all_stored_procedure_definitions

Retrieve complete SQL definitions for all stored procedures in a specified schema to analyze database logic and maintain documentation.

Instructions

Get complete SQL definitions for all stored procedures in a schema

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
includeSystemProceduresNoInclude system stored procedures (default: false)
maxResultsNoMaximum number of procedures to return (default: 50, max: 100)

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