search_stored_procedures_by_content

Find stored procedures in Microsoft SQL Server databases by searching for specific text or patterns within their SQL definitions. Specify search parameters like schema, case sensitivity, and optional full definitions for precise results.

Instructions

Search for stored procedures containing specific text or patterns in their SQL definition

Input Schema

Name	Required	Description
`caseSensitive`	No	Case sensitive search (default: false)
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`includeDefinitions`	No	Include full procedure definitions in results (default: false)
`schema`	No	Schema name (default: dbo)
`searchText`	Yes	Text or pattern to search for in procedure definitions

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "caseSensitive": {
      "description": "Case sensitive search (default: false)",
      "type": "boolean"
    },
    "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"
    },
    "includeDefinitions": {
      "description": "Include full procedure definitions in results (default: false)",
      "type": "boolean"
    },
    "schema": {
      "description": "Schema name (default: dbo)",
      "type": "string"
    },
    "searchText": {
      "description": "Text or pattern to search for in procedure definitions",
      "type": "string"
    }
  },
  "required": [
    "searchText"
  ],
  "type": "object"
}

Microsoft SQL Server MCP Server (MSSQL)

search_stored_procedures_by_content

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Microsoft SQL Server MCP Server (MSSQL)

Related Tools

MCP directory API