How to execute a sql with MCP?

[Hakstar]

Now, MCP can provide prompts, tools, and resources for LLMs. Most agent frameworks, like Autogen and LangChain, support MCP tools, and prompts can be set in system_message. However, how to use resources effectively has become an important challenge.

For example, when setting up a MySQL server with MCP (which only has one tool: executing SQL), the process involves generating an SQL query, executing it with the tool, and then letting the LLM handle the raw data. But in reality, users only need the raw data itself. I'm not sure if using resources can solve this issue or if there's a better way for users to interact with the LLM.

[ysolanky]

Closing as its a duplicate https://community.agno.com/t/how-to-get-tool-call-result-directly/905/5