OpenCode Memory Browser
0This skill provides read-only access to OpenCode data stored on the local machine, utilizing a local SQLite database. It's designed for users who need to lookup historical project data without external dependencies.
000Updated 2mo ago
Data Access
Quick InstallView Source
$ npx skills add https://github.com/carson2222/skills --skill opencode-memoryOverview
About This Skill
The OpenCode Memory Browser skill provides lightweight, read-only access to your local OpenCode history without external dependencies. It queries a local SQLite database and plain files to retrieve sessions, conversations, plans, prompt history, and project context stored on your machine. Use this skill when you need to check what was done in previous sessions, recall prior decisions, search past conversations, or find saved plans. The skill auto-triggers when you resume a project or reference earlier work, and respects XDG data directories for cross-platform compatibility. All data remains local—it does not access ChatGPT, Claude cloud history, or external memory systems.
How to Use
Install via the command: $ npx skills add https://github.com/carson2222/skills --skill opencode-memory
Use Cases
Resuming work on a project with prior sessions
Referencing something done previously
Checking recurring issues against history
Inquiring about past decisions or approaches
Tags
Setup & Installation
Quick Install
Terminal
$ npx skills add https://github.com/carson2222/skills --skill opencode-memoryAlternative Install (Git Clone)
git clone https://github.com/carson2222/skillsRequirements
- Claude Code or compatible AI agent
Quick Start Guide
1
Install the Skill
Copy the install command above and run it in your terminal.
2
Open Your AI Agent
Launch Claude Code, Cursor, or your preferred AI coding agent.
3
Try It Out
Use the prompt template or examples below to test the skill.
4
Customize
Adapt the skill to your specific use case and workflow.
Usage Examples
Prompt Template
I need to browse historical OpenCode project data stored in a local SQLite database. Please query the database for [SPECIFIC_TABLE_OR_QUERY] and return the results in a structured format. Focus on [FILTER_CRITERIA, e.g., recent projects, specific file types, or keywords].
Example Output
### OpenCode Historical Project Data (SQLite Local DB) #### **Projects Modified in Last 30 Days** | Project Name | Last Modified | File Count | Key Tags | |--------------|---------------|------------|----------| | **AI Assistant v2** | 2024-05-15 | 47 | NLP, Python, Testing | | **Data Pipeline** | 2024-05-10 | 128 | ETL, SQL, BigQuery | | **UI Redesign** | 2024-05-08 | 23 | React, CSS, Figma | #### **Recent Python Files** - `src/main.py` (Modified: 2024-05-14) – Contains core logic for the AI assistant. - `tests/test_nlp.py` (Modified: 2024-05-12) – Unit tests for NLP module. - `scripts/clean_data.py` (Modified: 2024-05-09) – Data preprocessing script. #### **Top 5 Largest Projects** 1. **Data Pipeline** (128 files, 1.2MB) 2. **AI Assistant v2** (47 files, 890KB) 3. **Backend API** (32 files, 650KB) 4. **UI Redesign** (23 files, 420KB) 5. **DevOps Scripts** (18 files, 310KB) *Query executed on `opencode_local.db` (SQLite, read-only).*
Find the right skills for your stack
Take a free 3-minute scan and get personalized AI skill recommendations.
Take free scan