Read Memories
Search past Claude Code session logs to recall prior decisions, patterns, or unresolved work.
by duckdb · MIT
The skill
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.
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.
Use this skill
Connect your agent to the Skill Store MCP server and ask for it by ref: duckdb/read-memories-50932792062.
Details
- Publisher
- duckdb
- Category
- AI & Agents › Memory & context
- License
- MIT
- Updated
- 2026-04-14
References
More from duckdb
- Attach Db Attach a DuckDB database file for use with /duckdb-skills:query.
- Convert File Convert any data file to another format: CSV, Parquet, JSON, Excel, GeoJSON, and more.
- Duckdb Docs Search DuckDB and DuckLake documentation and blog posts.
- Install Duckdb Install or update DuckDB extensions.