Skip to main content

Unanswered questions

2
J
JarrodApprentice
 CData MCP Servers
How do you manage your context window when letting AI query large databases through Cdata MCP server?

I’ve been doing some testing querying NetSuite using the CData MCP Server. It works really well! The biggest issue is that the _get_tables query is almost always called first, and it returns thousands of tables because the NetSuite database is so large. This chews up all of Claude’s context and it has to end the conversation before getting anywhere useful. I have disabled the _get_tables tool and provided the relevent tables in my prompt instead, but this kind of defeats the purpose of the tool. What have others done to get around this? Can you modify the _get_tables tool such that it only returns relevant tables? or is there a way for Claude to retrieve and use this data in a way that uses less context? Keen to hear your experiences.

101
Jerod
P
Peter_BoelkeApprentice
 CData DBAmp
Error when retrieving AuraDefinition

Hi, since a month we are getting this error:08:06:39: Using the Salesforce SOAP API. [SQLSTATE 01000]08:06:39: Create AuraDefinitionInfo_Previous20250630080639716 with new structure. [SQLSTATE 01000]08:06:40: Error System.Web.Services.Protocols.SoapException: EXCEEDED_ID_LIMIT: AuraDefinitionInfo does not support queryMore(), use LIMIT to restrict the results to a single batch [SQLSTATE 01000]at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) [SQLSTATE 01000]at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) [SQLSTATE 01000]at DBAmpAZ.sforce.SforceService.query(String queryString) [SQLSTATE 01000]at afo220A.iA.s() [SQLSTATE 01000]08:06:40: Drop if it exists. [SQLSTATE 01000]08:06:40: Error: Unable to drop the table. [SQLSTATE 01000]08:06:40: System.InvalidOperationException: ExecuteReader: Connection property has not been ini

473
Ethem Q
CData Foundations 2025

Badge winners

Show all badges
Terms and ConditionsCookie settings