RAG agent with postgresql only retrieves 10 results max

Questions
, ,
1

I’ve tried everything: changing the limit, modifying the prompt, and being more specific, but still, the agent only returns a maximum of 10 matches when there are 14 in the database.

Using Tool Agents, I asked about cars between 50 and 70k, and it returns the results, but not all of them, and I don’t know what to do.

image
image640×326 73.9 KB

  • n8n version: 1.79.3
  • Database (postgresql):
  • Running n8n via : n8n cloud
  • Operating system Windows:
2

Hi,

Can you share your actual workflow? thanks

reg,
J.

3

Hi, what are you refering with the actual workflow? The workflow is not the image I attached ?

4

Hi @Escuderia_Rs,

With just the picture, it’s harder for us to help. If you share the code of your workflow, it’ll be much easier to identify what’s preventing you from getting more than 10 results and suggest the right settings to fix it.

5

Sorry for my ignorance I am new in this topic, what do you refer of the “code” of the workflow?

6

Hi, select the items on your GUI . Do a ctrl-c (copy) and then post it in the forum with ctrl-v (paste) inside of a code section

Reg
J.