read-memories
Search past Claude Code session logs to recall prior decisions, patterns, or unresolved work. Use when user says "do you remember", "what did we do", references past conversations, or you need context from prior sessions.
How do I install this agent skill?
npx skills add https://github.com/duckdb/duckdb-skills --skill read-memoriesIs this agent skill safe to install?
- Gen Agent Trust Hubpass
This skill allows the agent to search and recall information from past conversation logs using the DuckDB CLI. It provides a template for querying local JSONL files to help the agent maintain context across sessions.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
- ZeroLeakspass
Score: 93/100 · 2 sections analyzed
What does this agent skill do?
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.
Step 1 — Query
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:
- All projects:
$HOME/.claude/projects/*/*.jsonl - Current only (
--here):$HOME/.claude/projects/$(echo "$PWD" | sed 's|[/_]|-|g')/*.jsonl
Replace <SEARCH_PATH> and <KEYWORD> before running.
Step 2 — Internalize
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.
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/duckdb/duckdb-skills/read-memories">View read-memories on skillZs</a>