OpenClaw Universal Memory

This skill provides a generic memory layer for heterogeneous data:

• canonical entity/chunk schema,
• connector-style ingestion with cursors,
• searchable memory in Postgres.

Use Cases

• Normalize records from multiple systems into one schema.
• Keep incremental sync history (cursor per connector/account).
• Build RAG-ready chunk storage in pgvector.

Prerequisites

• Postgres with vector extension.
• Local package installed: pip install -e ..
• Python dependency for DB I/O:
  • pip install "psycopg[binary]>=3.2"
• DSN provided via environment variable (DATABASE_DSN by default).

Security Boundaries

• Do not pass raw passwords/tokens in command-line arguments.
• Prefer OS secret store or process environment injection for DSN.
• This skill only reads/writes your configured Postgres database; it does not call external APIs directly.
• Use least-privilege DB credentials (SELECT/INSERT/UPDATE/DELETE on um_* tables only).
• Review and trust any custom connector before running it.

Responsible Use Caveat

• Use this only for accounts/data you legitimately control or are authorized to process.
• You are responsible for privacy, retention, and regulatory compliance.
• This project is provided under Apache 2.0 without operational warranty.
• This implementation is mostly AI-generated code with experienced engineer oversight; validate before production use.

Commands

Store DB credentials once (recommended):

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action configure-dsn

Initialize schema:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action init-schema \
  --dsn-env DATABASE_DSN

Ingest JSON/NDJSON:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action ingest-json \
  --dsn-env DATABASE_DSN \
  --source gmail \
  --account [email protected] \
  --entity-type email \
  --input /path/to/records.ndjson

Ingest from built-in connectors:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action ingest-connector \
  --connector google \
  --account [email protected] \
  --dsn-env DATABASE_DSN \
  --limit 300

Validate connector auth/config before ingest:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action validate-connector \
  --connector google \
  --account [email protected] \
  --dsn-env DATABASE_DSN \
  --limit 1

Search:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action search \
  --dsn-env DATABASE_DSN \
  --query "Deryk" \
  --limit 20

Recent ingest history:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action events \
  --dsn-env DATABASE_DSN \
  --limit 20

Doctor check:

python skills/openclaw-universal-memory/scripts/run_memory.py \
  --action doctor