DBSQL MCP output limit

Manas2000
New Contributor

Hi, Databricks Champions 

I am using SQL MCP server. I was able to connect to MCP and run my sql queries. However as my query out goes above 32,768 it gets truncated and I am not able to get the complete output. 

I can only pass warehouse_id in "_meta" parameters while making connection. There is no way for me to configure row_limit. 

poll → state='SUCCEEDED'

Final state: SUCCEEDED

── MANIFEST (excl. schema) ──
{
"format": "PROTOBUF_ARRAY",
"total_chunk_count": 1,
"chunks": [
{
"chunk_index": 0,
"row_offset": 0,
"row_count": 32768,
"byte_count": 1860920
}
],
"total_row_count": 32768,
"total_byte_count": 1860920,
"truncated": true
}

── RESULT keys ──
['chunk_index', 'row_offset', 'row_count', 'data_typed_array']

It's literally giving me a single chunk only (with truncated = True) and there is no way for me to get the further data because chunks are not given to me. 

Has anyone encountered this limitation with the SQL MCP Server? Is there a supported way to:

  1. Increase the result row limit?
  2. Configure pagination/chunking?
  3. Retrieve the rows beyond the 32,768-row cutoff?

Any guidance would be greatly appreciated.

Thanks