Can an LLM (like Claude) see the full Records Catalog including joins? It says it can see the custom fields in my instance (through the standard netsuite MCP suiteapp) which is great but doesn't know the relationships to other tables so often struggles with simple joins. If it could see all the joins and has full access to the real schema the SuiteQL would be much closer to perfect on the first shot.

AI generated answer (using internal Slack threads):

Based on the conversations provided, it appears that the LLM (like Claude) can see the custom fields in the instance through the standard NetSuite MCP suiteapp. However, it seems to struggle with understanding the relationships to other tables and often has difficulties with simple joins. The conversations suggest that SuiteQL, a feature of NetSuite, allows for ad-hoc joins, which could potentially help with this issue. SuiteQL is native to NetSuite and not a third-party feature. However, it's not clear if SuiteQL would provide full access to the real schema or if it would allow the LLM to see all the joins. The conversations also mention a

Records Catalog

under

Setup

that might provide some information about the table schema for the

N/query

module, but it's not clear if this would solve the issue with the LLM not being able to see all the joins. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******