Claude MCP - when running a query I hit the 100,000 row cap, is there a way to bypass limit?

You will need to concatenate results. If you use the NS provided MCP tool files it should know to do this. Otherwise, make your own note with Claude

Yes - we can pull millions of rows into CauzzyAI. There's not a limit for SuiteQL, Searches, etc. MCP has major limitations (and Claude on file size) that we've overcome. www.cauzzy.ai

You can also ask Claude to execute multiple SuiteQL queries through MCP instead of fetching everything in a single paged query.

runSuiteQL()

supports up to 5,000 rows per execution. To retrieve more than 100K records, you can use different approaches: • Keyset pagination: Filter using the last returned internal ID (

WHERE id > lastId ORDER BY id

) • ROWNUM pagination: Fetch records in batches using row ranges • Date/ID ranges: Split the dataset into smaller, non-overlapping queries You can explicitly instruct Claude to execute these queries repeatedly and combine the results until all records are retrieved. The 100K limit applies to a single paged result set, not the combined results of multiple independent queries. Just be mindful of any additional MCP tool or client response-size limits.