openclaw plugins install @zhuJian/session-archive
# 或
npm install @zhuJian/session-archive

{
  "plugins": {
    "entries": {
      "session-archive": {
        "enabled": true,
        "config": {
          "dbPath": "/自定义/路径/session.db"
        }
      }
    }
  }
}

CREATE TABLE messages (
  id           INTEGER PRIMARY KEY AUTOINCREMENT,
  session_key  TEXT NOT NULL,
  session_id   TEXT NOT NULL,
  role         TEXT NOT NULL,
  content      TEXT NOT NULL DEFAULT '',
  model        TEXT,
  tokens       INTEGER,
  created_at   INTEGER NOT NULL,
  channel      TEXT,
  account_id   TEXT,
  message_id   TEXT,
  message_type TEXT,
  tool_name    TEXT,
  media_path   TEXT,
  tokens_input INTEGER,
  tokens_output INTEGER,
  cost_usd     REAL
);

CREATE TABLE operations (
  id              INTEGER PRIMARY KEY AUTOINCREMENT,
  session_key     TEXT,
  operation_type  TEXT NOT NULL,
  target          TEXT NOT NULL,
  details         TEXT,
  result          TEXT,
  operator        TEXT,
  created_at      INTEGER NOT NULL
);

SELECT * FROM messages WHERE session_key = 'agent:main:main' ORDER BY created_at DESC LIMIT 20;

SELECT * FROM messages WHERE channel = 'wecom' ORDER BY created_at DESC LIMIT 10;

SELECT * FROM messages WHERE message_type = 'tool' ORDER BY created_at DESC LIMIT 10;

// 在其他插件中调用
const engine = api.getContextEngine('session-archive');
engine.recordOperation({
  operationType: 'exec',
  target: 'ls -la',
  details: { cwd: '/home' },
  result: 'success',
  operator: 'agent:devagent'
});