Issue with Google BigQuery MCP Server – CrewAI Only Returning First Row of Results

CrewAI Community Support
1

Hi everyone,

I’ve set up a data analysis crew using the Google BigQuery MCP server as described in the official docs:

The issue I’m facing is with the output of the Tool inside CrewAI:

  • The SQL query runs successfully.
  • However, the Tool Output only contains the first row of the queried result, and all other subsequent rows are not displayed.

Here’s what I see in CrewAI:
{“frequency”:2896,“item_category_name”:“ドラッグストア”}

On the other hand, when I use the same MCP server on Cursor AI, I get the full set of results, for example:
{“count”:2896,“item_category_name”:“ドラッグストア”,“percentage”:33.21}
{“count”:2111,“item_category_name”:“ビューティー”,“percentage”:24.21}
{“count”:2061,“item_category_name”:“食品・飲料・お酒”,“percentage”:23.64}
…

So it looks like the query itself and the MCP server setup are fine, but CrewAI only returns the first row from the result set instead of the complete response.

Question

  • Is this a known limitation in CrewAI’s handling of MCP tool outputs?
  • Do I need to adjust formatting or parsing to ensure multiple rows are returned?
  • Has anyone else faced a similar discrepancy between CrewAI and Cursor AI with the same MCP server?

Any guidance would be much appreciated!

Screenshot 2025-09-11 at 1.10.23 PM
Screenshot 2025-09-11 at 1.10.23 PM1920×959 149 KB

Thanks,
Manju!

2

thanks for your question. can you try adding a file_output=”output.json” in your task that handles the extraction so you can save the all the output from the tool?

in the meantime we’ll take a look. thanks for opening the github issue btw.

3

I faced the same issue. It is problem with CrewAI’s MCP tool. I implemented my own tools using fastmcp and gave to crewai and the problem disappeared. It was too much coding though.

1 Like