MCPVault

inspect_dependencies

MCP tool from Mssql MCP Server by ConnorBritain

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

How to use it

inspect_dependencies 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_dependencies 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_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_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.

search_schema

Wildcard/fuzzy search across tables and columns with pagination.

test_connection

Verify connectivity and latency.

update_data

Preview affected rows, require confirmation.

validate_environment_config

Check environment configuration for errors.