Working with large tables and AI agents

Can you advise me on how to work with large tables when I need to filter and search for data, perform various calculations such as the average transaction price in a specific year, or just search for specific products according to parameters (filtering data stored in columns)? I tried Supabase rag, but I'm running into limits, or rather incorrect searches when the AI agent has to think about it. Can n8n Data tables help, or are there any limitations (e.g. number of rows)?

1 comment