← Back to Skills Marketplace
91
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install opencode-session-toolkit
Description
Read the local OpenCode SQLite database, run cross-directory session queries, and export sessions to Markdown files.
Usage Guidance
This skill appears to implement exactly what it says (read a local OpenCode SQLite DB and export sessions), but verify a few things before you install/use it: 1) The SKILL.md and script call the local `opencode` CLI to resolve the DB path (and examples use `sqlite3`, `column`, `date`) — make sure those tools are present and trustworthy; the registry metadata failing to list them is an omission. 2) The script opens the DB read-only (good), but exported sessions may contain sensitive chat/message contents — review the output location and use filters (or avoid --all) if you don't want to export everything. 3) The script requires Python 3.11+ per its header and the shebang is unusual; run it explicitly with a known Python interpreter (python3.11 ./scripts/export_opencode_sessions.py --output-dir <dir> [filters]). 4) If you want higher assurance, inspect the included script (scripts/export_opencode_sessions.py) yourself and test it in a safe/isolated environment. If the metadata were corrected to list the external CLI dependencies and clarify the Python requirement, the coherence concerns would be resolved.
Capability Analysis
Type: OpenClaw Skill
Name: opencode-session-toolkit
Version: 1.0.0
The opencode-session-toolkit skill is designed to query and export local OpenCode session data from a SQLite database. The implementation follows security best practices, such as using read-only database connections (via the -readonly flag in shell and mode=ro in Python) and parameterized SQL queries to prevent injection. The Python script scripts/export_opencode_sessions.py includes path sanitization for file exports and lacks any network communication or data exfiltration logic. The instructions in SKILL.md are transparent and include explicit warnings about sensitive data in specific tables.
Capability Assessment
Purpose & Capability
The skill's stated purpose (read OpenCode DB and export sessions) matches the included code and SKILL.md. However, the registry metadata claims no required binaries or environment variables while the SKILL.md and the script rely on the local `opencode` CLI to resolve the DB path and the examples rely on `sqlite3`, `column`, and standard shell utilities; that mismatch is unexpected and may cause runtime failures or hidden dependencies.
Instruction Scope
The runtime instructions and the bundled Python script stay within the stated scope: they resolve a local DB path, open the database read-only, run queries, and write Markdown files. There are no network endpoints, secret exfiltration, or commands that read unrelated system configuration. The SKILL.md does include examples that search message JSON (which may contain sensitive session content) — expected for this purpose but worth noting.
Install Mechanism
There is no install spec (instruction-only plus a bundled Python script). The script is pure-Python and uses stdlib modules; nothing is downloaded from external URLs. This is a low-risk install model. One oddity: the script shebang uses "#!/usr/bin/env -S uv run --script" which is unusual and may not work on many systems; the SKILL.md recommends running the script directly with a Python interpreter.
Credentials
No credentials or secrets are requested (good). But the skill implicitly depends on local tools and env vars (opencode CLI, possibly sqlite3, XDG_DATA_HOME/HOME) while the registry metadata lists none — an omission that reduces transparency. The script itself does not access environment variables beyond standard XDG/HOME resolution and does not transmit data externally.
Persistence & Privilege
The skill is not marked always:true and does not request system-wide persistence or modify other skills. The agent config (agents/openai.yaml) allows implicit invocation, which is common and expected; this is not a standalone red flag here.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install opencode-session-toolkit - After installation, invoke the skill by name or use
/opencode-session-toolkit - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of OpenCode Session Toolkit.
- Query and read your local OpenCode SQLite database across any directory or project.
- Export sessions to Markdown files with flexible filters (by project, time range, ID, contents, etc.).
- Includes shell and SQL recipes for listing, searching, and time-converting session and message data.
- Markdown export groups files by project and allows detailed export customization.
- All queries run in read-only mode for safety.
Metadata
Frequently Asked Questions
What is opencode-session-toolkit?
Read the local OpenCode SQLite database, run cross-directory session queries, and export sessions to Markdown files. It is an AI Agent Skill for Claude Code / OpenClaw, with 91 downloads so far.
How do I install opencode-session-toolkit?
Run "/install opencode-session-toolkit" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is opencode-session-toolkit free?
Yes, opencode-session-toolkit is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does opencode-session-toolkit support?
opencode-session-toolkit is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created opencode-session-toolkit?
It is built and maintained by Wu Fei (@wufei-png); the current version is v1.0.0.
More Skills