[BUG]CrewAI Only Returning First Row of Results from Google Big Query MCP Server

[msmmpts]

Description

Hi everyone,

I’ve set up a data analysis crew using the Google BigQuery MCP server as described in the official docs:
https://cloud.google.com/bigquery/docs/pre-built-tools-with-mcp-toolbox

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!

Thanks,
Manju

Steps to Reproduce

Utilise Google Big Query MCP server as a tool in crew AI set up.

Ask SQL based queries, it picks up only the first row.

Expected behavior

Tool Output must include all the results of the successfully executed query

Screenshots/Code snippets

Operating System

Other (specify in additional context)

Python Version

3.10

crewAI Version

0.186.1

crewAI Tools Version

0.71.0

Virtual Environment

Venv

Evidence

Already shared

Possible Solution

None

Additional context

None