search_schema

MCP tool from Mssql MCP Server by ConnorBritain

Wildcard/fuzzy search across tables and columns with pagination.

How to use it

Project documentation lists search_schema for the Mssql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Mssql MCP Server

$npm install -g @connorbritain/mssql-mcp-server@latest
FULL MSSQL MCP SERVER LISTING

Other tools in Mssql MCP Server (19)

create_index

Create indexes on existing tables.

create_table

Create tables with column definitions.

delete_data

Preview affected rows, require confirmation.

describe_table

Column definitions, types, nullability, keys.

drop_table

Drop tables (requires confirmation).

explain_query

Execution plan analysis via SHOWPLAN.

insert_data

Parameterized inserts (single or batch).

inspect_dependencies

Full dependency analysis (views, procs, functions, triggers referencing an object).

inspect_relationships

FK mappings in both directions.

list_databases

List databases on server-level environments.

list_environments

Show configured environments and their policies.

list_scripts

Show available pre-approved SQL scripts.

list_table

List all tables in a database with optional filtering.

profile_table

Column stats (null %, cardinality, min/max/avg/median/p90) with optional sample rows.

read_data

Safe SELECT with automatic row limits.

run_script

Execute named scripts with parameters and governance controls.

test_connection

Verify connectivity and latency.

update_data

Preview affected rows, require confirmation.

validate_environment_config

Check environment configuration for errors.