skills.rest
pjherron
pjherronCOMMUNITY
Explore all skills by this author →
GitHub

session-recruitment

Queries the OpenCode SQLite database to list, search, and resume past sessions.

Updated Jul 16, 2026
Search Tags:#cli#sqlite#opencode#session history#context recovery#session search#resume session
One-click install
npx skills add https://github.com/pjherron/hypoc --skill session-recruitment-pjherron
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: session-recruitment
Source: https://github.com/pjherron/hypoc/tree/main/hypoc/skills/session-recruitment
Command: npx skills add https://github.com/pjherron/hypoc --skill session-recruitment-pjherron

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? It removes the friction of losing track of prior OpenCode conversations by letting you find, inspect, and reopen past sessions directly from the local SQLite session database. ## Core Features & Use Cases - Session Discovery: List recent sessions, search by title keyword, filter by date range, or filter by working directory using ready-made sqlite3 queries. - Session Resumption: Reopen any session with opencode -s ses_[ID] or fork it into an independent copy. - Helper Script: An optional oc-sessions bash utility wraps common operations (list, search, today, info, open) into short commands. - Use Case: When you ask "what did we work on yesterday?", the skill runs a date-filtered query against opencode.db and returns formatted results with reopen commands. ## Quick Start Ask the assistant to show all OpenCode sessions from yesterday and how to reopen the most recent one.

Frequently Asked Questions about session-recruitment

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I list my recent OpenCode sessions?▼

Run a sqlite3 query against ~/.local/share/opencode/opencode.db selecting id, title, and timestamps from the session table ordered by time_updated. The skill provides a ready-made query that formats results with reopen commands.

How do I search OpenCode sessions by keyword?▼

Query the session table with a WHERE title LIKE '%keyword%' clause against the opencode.db SQLite database. You can also filter by directory path or date range to narrow results to a specific project or period.

How do I resume a previous OpenCode session?▼

Run opencode -s ses_[SESSION_ID] with the session ID from the database. Add the --fork flag to create an independent copy of the session instead of continuing it directly.

Where does OpenCode store session history?▼

OpenCode stores all session history in a SQLite database at ~/.local/share/opencode/opencode.db. The session table includes id, title, timestamps, directory, cost, and token usage columns.

Why does the session query return no results?▼

The database may be new or empty, or sessions may exist only as legacy JSON files from before the SQLite migration. Run opencode db migrate to import old sessions, and verify the database path with opencode db path.

Related Skills

Explore More Software Engineering Skills→
BSteffaniakBSteffaniak

session-history

Query a local SQLite database to retrieve past conversation sessions and transcripts.

Community
Intermediate
stackqlstackql

read-memories

Search Claude Code JSONL logs for decisions, patterns, and open TODOs.

Official
Intermediate
ngocsangyemngocsangyem
14

meow:memory

Capture session learnings into memory/lessons.md and memory/patterns.json.

Community
Advanced
specks-devspecks-dev

prepare-git-commit-message

Generate review-ready git commit messages from uncommitted changes and diffs.

Official
Basic