Agent connecting to 2 MCP servers

[surrey81]

Is it possible for single agent to connect to multiple MCP server?

Ex: i am have 2 MCP server (Mysql and Excel).
I need to query MySQL database and store the results in a xls.

[Crossnonsense]

Here is one way to do it

from autogen_ext.tools.mcp import SseServerParams, mcp_server_tools
from autogen_ext.models.openai import OpenAIChatCompletionClient

async def main():
    excel_server_params = SseServerParams(url=excel_mcp_server_url)
    
    excel_tools = await mcp_server_tools(excel_server_params)
    
    mysql_server_params = SseServerParams(url=mysql_mcp_server_url)
    
    mysql_tools = await mcp_server_tools(mysql_server_params)
    
    tools = excel_tools + mysql_tools
    
    agent = AssistantAgent(
        name="tool_user",
        model_client=OpenAIChatCompletionClient(
            model=model_name,
            api_key="-",
            base_url=llm_host,
            model_info={
                "json_output": False,
                "function_calling": True,
                "vision": False,
                "family": "unknown",
                "structured_output": False
            }
        ),
        tools=tools
    )

[ekzhu]

Actually, a better way is to use McpWorkbench, and AssistantAgent already supports multiple workbenches.

[ekzhu]

https://microsoft.github.io/autogen/stable/reference/python/autogen_agentchat.agents.html#autogen_agentchat.agents.AssistantAgent