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.
