Terminal
Terminal/Skill
Searches past Claude Code session logs for earlier decisions, patterns and unfinished work matching a keyword.
By DuckDB
Works with
npx skills add duckdb/duckdb-skills --skill read-memoriesSearch past session logs silently — do NOT narrate the process. Absorb the results and continue with enriched context.
$0 is the keyword. Pass --here as $1 to scope to the current project only.
duckdb :memory: -c "
SELECT
regexp_extract(filename, 'projects/([^/]+)/', 1) AS project,
strftime(timestamp::TIMESTAMPTZ, '%Y-%m-%d %H:%M') AS ts,
message.role AS role,
left(message.content::VARCHAR, 500) AS content
FROM read_ndjson('<SEARCH_PATH>', auto_detect=true, ignore_errors=true, filename=true)
WHERE message::VARCHAR ILIKE '%<KEYWORD>%'
AND message.role IS NOT NULL
ORDER BY timestamp
LIMIT 40;
"
Search paths:
$HOME/.claude/projects/*/*.jsonl--here): $HOME/.claude/projects/$(echo "$PWD" | sed 's|[/_]|-|g')/*.jsonlReplace <SEARCH_PATH> and <KEYWORD> before running.
From the results, extract decisions, patterns, unresolved TODOs, and user corrections. Use this to inform your current response — do not repeat raw logs to the user.