get_multiple_stored_procedure_definitions

Retrieve complete SQL definitions for multiple stored procedures simultaneously, including optional metadata, on MSSQL MCP Server. Specify procedure names and schema for efficient database management.

Instructions

Get complete SQL definitions for multiple stored procedures at once

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)
`includeMetadata`	No	Include metadata like creation date, modification date (default: true)
`procedureNames`	Yes	Array of stored procedure names to get definitions for
`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"
    },
    "includeMetadata": {
      "description": "Include metadata like creation date, modification date (default: true)",
      "type": "boolean"
    },
    "procedureNames": {
      "description": "Array of stored procedure names to get definitions for",
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "schema": {
      "description": "Schema name (default: dbo)",
      "type": "string"
    }
  },
  "required": [
    "procedureNames"
  ],
  "type": "object"
}

MSSQL MCP Server

get_multiple_stored_procedure_definitions

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MSSQL MCP Server

Related Tools

MCP directory API