Hey @Mike_DeKock,
I wrote a slightly related post here Which AI tool for code assist - #2 by MiguelOrtiz
Something that helps me a lot is having the json editor available in the app so that I can make reference to any component and data source and copy paste it to the llm so that it knows what is the data target and goal structure.
With regards to REtool queries, I have made a habit of applying return formatDataAsArray (data) to all of my database queries, it just makes it so much easier for JS and any llm related questoin.
Hopefully the retool team are able to deploy an MCP that we're able to load to claude or openai so that it has tools to understand table's structures, js and transformers, etc.