Memory V2 Skill

Memory Lucia - Local SQLite-based memory system for OpenClaw agents. Features: (1) Priority analysis and tracking, (2) Learning progress with milestones, (3)...

Key issues to consider before installing or using this skill: - Code/schema mismatches: Several modules reference database columns that don't exist in database/schema.sql (examples: LearningModule.insert uses milestone_name but schema column is title; completeMilestone updates is_completed/completed_date while schema uses status/completed_at; EvolutionModule attempts to insert old_level/new_level into memory_evolution_history though the schema expects event_type/event_data). These mismatches will likely cause runtime SQL errors or silent data corruption. - Logical bugs: EvolutionModule.recordUsage shadows the function parameter named 'result' with a const result from db.run, which breaks the success/failure logic and the XP/level flow. Expect incorrect behavior or exceptions. - Missing artifacts: SKILL.md and other docs reference migration scripts (migrations/v1-to-v2.js) and demo initializers that are not present or inconsistent. Also SKILL.md reports inconsistent version numbers in places (2.5.4 vs 2.0.2). This indicates the package may be incomplete or poorly maintained. - Filenames and DB names differ: api/index.js uses './memory-v2.db' while QueryModule defaults to './memory-v2.5.db' — ensure the module actually opens the intended DB file to avoid fragmentation of data across files. - No external network activity or secret access detected in provided files, which is good — but you should still inspect the omitted files (modules/version.js, scripts, package.json, and any other truncated files) before trusting the package. Recommendations: 1) Do NOT deploy this against sensitive or production data until the above issues are fixed. Run it in an isolated environment or container for evaluation. 2) Review the remaining files (package.json, modules/version.js, scripts/init-memory.js, scripts/init-demo.js, and any omitted files) for any network calls, downloads, or env var usage. Confirm package.json dependencies and any postinstall scripts. 3) Fix the DB schema vs code mismatches or regenerate schema to match code; add parameterized queries where template interpolation occurs (some SQL uses string interpolation for time offsets). 4) Run unit tests or simple smoke tests: init DB, call api.init(), call a few API methods, and watch for SQL errors. Verify where the DB file is created and that backups (if any) are local. 5) If you need migration support, ask the author for the missing migration script and for consistent versioning; otherwise treat the project as requiring manual migration. If you want, I can parse the omitted files (package.json, version module, remaining code) to check for network calls or other inconsistencies — provide those files and I will re-evaluate.