openclaw-workspace/memory/projects/memory-system.md

Memory System

Architecture

Hybrid system: File-based (human-readable) + SQLite (structured)

Components

File-Based Memory

• Daily Notes: memory/YYYY-MM-DD.md
• Curated Memory: MEMORY.md (index + always-load info)
• Workspace Context: workspace-context.md (temp state)

SQLite Database

• Location: ~/.openclaw/memory.db
• Tables: memory_cells, scenes, memory_fts
• Extraction: Memory Worker agent (3 AM daily)

Cloud Backup

• Service: Supermemory.ai
• Schedule: Daily 2 AM
• Script: scripts/backup-memory.py

Workers

• Memory Worker: Extracts structured data daily at 3 AM
• Job Verifier: Checks all overnight jobs at 9 AM

Status

✅ Complete — Hierarchical restructure finished (Feb 25, 2026)

• Daily notes automation working
• MEMORY.md as curated index
• SQLite database with FTS
• Supermemory backups daily
• Memory worker extracting nightly
• Obsidian integration with Dataview

---

Trigger words: memory, database, sqlite, supermemory, backup, extraction