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

Name	Required	Description
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`includeSystemProcedures`	No	Include system stored procedures (default: false)
`maxResults`	No	Maximum number of procedures to return (default: 50, max: 100)
`schema`	No	Schema 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"
    },
    "includeSystemProcedures": {
      "description": "Include system stored procedures (default: false)",
      "type": "boolean"
    },
    "maxResults": {
      "description": "Maximum number of procedures to return (default: 50, max: 100)",
      "type": "number"
    },
    "schema": {
      "description": "Schema name (default: dbo)",
      "type": "string"
    }
  },
  "type": "object"
}

MSSQL MCP Server

get_all_stored_procedure_definitions

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MSSQL MCP Server

Related Tools

MCP directory API