Skip to main content
Glama

list_stored_procedures

Retrieve and list all stored procedures and functions in an MSSQL database, including schema details and optional system objects, using a SQL Server connection string or named connection.

Instructions

List all stored procedures, functions, and their basic information

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
includeSystemObjectsNoInclude system stored procedures (default: false)
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