inspect_relationships

MCP tool from Mssql MCP Server by ConnorBritain

FK mappings in both directions.

How to use it

inspect_relationships is exposed by the Mssql MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the inspect_relationships 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@latest

FULL MSSQL MCP SERVER LISTING

Other 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).

inspect_dependencies

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

List databases on server-level environments.

list_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.

Wildcard/fuzzy search across tables and columns with pagination.

test_connection

Verify connectivity and latency.

Preview affected rows, require confirmation.

validate_environment_config

Check environment configuration for errors.