Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Generic Postgres and pgvector memory layer for connector-agnostic data ingestion, incremental sync, and searchable chunk storage with cursor history.
Generic Postgres and pgvector memory layer for connector-agnostic data ingestion, incremental sync, and searchable chunk storage with cursor history.
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
This skill provides a generic memory layer for heterogeneous data: canonical entity/chunk schema, connector-style ingestion with cursors, searchable memory in Postgres.
Normalize records from multiple systems into one schema. Keep incremental sync history (cursor per connector/account). Build RAG-ready chunk storage in pgvector.
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).
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.
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.
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 marcos@athanasoulis.net \ --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 you@example.com \ --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 you@example.com \ --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 Scheduling reference: docs/SCHEDULING.md (cron examples, 15-minute default, connector toggles)
A connector returns normalized records + next cursor: external_id entity_type title body_text raw_json meta_json next_cursor This keeps ingestion generic and supports arbitrary source systems. Starter connector templates: src/openclaw_memory/connectors/templates.py Step-by-step setup guide (Gmail/Slack/Asana/iMessage): docs/CONNECTOR_SETUP_WALKTHROUGH.md
We welcome connector contributions via PR. See docs/CONNECTOR_CONTRIBUTING.md for required contract, tests, and setup instructions.
Code helpers, APIs, CLIs, browser automation, testing, and developer operations.
Largest current source with strong distribution and engagement signals.