mcp_get_dependencies
Identify dependencies for database objects (tables, views, stored procedures) by entering the fully qualified object name. Helps analyze relationships and impacts in SQL Server environments.
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 core implementation of the mcp_get_dependencies tool handler. It executes a SQL query against sys.sql_expression_dependencies to retrieve dependencies for the given database object.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 (schema)The schema definition for the tool, specifying the input parameters (object_name: string) and description as part of the MCP_MSQL_TOOLS registration array.{ 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/server.ts:64-66 (registration)Registration of the ListTools handler that exposes mcp_get_dependencies (via MCP_MSQL_TOOLS) to MCP clients.server.setRequestHandler(ListToolsRequestSchema, async () => ({ tools: MCP_MSQL_TOOLS }));
- src/mcp-server.ts:2-2 (registration)Re-export of all tool handlers from tools/index.js, enabling dynamic lookup by name in the MCP server CallTool handler.export * from './tools/index.js';
- src/tools/index.ts:36-44 (registration)Barrel export that includes mcp_get_dependencies from objectSearch.ts, making it available for re-export in mcp-server.ts.export { mcp_search_comprehensive, // Comprehensive search mcp_get_dependencies, // Object dependencies // Funciones adicionales para compatibilidad con server.ts mcp_search_objects_by_name, mcp_search_in_definitions, mcp_search_objects_by_type, mcp_get_object_dependencies } from './objectSearch.js';