mcp_get_dependencies
Identify and retrieve all database object dependencies for tables, views, and stored procedures in SQL Server to analyze relationships and impact.
Instructions
Get dependencies for a database object (tables, views, stored procedures, etc.)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| object_name | Yes | Fully qualified object name (schema.name), e.g. "api.Idiomas" |
Implementation Reference
- src/tools/objectSearch.ts:8-33 (handler)The handler function implementing the core logic of mcp_get_dependencies, querying sys.sql_expression_dependencies for object dependencies.export const mcp_get_dependencies = async (args: { object_name: string }): Promise<ToolResult<any[]>> => { const { object_name } = args; console.log('Executing mcp_get_dependencies with:', { object_name }); try { const pool = getPool(); const query = ` SELECT referenced_schema_name, referenced_entity_name, referenced_database_name, referenced_server_name FROM sys.sql_expression_dependencies WHERE referencing_id = OBJECT_ID(@object_name); `; const result = await pool.request() .input('object_name', object_name) .query(query); return { success: true, data: result.recordset }; } catch (error: any) { console.error(`Error in mcp_get_dependencies for object ${object_name}:`, error); return { success: false, error: error.message }; }
- src/tools.ts:173-186 (registration)Tool registration in MCP_MSQL_TOOLS array, defining the tool name, description, and input schema validation.{ name: "mcp_get_dependencies", description: "Get dependencies for a database object (tables, views, stored procedures, etc.)", inputSchema: { type: "object", properties: { object_name: { type: "string", description: "Fully qualified object name (schema.name), e.g. \"api.Idiomas\"" } }, required: ["object_name"] } },
- src/tools.ts:176-185 (schema)Input schema definition for the mcp_get_dependencies tool.inputSchema: { type: "object", properties: { object_name: { type: "string", description: "Fully qualified object name (schema.name), e.g. \"api.Idiomas\"" } }, required: ["object_name"] }