替代小龙虾OpenClaw自带的memory-enhancement-engine记忆引擎使用Claude-Mem升级小龙虾大脑记忆实现原生永久长效记忆
2026/03/20 14:27:45
[md]鏇夸唬灏忛緳铏綩penClaw鑷甫鐨刴emory-enhancement-engine璁板繂寮曟搸浣跨敤Claude-Mem鍗囩骇灏忛緳铏惧ぇ鑴戣蹇嗗疄鐜板師鐢熸案涔呴暱鏁堣蹇嗭細
**馃攳 **Claude-Mem 鏍稿績鏋舵瀯
鍩轰簬DZ鎻掍欢缃戝皬榫欒櫨 claw.dz-x.net 瀵规帴缁忛獙鍒嗕韩锛岀敱 DZ鎻掍欢缃戠粺涓€绠楀姏骞冲彴锛歛pi.dz-x.net(鏀寔浠讳綍绔欓暱鎺ュ叆锛岃В鍐硉oken鐒﹁檻) 鎻愪緵绠楀姏鏀拺锛堝凡鏀寔璇煶鎺ュ彛銆佸浘鐗囪瘑鍒帴鍙ｏ紝宸叉帴鍏ラ樋閲屼簯API鐭俊銆佹鍦ㄦ帴鍏ラ樋閲屼簯璇煶鐢佃瘽API锛夈€
**宸ヤ綔鍘熺悊**
鐢ㄦ埛鎿嶄綔 鈫 鑷姩鎹曡幏 (tool usage) 鈫 AI 鍘嬬缉 (10x token 浼樺寲) 鈫 SQLite 瀛樺偍 鈫 璇箟妫€绱 鈫 娉ㄥ叆浼氳瘽
**鍏抽敭鐗规€**
| **鐗规€** | **瀹炵幇鏂瑰紡** |
| -------------------- | ---------------------------------------------------------- |
| **鎸佷箙鍖栬蹇** | **\~/.claude-mem/**鏈湴瀛樺偍 |
| **鑷姩鎹曡幏** | **璁板綍鎵€鏈 tool usage (file reads/writes/searches)** |
| **AI 鍘嬬缉** | **Claude agent-sdk 璇箟鍘嬬缉 (绾 10x)** |
| **璁板繂娉ㄥ叆** | **鐩稿叧璁板繂鑷姩娉ㄥ叆鏂颁細璇** |
| **涓夊眰妫€绱** | **search 鈫 timeline 鈫 get\_observations** |
**馃搳 **涓庣幇鏈 memory-enhancement-engine 瀵规瘮
| **缁村害** | **Claude-Mem** | **鐜版湁 memory-enhancement-engine** |
| ------------------ | ------------------------------------ | ----------------------------------------------- |
| **鎹曡幏鏂瑰紡** | **鉁 鑷姩 (tool usage hooks)** | **鉂 鎵嬪姩 (闇€璋冪敤鑴氭湰)** |
| **鍘嬬缉鏂瑰紡** | **鉁 AI 璇箟鍘嬬缉 (10x)** | **鈿狅笍 瑙勫垯 + 鎽樿 (闇€浜哄伐瑙﹀彂)** |
| **瀛樺偍鍚庣** | **鉁 SQLite (楂樻€ц兘)** | **鈿狅笍 Markdown 鏂囦欢** |
| **妫€绱㈡柟寮** | **鉁 璇箟鎼滅储 + 鑷劧璇█** | **鈿狅笍 鍏抽敭璇 + 璇箟 (Gemini embedding)** |
| **璁板繂娉ㄥ叆** | **鉁 鑷姩娉ㄥ叆浼氳瘽** | **鉂 闇€鎵嬪姩璋冪敤 memory\_search** |
**馃攳 **闃舵 1锛氭寕杞界偣 (Hooks) 鍙鎬у垎鏋
**鉁 **宸茬‘璁ょ殑 OpenClaw 鍘熺敓 Hooks
| **Hook 绫诲瀷** | **浜嬩欢鍚嶇О** | **瑙﹀彂鏃舵満** | **鐢ㄩ€** |
| ------------------------ | ---------------------------- | -------------------- | ------------------------- |
| **Plugin Hooks** | **before\_tool\_call** | **宸ュ叿璋冪敤鍓** | **鎷︽埅宸ュ叿鍙傛暟** |
| **Plugin Hooks** | **after\_tool\_call** | **宸ュ叿璋冪敤鍚** | **鎹曡幏宸ュ叿缁撴灉 鉁** |
| **Plugin Hooks** | **message\_received** | **鏀跺埌娑堟伅鏃** | **鎹曡幏鐢ㄦ埛杈撳叆** |
| **Plugin Hooks** | **message\_sending** | **鍙戦€佹秷鎭墠** | **鎹曡幏 AI 鍥炲** |
| **Internal Hooks** | **command:new** | **鏂颁細璇濆垱寤** | **鍒濆鍖栦笂涓嬫枃** |
**鉁 **鏈€浣虫寕杞界偣缁勫悎
鐢ㄦ埛娑堟伅 鈫 message\_received 鈫 鎹曡幏杈撳叆
鈫
AI 鎬濊€ 鈫 before\_tool\_call 鈫 鎷︽埅宸ュ叿璋冪敤
鈫
宸ュ叿鎵ц 鈫 after\_tool\_call 鈫 鎹曡幏缁撴灉 鉁 (鏍稿績璁板繂婧)
鈫
AI 鍥炲 鈫 message\_sending 鈫 鎹曡幏杈撳嚭
鈫
浼氳瘽缁撴潫 鈫 command:stop 鈫 瑙﹀彂 AI 鍘嬬缉 鉁
鈫
涓嬫鍚姩 鈫 gateway:startup 鈫 娉ㄥ叆鐩稿叧璁板繂 鉁
**馃梽锔 **闃舵 2锛歋QLite Schema 璁捐
**鏍稿績琛ㄧ粨鏋**
*-- 璁板繂涓昏〃 *
CREATE TABLE memories (
id INTEGER PRIMARY KEY AUTOINCREMENT,
session\_key TEXT NOT NULL, *-- 浼氳瘽 ID *
event\_type TEXT NOT NULL, *-- 'tool\_call' | 'message' | 'session\_end' *
timestamp\_ms INTEGER NOT NULL, *-- 鏃堕棿鎴 (姣) *
*-- 鍘熷鏁版嵁 *
raw\_content TEXT NOT NULL, *-- 鍘熷鍐呭 (JSON) *
tool\_name TEXT, *-- 宸ュ叿鍚嶇О (濡 'exec', 'read') *
tool\_params TEXT, *-- 宸ュ叿鍙傛暟 (JSON) *
tool\_result TEXT, *-- 宸ュ叿缁撴灉 (JSON) *
*-- AI 鍘嬬缉 *
compressed\_summary TEXT, *-- AI 鐢熸垚鐨勮涔夋憳瑕 *
embedding\_vector BLOB, *-- Gemini embedding (1024 缁) *
token\_count\_before INTEGER, *-- 鍘嬬缉鍓 token 鏁 *
token\_count\_after INTEGER, *-- 鍘嬬缉鍚 token 鏁 *
*-- 妫€绱紭鍖 *
tags TEXT, *-- 鑷姩鏍囩 (JSON 鏁扮粍) *
importance\_score REAL DEFAULT 0.5, *-- 閲嶈鎬ц瘎鍒 (0-1) *
access\_count INTEGER DEFAULT 0, *-- 璁块棶娆℃暟 (鐑害) *
last\_accessed\_ms INTEGER, *-- 鏈€鍚庤闂椂闂 *
created\_at INTEGER DEFAULT (strftime('%s', 'now') \* 1000),
updated\_at INTEGER DEFAULT (strftime('%s', 'now') \* 1000)
);
*-- 绱㈠紩浼樺寲 *
CREATE INDEX idx\_memories\_session ON memories(session\_key);
CREATE INDEX idx\_memories\_event\_type ON memories(event\_type);
CREATE INDEX idx\_memories\_timestamp ON memories(timestamp\_ms DESC);
CREATE INDEX idx\_memories\_importance ON memories(importance\_score DESC);
CREATE INDEX idx\_memories\_tags ON memories(tags);
*-- 浼氳瘽涓婁笅鏂囪〃 (鐢ㄤ簬蹇€熸敞鍏) *
CREATE TABLE session\_contexts (
session\_key TEXT PRIMARY KEY,
project\_name TEXT, *-- 椤圭洰鍚嶇О (濡 'dz-x.net') *
last\_summary TEXT, *-- 涓婃浼氳瘽鎽樿 *
key\_decisions TEXT, *-- 鍏抽敭鍐崇瓥 (JSON 鏁扮粍) *
pending\_tasks TEXT, *-- 寰呭姙浠诲姟 (JSON 鏁扮粍) *
created\_at INTEGER,
updated\_at INTEGER
);
**馃 **闃舵 3锛欰I 鍘嬬缉瑙﹀彂鏃舵満
**涓夊眰鍘嬬缉绛栫暐**
| **灞傜骇** | **瑙﹀彂鏃舵満** | **鍘嬬缉鏂瑰紡** | **Token 浼樺寲** |
| ---------------------- | --------------------------- | -------------------------------- | -------------------- |
| **L1: 瀹炴椂鎹曡幏** | **after\_tool\_call** | **瑙勫垯杩囨护 (鍘婚噸/鐧藉櫔闊)** | **20-30%** |
| **L2: 浼氳瘽缁撴潫** | **command:stop** | **AI 璇箟鎽樿 (Gemini)** | **60-70%** |
| **L3: 瀹氭湡褰掓。** | **姣忔棩鍑屾櫒 (cron)** | **璺ㄤ細璇濆悎骞 + 涓婚鑱氱被** | **80-90%** |
**L2 鍘嬬缉娴佺▼ (浼氳瘽缁撴潫鏃)**
浼氳瘽缁撴潫 (command:stop)
鈫
1. 鏀堕泦鏈浼氳瘽鎵€鏈 memories (raw\_content)
鈫
2. 璋冪敤 Gemini API 鐢熸垚鎽樿
Prompt: "灏嗕互涓嬫搷浣滆褰曞帇缂╀负 3-5 鏉″叧閿喅绛栵紝姣忔潯涓嶈秴杩 50 瀛"
鈫
3. 瀛樺偍 compressed\_summary + embedding\_vector
鈫
4. 鏇存柊 session\_contexts (last\_summary, key\_decisions)
鈫
5. 鍒犻櫎鍘熷 raw\_content (浠呬繚鐣欏帇缂╁悗鍐呭)
**馃拤 **闃舵 4锛氫笂涓嬫枃鑷姩娉ㄥ叆绛栫暐
**娉ㄥ叆瑙﹀彂鏉′欢**
| **鍦烘櫙** | **瑙﹀彂鏉′欢** | **娉ㄥ叆鍐呭** |
| -------------------- | ---------------------------- | ----------------------------------------------- |
| **鏂颁細璇濆垱寤** | **command:new** | **鏈€杩 3 娆′細璇濇憳瑕 + 寰呭姙浠诲姟** |
| **缃戝叧鍚姩** | **gateway:startup** | **鍏ㄥ眬椤圭洰鐘舵€ (鎵€鏈 session\_contexts)** |
| **鐢ㄦ埛鎻愰棶** | **message\_received** | **璇箟妫€绱 Top 5 鐩稿叧璁板繂** |
| **宸ュ叿璋冪敤鍓** | **before\_tool\_call** | **鐩稿叧宸ュ叿鐨勫巻鍙蹭娇鐢ㄨ褰** |
**璇箟妫€绱㈡祦绋**
鐢ㄦ埛娑堟伅锛"Discuz X5 鐨 PHP7.4 琛ヤ竵杩涘害濡備綍锛"
鈫
1. 璋冪敤 Gemini embedding-001 鐢熸垚鏌ヨ鍚戦噺
鈫
2. SQLite 鍚戦噺鐩镐技搴︽悳绱 (浣欏鸡鐩镐技搴)
SELECT \* FROM memories
WHERE cosine\_similarity(embedding\_vector, ?) > 0.75
ORDER BY similarity DESC LIMIT 5
鈫
3. 娉ㄥ叆鍒 AI 涓婁笅鏂
System: "浠ヤ笅鏄浉鍏冲巻鍙茶蹇嗭細[5 鏉″帇缂╂憳瑕乚"
鈫
4. AI 鐢熸垚鍥炵瓟 (鍩轰簬娉ㄥ叆鐨勮蹇)
**馃敡 **闃舵 5锛歄penClaw 鍘熺敓瀹炵幇璺緞
**鏂规 A锛**Hook 涓棿浠**锛堟帹鑽愶級**
浣嶇疆**: **\~/.openclaw/hooks/openclaw-mem/openclaw-mem/
鈹溾攢鈹€ HOOK.md # 鍏冩暟鎹 + 鏂囨。
鈹溾攢鈹€ handler.ts # 涓诲鐞嗗櫒
鈹溾攢鈹€ memory-service.ts # 璁板繂鏈嶅姟 (SQLite + AI 鍘嬬缉)
鈹溾攢鈹€ schema.sql # SQLite Schema
鈹斺攢鈹€ package.json # 渚濊禆 (better-sqlite3, @google/generative-ai)
浼樺娍**:**
0 **鉁 OpenClaw 鍘熺敓鏀寔锛屾棤闇€淇敼鏍稿績浠ｇ爜**
0 **鉁 鑷姩鍙戠幇锛**openclaw hooks enable openclaw-mem** 鍗冲彲鍚敤**
0 **鉁 涓庣幇鏈 **session-memory** hook 鍏煎**
**鏂规 B锛**Plugin 鎻掍欢
浣嶇疆**: **\~/.openclaw/plugins/openclaw-mem/openclaw-mem/
鈹溾攢鈹€ plugin.json
鈹溾攢鈹€ index.ts # 鎻掍欢鍏ュ彛
鈹溾攢鈹€ hooks/
鈹 鈹溾攢鈹€ after\_tool\_call.ts
鈹 鈹溾攢鈹€ command\_stop.ts
鈹 鈹斺攢鈹€ gateway\_startup.ts
鈹斺攢鈹€ services/
鈹溾攢鈹€ sqlite-service.ts
鈹斺攢鈹€ compression-service.ts
浼樺娍**:**
0 **鉁 鏇村己澶х殑鎵╁睍鑳藉姏**
0 **鉁 鍙敞鍐岃嚜瀹氫箟鍛戒护 (濡 **/mem search**)**
**鈿栵笍 **澶у湥鐨勫喅绛栧缓璁
**鎺ㄨ崘锛**[**A] Hook 涓棿浠舵柟妗**
鐞嗙敱**:**
1. **鉁 OpenClaw 瀹樻柟鎺ㄨ崘鏂瑰紡 (鏂囨。鏄庣‘鏀寔)**
2. **鉁 杞婚噺绾э紝浠呮嫤鎴叧閿簨浠**
3. **鉁 涓庣幇鏈 hooks 鏃犵紳闆嗘垚**
4. **鉁 寮€鍙戞垚鏈綆 (棰勮 4-6 灏忔椂)**
瀹炴柦姝ラ**:**
1. **鍒涘缓 **\~/.openclaw/hooks/openclaw-mem/
2. **瀹炵幇 **handler.ts** (鐩戝惉 5 涓叧閿簨浠)**
3. **鍒濆鍖 SQLite 鏁版嵁搴**
4. **闆嗘垚 Gemini embedding-001**
5. **娴嬭瘯鑷姩鎹曡幏 + 鍘嬬缉 + 娉ㄥ叆**
**馃搵 **涓庣幇鏈 memory-enhancement-engine 鍗忓悓
| **鍔熻兘** | **鐜版湁寮曟搸** | **openclaw-mem** | **鍗忓悓鏂瑰紡** |
| ------------------ | ------------------------------ | ------------------------------ | -------------------- |
| **璁板繂瀛樺偍** | **Markdown 鏂囦欢** | **SQLite** | **杩佺Щ鎴栧苟瀛** |
| **宓屽叆妯″瀷** | **Gemini embedding-001** | **Gemini embedding-001** | **鉁 澶嶇敤** |
| **妫€绱㈡柟寮** | **鎵嬪姩璋冪敤鑴氭湰** | **鑷姩娉ㄥ叆** | **浜掕ˉ** |
| **鍘嬬缉鏂瑰紡** | **瑙勫垯 + 鎽樿** | **AI 璇箟鍘嬬缉** | **鍗囩骇** |
杩佺Щ绛栫暐**:**
**淇濈暀鐜版湁 69 涓蹇嗘枃浠朵綔涓哄巻鍙插綊妗**
**openclaw-mem 浠庡惎鐢ㄤ箣鏃ヨ捣鑷姩鎹曡幏鏂拌蹇**
**鎻愪緵杩佺Щ宸ュ叿 (鍙€): **python3 migrate-to-sqlite.py
**鉁 鍏抽敭鎴愭灉**
| **鍔熻兘** | **鐘舵€** | **璇佹槑** |
| ------------------ | ----------------- | ------------------------------------ |
| **AI 鍘嬬缉** | **鉁 宸ヤ綔** | **DeepSeek API 鐢熸垚 3 鏉℃憳瑕** |
| **鍚戦噺宓屽叆** | **鉁 宸ヤ綔** | **Gemini embedding-001** |
| **璇箟妫€绱** | **鉁 宸ヤ綔** | **浣欏鸡鐩镐技搴 0.679** |
| **鏁版嵁搴** | **鉁 宸ヤ綔** | **13 鏉¤褰曪紝1 鏉 AI 鎽樿** |
**馃幆 **棰勬湡鏁堟灉
**鐢熶骇鐜琛屼负**
1. **鑷姩鎹曡幏**: 姣忔宸ュ叿璋冪敤銆佺敤鎴锋秷鎭嚜鍔ㄥ瓨鍌
2. **浼氳瘽缁撴潫**: 鑷姩鐢熸垚 AI 鎽樿锛圖eepSeek API锛
3. **璇箟妫€绱**: 鐢ㄦ埛鎻愰棶鏃惰嚜鍔ㄦ绱㈢浉鍏宠蹇嗭紙鐩镐技搴 >0.5锛
4. **涓婁笅鏂囨敞鍏**: Top 3-5 鐩稿叧璁板繂娉ㄥ叆鍒 AI 涓婁笅鏂
**Token 浼樺寲**
| **鍦烘櫙** | **浼樺寲鍓** | **浼樺寲鍚** | **浼樺寲鐜** |
| -------------------- | ----------------------- | ---------------------- | ---------------------- |
| **闀夸細璇濆巻鍙** | **10,000 tokens** | **1,000 tokens** | **90%**猬囷笍 |
| **璺ㄤ細璇濇绱** | **鍏ㄩ噺鍔犺浇** | **Top 5 璁板繂** | **80%**猬囷笍 |
| **浼氳瘽鎽樿** | **浜哄伐鎬荤粨** | **AI 鑷姩鐢熸垚** | **100%**猬嗭笍鏁堢巼 |
**鈿狅笍 **娉ㄦ剰浜嬮」
1. **棣栨鍚敤**: 鏁版嵁搴撹嚜鍔ㄥ垱寤猴紙**\~/.openclaw/openclaw-mem.db**锛
2. **API 鎴愭湰**: DeepSeek锛堟憳瑕侊級+ Gemini锛圗mbedding锛夋寜閲忚璐
3. **闅愮鎺у埗**: 鏁忔劅鎿嶄綔涓嶄細瀛樺偍锛圔ash 鍛戒护缁撴灉宸茶繃婊わ級
4. **鎬ц兘褰卞搷**: <10ms/娆★紙SQLite + 鏈湴缂撳瓨锛
[/md]
**馃攳 **Claude-Mem 鏍稿績鏋舵瀯
鍩轰簬DZ鎻掍欢缃戝皬榫欒櫨 claw.dz-x.net 瀵规帴缁忛獙鍒嗕韩锛岀敱 DZ鎻掍欢缃戠粺涓€绠楀姏骞冲彴锛歛pi.dz-x.net(鏀寔浠讳綍绔欓暱鎺ュ叆锛岃В鍐硉oken鐒﹁檻) 鎻愪緵绠楀姏鏀拺锛堝凡鏀寔璇煶鎺ュ彛銆佸浘鐗囪瘑鍒帴鍙ｏ紝宸叉帴鍏ラ樋閲屼簯API鐭俊銆佹鍦ㄦ帴鍏ラ樋閲屼簯璇煶鐢佃瘽API锛夈€
**宸ヤ綔鍘熺悊**
鐢ㄦ埛鎿嶄綔 鈫 鑷姩鎹曡幏 (tool usage) 鈫 AI 鍘嬬缉 (10x token 浼樺寲) 鈫 SQLite 瀛樺偍 鈫 璇箟妫€绱 鈫 娉ㄥ叆浼氳瘽
**鍏抽敭鐗规€**
| **鐗规€** | **瀹炵幇鏂瑰紡** |
| -------------------- | ---------------------------------------------------------- |
| **鎸佷箙鍖栬蹇** | **\~/.claude-mem/**鏈湴瀛樺偍 |
| **鑷姩鎹曡幏** | **璁板綍鎵€鏈 tool usage (file reads/writes/searches)** |
| **AI 鍘嬬缉** | **Claude agent-sdk 璇箟鍘嬬缉 (绾 10x)** |
| **璁板繂娉ㄥ叆** | **鐩稿叧璁板繂鑷姩娉ㄥ叆鏂颁細璇** |
| **涓夊眰妫€绱** | **search 鈫 timeline 鈫 get\_observations** |
**馃搳 **涓庣幇鏈 memory-enhancement-engine 瀵规瘮
| **缁村害** | **Claude-Mem** | **鐜版湁 memory-enhancement-engine** |
| ------------------ | ------------------------------------ | ----------------------------------------------- |
| **鎹曡幏鏂瑰紡** | **鉁 鑷姩 (tool usage hooks)** | **鉂 鎵嬪姩 (闇€璋冪敤鑴氭湰)** |
| **鍘嬬缉鏂瑰紡** | **鉁 AI 璇箟鍘嬬缉 (10x)** | **鈿狅笍 瑙勫垯 + 鎽樿 (闇€浜哄伐瑙﹀彂)** |
| **瀛樺偍鍚庣** | **鉁 SQLite (楂樻€ц兘)** | **鈿狅笍 Markdown 鏂囦欢** |
| **妫€绱㈡柟寮** | **鉁 璇箟鎼滅储 + 鑷劧璇█** | **鈿狅笍 鍏抽敭璇 + 璇箟 (Gemini embedding)** |
| **璁板繂娉ㄥ叆** | **鉁 鑷姩娉ㄥ叆浼氳瘽** | **鉂 闇€鎵嬪姩璋冪敤 memory\_search** |
**馃攳 **闃舵 1锛氭寕杞界偣 (Hooks) 鍙鎬у垎鏋
**鉁 **宸茬‘璁ょ殑 OpenClaw 鍘熺敓 Hooks
| **Hook 绫诲瀷** | **浜嬩欢鍚嶇О** | **瑙﹀彂鏃舵満** | **鐢ㄩ€** |
| ------------------------ | ---------------------------- | -------------------- | ------------------------- |
| **Plugin Hooks** | **before\_tool\_call** | **宸ュ叿璋冪敤鍓** | **鎷︽埅宸ュ叿鍙傛暟** |
| **Plugin Hooks** | **after\_tool\_call** | **宸ュ叿璋冪敤鍚** | **鎹曡幏宸ュ叿缁撴灉 鉁** |
| **Plugin Hooks** | **message\_received** | **鏀跺埌娑堟伅鏃** | **鎹曡幏鐢ㄦ埛杈撳叆** |
| **Plugin Hooks** | **message\_sending** | **鍙戦€佹秷鎭墠** | **鎹曡幏 AI 鍥炲** |
| **Internal Hooks** | **command:new** | **鏂颁細璇濆垱寤** | **鍒濆鍖栦笂涓嬫枃** |
**鉁 **鏈€浣虫寕杞界偣缁勫悎
鐢ㄦ埛娑堟伅 鈫 message\_received 鈫 鎹曡幏杈撳叆
鈫
AI 鎬濊€ 鈫 before\_tool\_call 鈫 鎷︽埅宸ュ叿璋冪敤
鈫
宸ュ叿鎵ц 鈫 after\_tool\_call 鈫 鎹曡幏缁撴灉 鉁 (鏍稿績璁板繂婧)
鈫
AI 鍥炲 鈫 message\_sending 鈫 鎹曡幏杈撳嚭
鈫
浼氳瘽缁撴潫 鈫 command:stop 鈫 瑙﹀彂 AI 鍘嬬缉 鉁
鈫
涓嬫鍚姩 鈫 gateway:startup 鈫 娉ㄥ叆鐩稿叧璁板繂 鉁
**馃梽锔 **闃舵 2锛歋QLite Schema 璁捐
**鏍稿績琛ㄧ粨鏋**
*-- 璁板繂涓昏〃 *
CREATE TABLE memories (
id INTEGER PRIMARY KEY AUTOINCREMENT,
session\_key TEXT NOT NULL, *-- 浼氳瘽 ID *
event\_type TEXT NOT NULL, *-- 'tool\_call' | 'message' | 'session\_end' *
timestamp\_ms INTEGER NOT NULL, *-- 鏃堕棿鎴 (姣) *
*-- 鍘熷鏁版嵁 *
raw\_content TEXT NOT NULL, *-- 鍘熷鍐呭 (JSON) *
tool\_name TEXT, *-- 宸ュ叿鍚嶇О (濡 'exec', 'read') *
tool\_params TEXT, *-- 宸ュ叿鍙傛暟 (JSON) *
tool\_result TEXT, *-- 宸ュ叿缁撴灉 (JSON) *
*-- AI 鍘嬬缉 *
compressed\_summary TEXT, *-- AI 鐢熸垚鐨勮涔夋憳瑕 *
embedding\_vector BLOB, *-- Gemini embedding (1024 缁) *
token\_count\_before INTEGER, *-- 鍘嬬缉鍓 token 鏁 *
token\_count\_after INTEGER, *-- 鍘嬬缉鍚 token 鏁 *
*-- 妫€绱紭鍖 *
tags TEXT, *-- 鑷姩鏍囩 (JSON 鏁扮粍) *
importance\_score REAL DEFAULT 0.5, *-- 閲嶈鎬ц瘎鍒 (0-1) *
access\_count INTEGER DEFAULT 0, *-- 璁块棶娆℃暟 (鐑害) *
last\_accessed\_ms INTEGER, *-- 鏈€鍚庤闂椂闂 *
created\_at INTEGER DEFAULT (strftime('%s', 'now') \* 1000),
updated\_at INTEGER DEFAULT (strftime('%s', 'now') \* 1000)
);
*-- 绱㈠紩浼樺寲 *
CREATE INDEX idx\_memories\_session ON memories(session\_key);
CREATE INDEX idx\_memories\_event\_type ON memories(event\_type);
CREATE INDEX idx\_memories\_timestamp ON memories(timestamp\_ms DESC);
CREATE INDEX idx\_memories\_importance ON memories(importance\_score DESC);
CREATE INDEX idx\_memories\_tags ON memories(tags);
*-- 浼氳瘽涓婁笅鏂囪〃 (鐢ㄤ簬蹇€熸敞鍏) *
CREATE TABLE session\_contexts (
session\_key TEXT PRIMARY KEY,
project\_name TEXT, *-- 椤圭洰鍚嶇О (濡 'dz-x.net') *
last\_summary TEXT, *-- 涓婃浼氳瘽鎽樿 *
key\_decisions TEXT, *-- 鍏抽敭鍐崇瓥 (JSON 鏁扮粍) *
pending\_tasks TEXT, *-- 寰呭姙浠诲姟 (JSON 鏁扮粍) *
created\_at INTEGER,
updated\_at INTEGER
);
**馃 **闃舵 3锛欰I 鍘嬬缉瑙﹀彂鏃舵満
**涓夊眰鍘嬬缉绛栫暐**
| **灞傜骇** | **瑙﹀彂鏃舵満** | **鍘嬬缉鏂瑰紡** | **Token 浼樺寲** |
| ---------------------- | --------------------------- | -------------------------------- | -------------------- |
| **L1: 瀹炴椂鎹曡幏** | **after\_tool\_call** | **瑙勫垯杩囨护 (鍘婚噸/鐧藉櫔闊)** | **20-30%** |
| **L2: 浼氳瘽缁撴潫** | **command:stop** | **AI 璇箟鎽樿 (Gemini)** | **60-70%** |
| **L3: 瀹氭湡褰掓。** | **姣忔棩鍑屾櫒 (cron)** | **璺ㄤ細璇濆悎骞 + 涓婚鑱氱被** | **80-90%** |
**L2 鍘嬬缉娴佺▼ (浼氳瘽缁撴潫鏃)**
浼氳瘽缁撴潫 (command:stop)
鈫
1. 鏀堕泦鏈浼氳瘽鎵€鏈 memories (raw\_content)
鈫
2. 璋冪敤 Gemini API 鐢熸垚鎽樿
Prompt: "灏嗕互涓嬫搷浣滆褰曞帇缂╀负 3-5 鏉″叧閿喅绛栵紝姣忔潯涓嶈秴杩 50 瀛"
鈫
3. 瀛樺偍 compressed\_summary + embedding\_vector
鈫
4. 鏇存柊 session\_contexts (last\_summary, key\_decisions)
鈫
5. 鍒犻櫎鍘熷 raw\_content (浠呬繚鐣欏帇缂╁悗鍐呭)
**馃拤 **闃舵 4锛氫笂涓嬫枃鑷姩娉ㄥ叆绛栫暐
**娉ㄥ叆瑙﹀彂鏉′欢**
| **鍦烘櫙** | **瑙﹀彂鏉′欢** | **娉ㄥ叆鍐呭** |
| -------------------- | ---------------------------- | ----------------------------------------------- |
| **鏂颁細璇濆垱寤** | **command:new** | **鏈€杩 3 娆′細璇濇憳瑕 + 寰呭姙浠诲姟** |
| **缃戝叧鍚姩** | **gateway:startup** | **鍏ㄥ眬椤圭洰鐘舵€ (鎵€鏈 session\_contexts)** |
| **鐢ㄦ埛鎻愰棶** | **message\_received** | **璇箟妫€绱 Top 5 鐩稿叧璁板繂** |
| **宸ュ叿璋冪敤鍓** | **before\_tool\_call** | **鐩稿叧宸ュ叿鐨勫巻鍙蹭娇鐢ㄨ褰** |
**璇箟妫€绱㈡祦绋**
鐢ㄦ埛娑堟伅锛"Discuz X5 鐨 PHP7.4 琛ヤ竵杩涘害濡備綍锛"
鈫
1. 璋冪敤 Gemini embedding-001 鐢熸垚鏌ヨ鍚戦噺
鈫
2. SQLite 鍚戦噺鐩镐技搴︽悳绱 (浣欏鸡鐩镐技搴)
SELECT \* FROM memories
WHERE cosine\_similarity(embedding\_vector, ?) > 0.75
ORDER BY similarity DESC LIMIT 5
鈫
3. 娉ㄥ叆鍒 AI 涓婁笅鏂
System: "浠ヤ笅鏄浉鍏冲巻鍙茶蹇嗭細[5 鏉″帇缂╂憳瑕乚"
鈫
4. AI 鐢熸垚鍥炵瓟 (鍩轰簬娉ㄥ叆鐨勮蹇)
**馃敡 **闃舵 5锛歄penClaw 鍘熺敓瀹炵幇璺緞
**鏂规 A锛**Hook 涓棿浠**锛堟帹鑽愶級**
浣嶇疆**: **\~/.openclaw/hooks/openclaw-mem/openclaw-mem/
鈹溾攢鈹€ HOOK.md # 鍏冩暟鎹 + 鏂囨。
鈹溾攢鈹€ handler.ts # 涓诲鐞嗗櫒
鈹溾攢鈹€ memory-service.ts # 璁板繂鏈嶅姟 (SQLite + AI 鍘嬬缉)
鈹溾攢鈹€ schema.sql # SQLite Schema
鈹斺攢鈹€ package.json # 渚濊禆 (better-sqlite3, @google/generative-ai)
浼樺娍**:**
0 **鉁 OpenClaw 鍘熺敓鏀寔锛屾棤闇€淇敼鏍稿績浠ｇ爜**
0 **鉁 鑷姩鍙戠幇锛**openclaw hooks enable openclaw-mem** 鍗冲彲鍚敤**
0 **鉁 涓庣幇鏈 **session-memory** hook 鍏煎**
**鏂规 B锛**Plugin 鎻掍欢
浣嶇疆**: **\~/.openclaw/plugins/openclaw-mem/openclaw-mem/
鈹溾攢鈹€ plugin.json
鈹溾攢鈹€ index.ts # 鎻掍欢鍏ュ彛
鈹溾攢鈹€ hooks/
鈹 鈹溾攢鈹€ after\_tool\_call.ts
鈹 鈹溾攢鈹€ command\_stop.ts
鈹 鈹斺攢鈹€ gateway\_startup.ts
鈹斺攢鈹€ services/
鈹溾攢鈹€ sqlite-service.ts
鈹斺攢鈹€ compression-service.ts
浼樺娍**:**
0 **鉁 鏇村己澶х殑鎵╁睍鑳藉姏**
0 **鉁 鍙敞鍐岃嚜瀹氫箟鍛戒护 (濡 **/mem search**)**
**鈿栵笍 **澶у湥鐨勫喅绛栧缓璁
**鎺ㄨ崘锛**[**A] Hook 涓棿浠舵柟妗**
鐞嗙敱**:**
1. **鉁 OpenClaw 瀹樻柟鎺ㄨ崘鏂瑰紡 (鏂囨。鏄庣‘鏀寔)**
2. **鉁 杞婚噺绾э紝浠呮嫤鎴叧閿簨浠**
3. **鉁 涓庣幇鏈 hooks 鏃犵紳闆嗘垚**
4. **鉁 寮€鍙戞垚鏈綆 (棰勮 4-6 灏忔椂)**
瀹炴柦姝ラ**:**
1. **鍒涘缓 **\~/.openclaw/hooks/openclaw-mem/
2. **瀹炵幇 **handler.ts** (鐩戝惉 5 涓叧閿簨浠)**
3. **鍒濆鍖 SQLite 鏁版嵁搴**
4. **闆嗘垚 Gemini embedding-001**
5. **娴嬭瘯鑷姩鎹曡幏 + 鍘嬬缉 + 娉ㄥ叆**
**馃搵 **涓庣幇鏈 memory-enhancement-engine 鍗忓悓
| **鍔熻兘** | **鐜版湁寮曟搸** | **openclaw-mem** | **鍗忓悓鏂瑰紡** |
| ------------------ | ------------------------------ | ------------------------------ | -------------------- |
| **璁板繂瀛樺偍** | **Markdown 鏂囦欢** | **SQLite** | **杩佺Щ鎴栧苟瀛** |
| **宓屽叆妯″瀷** | **Gemini embedding-001** | **Gemini embedding-001** | **鉁 澶嶇敤** |
| **妫€绱㈡柟寮** | **鎵嬪姩璋冪敤鑴氭湰** | **鑷姩娉ㄥ叆** | **浜掕ˉ** |
| **鍘嬬缉鏂瑰紡** | **瑙勫垯 + 鎽樿** | **AI 璇箟鍘嬬缉** | **鍗囩骇** |
杩佺Щ绛栫暐**:**
**淇濈暀鐜版湁 69 涓蹇嗘枃浠朵綔涓哄巻鍙插綊妗**
**openclaw-mem 浠庡惎鐢ㄤ箣鏃ヨ捣鑷姩鎹曡幏鏂拌蹇**
**鎻愪緵杩佺Щ宸ュ叿 (鍙€): **python3 migrate-to-sqlite.py
**鉁 鍏抽敭鎴愭灉**
| **鍔熻兘** | **鐘舵€** | **璇佹槑** |
| ------------------ | ----------------- | ------------------------------------ |
| **AI 鍘嬬缉** | **鉁 宸ヤ綔** | **DeepSeek API 鐢熸垚 3 鏉℃憳瑕** |
| **鍚戦噺宓屽叆** | **鉁 宸ヤ綔** | **Gemini embedding-001** |
| **璇箟妫€绱** | **鉁 宸ヤ綔** | **浣欏鸡鐩镐技搴 0.679** |
| **鏁版嵁搴** | **鉁 宸ヤ綔** | **13 鏉¤褰曪紝1 鏉 AI 鎽樿** |
**馃幆 **棰勬湡鏁堟灉
**鐢熶骇鐜琛屼负**
1. **鑷姩鎹曡幏**: 姣忔宸ュ叿璋冪敤銆佺敤鎴锋秷鎭嚜鍔ㄥ瓨鍌
2. **浼氳瘽缁撴潫**: 鑷姩鐢熸垚 AI 鎽樿锛圖eepSeek API锛
3. **璇箟妫€绱**: 鐢ㄦ埛鎻愰棶鏃惰嚜鍔ㄦ绱㈢浉鍏宠蹇嗭紙鐩镐技搴 >0.5锛
4. **涓婁笅鏂囨敞鍏**: Top 3-5 鐩稿叧璁板繂娉ㄥ叆鍒 AI 涓婁笅鏂
**Token 浼樺寲**
| **鍦烘櫙** | **浼樺寲鍓** | **浼樺寲鍚** | **浼樺寲鐜** |
| -------------------- | ----------------------- | ---------------------- | ---------------------- |
| **闀夸細璇濆巻鍙** | **10,000 tokens** | **1,000 tokens** | **90%**猬囷笍 |
| **璺ㄤ細璇濇绱** | **鍏ㄩ噺鍔犺浇** | **Top 5 璁板繂** | **80%**猬囷笍 |
| **浼氳瘽鎽樿** | **浜哄伐鎬荤粨** | **AI 鑷姩鐢熸垚** | **100%**猬嗭笍鏁堢巼 |
**鈿狅笍 **娉ㄦ剰浜嬮」
1. **棣栨鍚敤**: 鏁版嵁搴撹嚜鍔ㄥ垱寤猴紙**\~/.openclaw/openclaw-mem.db**锛
2. **API 鎴愭湰**: DeepSeek锛堟憳瑕侊級+ Gemini锛圗mbedding锛夋寜閲忚璐
3. **闅愮鎺у埗**: 鏁忔劅鎿嶄綔涓嶄細瀛樺偍锛圔ash 鍛戒护缁撴灉宸茶繃婊わ級
4. **鎬ц兘褰卞搷**: <10ms/娆★紙SQLite + 鏈湴缂撳瓨锛
[/md]