Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

list_stored_procedures

Discover and analyze stored procedures and functions in Microsoft SQL Server. Retrieve basic details like schema, name, and type, with options to include system objects or specify a connection.

Instructions

List all stored procedures, functions, and their basic information

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

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" }, "includeSystemObjects": { "description": "Include system stored procedures (default: false)", "type": "boolean" }, "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