search_stored_procedures_by_content

Locate stored procedures in SQL Server databases by searching for specific text or patterns within their definitions. Supports case sensitivity and schema filtering 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"
}

MSSQL MCP Server

search_stored_procedures_by_content

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from MSSQL MCP Server

Related Tools

MCP directory API