Problems and fixes
When the chat runs out of room, reads only part of a file, or invents a column.
- Claude says the conversation is too long after I paste data. What now?
Stop pasting the data and let Claude query it instead. Load it once into a database connected over MCP; Claude then asks for totals or the rows it needs, and only those come...
- My AI only analysed the first few thousand rows. Why?
Raw rows come back in pages, and an assistant that reads rows instead of asking for totals sees only the first page. Ask for the summary instead (group and aggregate in the...
- My AI invented a column that isn't in my data. How do I stop it?
Make it look before it asks: `describe_table` lists the real columns and their types. And query through a database, which refuses a column that doesn't exist with an error,...
- ChatGPT's data analysis keeps timing out. What can I do?
Move the data out of the chat's sandbox into a database the assistant can query. Loading happens once, in the background, sent in parts; after that each question is a query...