MCPQL

Instructions

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"]
  }