OpenCode¶
Base path: ~/.local/share/opencode (env overrides: XDG_DATA_HOME, OPENCODE_DB).
observed_version: opencode v1.15.11 (observed 2026-05-30).
OpenCode (anomalyco/opencode) stores conversations in a single SQLite
database, opencode.db, under its XDG data directory
(${XDG_DATA_HOME:-~/.local/share}/opencode). Non-stable install
channels use opencode-<channel>.db, and OPENCODE_DB can relocate the
database (an absolute path is used directly). This makes OpenCode a
SQLite backend, like Grok’s session_search and Cursor’s state.vscdb,
rather than a JSONL-transcript backend.
Stores¶
- Role:
primary_chat- Format:
sqlite- Coverage:
default_search- Adapter:
opencode.db_sqlite.v1
- Role:
primary_chat- Format:
json_object- Coverage:
catalog_only- Adapter:
-
- Role:
app_state- Format:
json_object- Coverage:
catalog_only- Adapter:
-
- Role:
app_state- Format:
json_object- Coverage:
private- Adapter:
-
- Role:
source_tree- Format:
opaque- Coverage:
catalog_only- Adapter:
-
- Role:
cache- Format:
opaque- Coverage:
catalog_only- Adapter:
-
- Role:
app_state- Format:
text- Coverage:
catalog_only- Adapter:
-
- Role:
cache- Format:
text- Coverage:
catalog_only- Adapter:
-
opencode.db¶
SQLite store (Drizzle). Tables session (id, project_id, directory = working dir, title, version, time_created/updated, model, cost, tokens_*), message (id, session_id FK, data JSON with role user/assistant, modelID/providerID, time, path.cwd), and part (id, message_id FK, session_id, data JSON with type + payload). Searchable text lives in part.data: type text/reasoning -> text, subtask -> prompt. A conversation turn is reconstructed by joining part -> message -> session. Channel installs use opencode-<channel>.db; OPENCODE_DB overrides the path (also :memory:/absolute).
- Agent:
opencode
- Role:
primary_chat- Format:
sqlite- Coverage:
default_search- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/opencode.db- Adapter:
opencode.db_sqlite.v1- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
yes
The sole searchable OpenCode store. kind is derived from the joined message role (user -> prompt, else history).
opencode.storage_legacy¶
Pre-migration on-disk layout: one JSON file per session/message/part. A startup migration folds these into opencode.db; migrated installs keep only an empty storage/session_diff/ and a storage/migration marker. Documentary — relevant only to older, un-migrated installs.
- Agent:
opencode
- Role:
primary_chat- Format:
json_object- Coverage:
catalog_only- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/storage/{session,message,part}/**/*.json- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
opencode.config¶
Application config (opencode.json/opencode.jsonc): providers, agents, plugins, commands, UI settings. Configuration, not chat.
- Agent:
opencode
- Role:
app_state- Format:
json_object- Coverage:
catalog_only- Path:
${XDG_CONFIG_HOME or ${HOME}/.config}/opencode/opencode.json- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
opencode.auth¶
Provider API keys and OAuth tokens. Documented but never enumerated.
- Agent:
opencode
- Role:
app_state- Format:
json_object- Coverage:
private- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/auth.json- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
opencode.snapshots¶
Per-project git repositories holding session file snapshots.
- Agent:
opencode
- Role:
source_tree- Format:
opaque- Coverage:
catalog_only- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/snapshot/- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
opencode.repos¶
Cache of cloned git repositories referenced during sessions.
- Agent:
opencode
- Role:
cache- Format:
opaque- Coverage:
catalog_only- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/repos/- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
opencode.logs¶
Timestamped application logs. Diagnostics, not chat content.
- Agent:
opencode
- Role:
app_state- Format:
text- Coverage:
catalog_only- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/log/- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
opencode.tool_output¶
Overflow storage for large tool output that exceeds inline limits.
- Agent:
opencode
- Role:
cache- Format:
text- Coverage:
catalog_only- Path:
${XDG_DATA_HOME or ${HOME}/.local/share}/opencode/tool-output/- Adapter:
-
- Data version:
-- Version strategies:
-- Observed:
opencode v1.15.11 (observed 2026-05-30) (2026-05-30)
- Default search:
no
Record schema¶
opencode.db¶
A relational session → message → part schema (Drizzle). A conversation
turn is reconstructed by joining a part row up to its message (for
the role) and session (for the title and working directory).
User text parts participate in the default prompt scope; assistant and
reasoning parts require --scope conversations or --scope all.
session table — one row per session:
Column |
Type |
Description |
|---|---|---|
|
TEXT |
Session id (primary key) |
|
TEXT |
Git remote/root hash, or |
|
TEXT |
Working directory, stored verbatim |
|
TEXT |
Session title |
|
INTEGER |
Unix milliseconds |
message table — id, session_id (FK), and a data JSON column:
{"role": "assistant", "modelID": "...", "providerID": "...",
"time": {"created": 1779999665000}, "path": {"cwd": "..."}}
part table — id, message_id (FK), session_id, and a data JSON
column holding one content part. The searchable text lives here:
Part |
Searchable field |
|---|---|
|
|
|
|
|
|
A part’s kind is derived from the joined message role (user →
prompt, otherwise history). Tool, file, snapshot, patch, and step-marker
parts are metadata and stay outside default search. Message timestamps
are unix-milliseconds and are normalized to ISO-8601.
The legacy pre-migration layout (one JSON file per session, message, and
part under storage/) is documented but no longer searched — current
installs migrate it into opencode.db on startup.