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

# SurrealDB Memory Search

> Search SurrealDB memories with last_n, first_n, and agentic retrieval methods.

```python memory_search_surreal.py theme={null}
"""
SurrealDB Memory Search
"""

from agno.db.surrealdb import SurrealDb
from agno.memory import MemoryManager, UserMemory
from agno.models.openai import OpenAIChat
from rich.pretty import pprint

# ---------------------------------------------------------------------------
# Setup
# ---------------------------------------------------------------------------
SURREALDB_URL = "ws://localhost:8000"
SURREALDB_USER = "root"
SURREALDB_PASSWORD = "root"
SURREALDB_NAMESPACE = "agno"
SURREALDB_DATABASE = "memories"

creds = {"username": SURREALDB_USER, "password": SURREALDB_PASSWORD}
db = SurrealDb(None, SURREALDB_URL, creds, SURREALDB_NAMESPACE, SURREALDB_DATABASE)


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


# ---------------------------------------------------------------------------
# Run Example
# ---------------------------------------------------------------------------
def run_example() -> None:
    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)


if __name__ == "__main__":
    run_example()
```

## Run the Example

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

  <Step title="Install dependencies">
    ```bash theme={null}
    uv pip install -U agno openai surrealdb
    ```
  </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>

  <Step title="Run SurrealDB">
    ```bash theme={null}
    docker run -d --rm --name surrealdb --pull always -p 8000:8000 surrealdb/surrealdb:latest start --user root --pass root
    ```
  </Step>

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

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

Full source: [cookbook/integrations/surrealdb/memory\_search\_surreal.py](https://github.com/agno-agi/agno/blob/main/cookbook/integrations/surrealdb/memory_search_surreal.py)