From duckdb-skills
Searches past Claude Code session logs to recall decisions, patterns, or unresolved work. Useful when users reference prior conversations, say 'do you remember', or need historical context.
How this skill is triggered — by the user, by Claude, or both
Slash command
/duckdb-skills:read-memoriesThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Search past session logs silently — do NOT narrate the process. Absorb the results and continue with enriched context.
Search 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.
npx claudepluginhub duckdb/duckdb-skills --plugin duckdb-skillsSearches past Claude Code session logs for keywords to recover context like decisions, data paths, CRS info, model configs, and unresolved work across projects or scoped to current one.
Searches and recalls previous Claude Code conversation sessions by querying a local SQLite FTS5 index or JSONL log files.