PGSearchTool not working as exepcted!

Crews
1

So, I have created an agent, and a task using PGSearchTool.
The agent was configured to have no memory:

tool = PGSearchTool(db_uri='postgresql://admin:admin_password@localhost/shopify_data', table_name='product')

researcher = Agent(
    role='Recomendador de productos',
    goal='Tu objetivo es recomendar el mejor producto de la lista de productos',
    backstory='trabajas en una tienda recomendando productos',
    allow_delegation=False,
    memory=False,
    cache=False,
    llm=llm
)

task = Task(
    description="""
         Consulta la base de datos PostgreSQL para recuperar los productos del catálogo.
         Ten en cuenta lo que solicita el cliente: 
         {description} 
         Los resultados deben estar basados únicamente en la información almacenada en la base de datos y no se permite 
         ningún tipo de inferencia adicional. Solo devuelva productos que realmente existan en la base de datos.             
    """,
    expected_output="""
        Una lista con los productos disponibles en el catálogo.
        Añade una explicacion de donde has sacado los resultados
        """,
    agent=researcher,
    tools=[tool],
    output_json=Products
)

I have modify a product, but when asking for products seems to be two different products, the original one and the product modify.

If the agent hasn´t memory, I should expect the agent create all embeddings from the table product, so it should find only the modify record.

On the other hand, I tried to execute reset_memory command, but old products seems to be there…

Any idea about whatś happening?

Thx in advance!!

2

as a workaround, I have to remove de sqlite3 file and restart services…

3

Hi @rolmovel,
What version of CrewAI are you using?
I ask as I know that others have reported issues with CrewAI mem which in part utilises SqlLight, may be related, not sure. I’ll see if I can help when I know your CrewAI version.

4

Hi @Dabnis , it’s version 0.67.1

Thanks!!!

5

I have just found this:
The crewai_tools package, which will include the PGSearchTool upon its release, can be installed using the following command
(Note: The PGSearchTool is not yet available in the current version of the crewai_tools package. This installation command will be updated once the tool is released.)

Sorry that it was not better news!.

I’ll still keep asking as you do appear to be able to install it, yes?

6

Hi, not sure, but as far as I know, this is the component I was talking about… Am I wrong?

Thx