360 Secure SkillHub
360 安全技能中心

FTS5 Session Search

为 OpenClaw 会话日志建立 SQLite FTS5 全文索引,提供关键词搜索、主题检索、时间范围过滤与统计查询,支持增量索引,并可通过脚本定期更新索引;检索在本地数据库完成。

larios613-hub
larios613-hub
热度 25.21
最近更新 2026-05-23 12:57:24
分类:搜索依赖:代码执行 / 读写文件应用场景:研究

安装技能

复制下面的话术发给你的 Agent,它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill: npx secure-skills-cli add fts5-session-search
Metadata
name
fts5-session-search
version
1.0.0
description
Full-text search across all OpenClaw session logs using SQLite FTS5. Instant keyword search, topic queries, time-range filtering, and statistics.
license
MIT
tags
["search","fts5","full-text","session-log","sqlite","indexing","retrieval"]
source
el-rudo-larios/fts5-search
trigger
search session logs full text keyword find conversation
metadata
{"openclaw":{"emoji":"🔍"}}

FTS5 Search — Full-Text Search for Session Logs

Index and search all your OpenClaw session logs using SQLite FTS5. Find any conversation, topic, or keyword in milliseconds.

Quick Start

from search import SearchEngine

engine = SearchEngine(db_path="search.db")

# Index all sessions
engine.index_all(sessions_dir="/path/to/sessions")

# Search
results = engine.search("supervision layer")
# → [<SessionMatch score=0.92 session="2026-05-22-security">]

# Search by topic
results = engine.search("security audit", scope="topic")

# Time range
results = engine.search("deploy", after="2026-05-01", before="2026-05-22")

Features

  • Full-text search across all session logs
  • FTS5 tokenizer with ranking and relevance scoring
  • Topic search — search within topic summaries
  • Time-range queries — find conversations by date
  • Statistics — term frequency, session count, index size
  • Incremental indexing — only new/changed sessions are reindexed
  • Sub-12ms query times across 4000+ messages

Performance

Metric Value
Sessions indexed 115+
Messages searchable 4,126+
Query time < 12ms
Index size < 5MB

License

MIT