conversations
v2.0.0从 OpenClaw sessions/*.jsonl 导入对话历史到本地 SQLite，配合 FTS5 全文搜索。成为真正的记忆库，支持语义化查询历史对话，让整理和回顾更高效。装好后跑一次 import，之后随时可以 query。
⭐ 0· 90·0 current·0 all-time
by@shu0yu
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
OpenClaw
Benign
high confidencePurpose & Capability
Name/description claim: import OpenClaw sessions into local SQLite with FTS5 and provide query tooling. The included scripts implement exactly that: they locate sessions under an OpenClaw workspace, parse JSONL message records, deduplicate by MD5, create a local conversations.db, and provide LIKE/FTS5 search. No unexpected external services, binaries, or credentials are required.
Instruction Scope
SKILL.md and the scripts instruct running the bundled Python scripts and optionally scheduling via openclaw cron. They access files under agents/main/sessions (or the workspace path) and write a local conversations.db. This is in-scope for the stated purpose. Minor discrepancy: SKILL.md documents environment variables (OPENCLAW_WORKSPACE, CONVERSATIONS_DB, DRY_RUN) that are used by the scripts but the registry did not list any required env vars — these are configuration vars (not secrets) and optional, but the documentation/registry mismatch is worth noting.
Install Mechanism
Instruction-only with bundled Python scripts; there is no network download, no package install, and no install spec. This minimizes install-time risk. Scripts rely on Python 3.8+/3.9+ and built-in sqlite3; no third-party packages or external URLs are fetched.
Credentials
The skill requests no credentials or privileged config paths. It does read session files from the OpenClaw workspace (which contain chat history) and writes a local DB. The referenced environment variables are for configuration only (workspace path, DB path, dry-run) and do not contain secrets; still, the skill will aggregate potentially sensitive chat content locally—this is expected but worth informing the user.
Persistence & Privilege
always is false and the skill does not request persistent platform-level privileges or modify other skills. It creates/updates a conversations.db in the workspace but does not alter agent configurations beyond scheduling guidance (cron example).
Assessment
This skill is internally coherent and implements what it claims: it reads your OpenClaw session JSONL files and builds a local SQLite database for keyword/FTS search. Before installing: (1) be aware it will aggregate your chat contents into a local DB (no network exfiltration in the code), so don’t install if you don’t want local copies of conversations; (2) run import with DRY_RUN first to verify paths and parsing; (3) ensure your Python+SQLite build supports FTS5 if you want full-text search (otherwise it falls back to LIKE); (4) back up or inspect any existing conversations.db before running to avoid accidental overwrites; and (5) note the SKILL.md documents OPENCLAW_WORKSPACE / CONVERSATIONS_DB / DRY_RUN as config vars even though the registry didn't mark required env vars.Like a lobster shell, security has layers — review code before you run it.
latestvk977mkybvg8e703sfage7777en84fm5v
License
MIT-0
Free to use, modify, and redistribute. No attribution required.