Memory Pgsql Cognee

README

# Memory PGSQL Cognee

`memory-pgsql-cognee` is an OpenClaw memory plugin backed by `PostgreSQL + pgvector`, with `Cognee` as an asynchronous knowledge-distillation layer.

For step-by-step installation, use [INSTALL.md](./INSTALL.md).

## What It Does

- Uses `PostgreSQL/pgvector` as the only live memory store
- Preserves the existing memory flow:
  - `distilled`
  - `session`
  - `full`
- Recalls memories in this order:
  - `distilled -> session -> full`
- Writes all runtime/session memories directly into PostgreSQL
- Queues async refinement jobs for Cognee
- Falls back to local LLM fact extraction if Cognee graph processing fails

## Runtime Dependencies

- PostgreSQL with `pgvector`
- Cognee HTTP API
- Embedding service at `embedding.serviceUrl`
- Ollama-compatible generation endpoint for fallback fact extraction

## Key Config

- `embedding.serviceUrl`
- `embedding.model`
- `enrichment.dbUrl`
- `enrichment.cogneeBaseUrl`
- `enrichment.ollamaBaseUrl`
- `enrichment.refinementModel`
- `enrichment.pollIntervalMs`

## Publish Notes

- This plugin is already decoupled from LanceDB-era helper scripts
- No synchronous bridge scripts are required for recall or write
- External state is limited to PostgreSQL and Cognee

## Repository Layout

- `index.js`: plugin runtime
- `openclaw.plugin.json`: plugin schema
- `sql/init_openclaw_memory_schema.sql`: schema bootstrap
- `tools/import_openclaw_memory.py`: markdown importer
- `tools/sync_md_to_pgsql.sh`: one-command markdown sync
- `tools/install_md_sync_timer.sh`: install `systemd --user` sync timer
- `tools/test_openclaw_memory_db.py`: PostgreSQL smoke test
- `tools/test_openclaw_cognee_stack.py`: Cognee queue/API smoke test
- `INSTALL.md`: install guide
- `docs/`: architecture and publishing notes