> ## Documentation Index
> Fetch the complete documentation index at: https://agno-v2-service-account.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Search User Memories

> Search user memories using different retrieval methods such as last_n, first_n, and agentic retrieval.

```python memory_search.py theme={null}
"""
Search User Memories
====================

This example shows how to search user memories using different retrieval
methods such as last_n, first_n, and agentic retrieval.
"""

from agno.db.postgres import PostgresDb
from agno.memory import MemoryManager, UserMemory
from agno.models.openai import OpenAIChat
from rich.pretty import pprint

# ---------------------------------------------------------------------------
# Setup
# ---------------------------------------------------------------------------
db_url = "postgresql+psycopg://ai:ai@localhost:5532/ai"
memory_db = PostgresDb(db_url=db_url)

# ---------------------------------------------------------------------------
# Create Memory Manager
# ---------------------------------------------------------------------------
memory = MemoryManager(model=OpenAIChat(id="gpt-4o"), db=memory_db)

# ---------------------------------------------------------------------------
# Run Memory Search
# ---------------------------------------------------------------------------
if __name__ == "__main__":
    john_doe_id = "john_doe@example.com"
    memory.add_user_memory(
        memory=UserMemory(memory="The user enjoys hiking in the mountains on weekends"),
        user_id=john_doe_id,
    )
    memory.add_user_memory(
        memory=UserMemory(
            memory="The user enjoys reading science fiction novels before bed"
        ),
        user_id=john_doe_id,
    )
    print("John Doe's memories:")
    pprint(memory.get_user_memories(user_id=john_doe_id))

    memories = memory.search_user_memories(
        user_id=john_doe_id, limit=1, retrieval_method="last_n"
    )
    print("\nJohn Doe's last_n memories:")
    pprint(memories)

    memories = memory.search_user_memories(
        user_id=john_doe_id, limit=1, retrieval_method="first_n"
    )
    print("\nJohn Doe's first_n memories:")
    pprint(memories)

    memories = memory.search_user_memories(
        user_id=john_doe_id,
        query="What does the user like to do on weekends?",
        retrieval_method="agentic",
    )
    print("\nJohn Doe's memories similar to the query (agentic):")
    pprint(memories)
```

## Run the Example

<Steps>
  <Snippet file="create-venv-step.mdx" />

  <Step title="Install dependencies">
    ```bash theme={null}
    uv pip install -U agno openai psycopg-binary sqlalchemy
    ```
  </Step>

  <Step title="Export your OpenAI API key">
    <CodeGroup>
      ```bash Mac/Linux theme={null}
      export OPENAI_API_KEY="your_openai_api_key_here"
      ```

      ```bash Windows theme={null}
      $Env:OPENAI_API_KEY="your_openai_api_key_here"
      ```
    </CodeGroup>
  </Step>

  <Snippet file="run-pgvector-step.mdx" />

  <Step title="Run the example">
    Save the code above as `memory_search.py`, then run:

    ```bash theme={null}
    python memory_search.py
    ```
  </Step>
</Steps>

Full source: [cookbook/11\_memory/memory\_manager/04\_memory\_search.py](https://github.com/agno-agi/agno/blob/main/cookbook/11_memory/memory_manager/04_memory_search.py)