search_schema
Wildcard/fuzzy search across tables and columns with pagination.
How to use it
search_schema is exposed by the Mssql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the search_schema tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install Mssql MCP Server
npm install -g @connorbritain/mssql-mcp-server@latestOther tools in Mssql MCP Server (19)
Create indexes on existing tables.
Create tables with column definitions.
Preview affected rows, require confirmation.
Column definitions, types, nullability, keys.
Drop tables (requires confirmation).
Execution plan analysis via SHOWPLAN.
Parameterized inserts (single or batch).
Full dependency analysis (views, procs, functions, triggers referencing an object).
FK mappings in both directions.
List databases on server-level environments.
Show configured environments and their policies.
Show available pre-approved SQL scripts.
List all tables in a database with optional filtering.
Column stats (null %, cardinality, min/max/avg/median/p90) with optional sample rows.
Safe SELECT with automatic row limits.
Execute named scripts with parameters and governance controls.
Verify connectivity and latency.
Preview affected rows, require confirmation.
Check environment configuration for errors.