get_multiple_stored_procedure_definitions

Retrieve SQL definitions for multiple stored procedures simultaneously from Microsoft SQL Server. Specify procedure names, schema, and optional metadata to streamline database exploration.

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"
}

Microsoft SQL Server MCP Server (MSSQL)

get_multiple_stored_procedure_definitions

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Microsoft SQL Server MCP Server (MSSQL)

Related Tools

MCP directory API