how to use mcp contact mysql

[xiangyang749]

[seanzhou1023]

could you give more context ? One way you can do is to utilize ToolboxToolset

[xiangyang749]

could you give more context ? One way you can do is to utilize ToolboxToolset您能提供更多上下文吗？您可以做的一种方法是使用 ToolboxToolset
i want to use json

./adk_agent_samples/mcp_agent/agent.py

from google.adk.agents.llm_agent import LlmAgent
from google.adk.tools.mcp_tool.mcp_toolset import MCPToolset, StdioServerParameters

async def create_agent():
"""Gets tools from MCP Server."""
tools, exit_stack = await MCPToolset.from_server(
connection_params=StdioServerParameters(
command='npx',
args=[
"-y",
"@smithery/cli@latest",
"run",
"@f4ww4z/mcp-mysql-server",
"--key",
"53a2b570-d3cb-47f2-ab86-c9ca0fe407d9",
"--profile",
"lesser-deer-HrPuPR"
],
)
)

agent = LlmAgent(
model='gemini-2.0-flash',
name='database_assistant',
instruction=(
'帮助用户访问和管理MySQL数据库，执行SQL查询，查看表结构等操作'
),
tools=tools,
)
return agent, exit_stack

root_agent = create_agent()