read-memories

Original：🇺🇸 English

Translated

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.

4installs

Sourceduckdb/duckdb-skills

Added on2026-05-31

NPX Install

npx skill4agent add duckdb/duckdb-skills read-memories

SKILL.md Content

View Translation Comparison →

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

bash

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.

read-memories

NPX Install

Tags

SKILL.md Content

Step 1 — Query

Step 2 — Internalize