​

marvin.memory.providers.postgres

​

Classes

​

PostgresMemory

class PostgresMemory()

• add
  async def add(self, memory_key: str, content: str) -> str
  
  Insert a new record with an embedding vector. Returns the inserted record’s UUID.
• configure
  async def configure(self, memory_key: str)
  
  1. Create an async engine.
  2. Optionally create the DB if it doesn’t exist (requires sync workaround).
  3. Install pgvector extension.
  4. Generate the memory table if missing.
  5. Initialize the async sessionmaker.
• delete
  async def delete(self, memory_key: str, memory_id: str)
  
  Delete a record by UUID.
• search
  async def search(self, memory_key: str, query: str, n: int = 20) -> Dict[str, str]
  
  Async nearest-neighbor search via pgvector <-> operator or .l2_distance(), returning up to N results as {id: text}.

​

SQLMemoryTable

class SQLMemoryTable()