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

default store
default store
Role:

primary_chat

Format:

sqlite

Coverage:

default_search

Adapter:

opencode.db_sqlite.v1

Role:

primary_chat

Format:

json_object

Coverage:

catalog_only

Adapter:

-

catalog store
catalog store
Role:

app_state

Format:

json_object

Coverage:

catalog_only

Adapter:

-

private store
private store
Role:

app_state

Format:

json_object

Coverage:

private

Adapter:

-

catalog store
catalog store
Role:

source_tree

Format:

opaque

Coverage:

catalog_only

Adapter:

-

catalog store
catalog store
Role:

cache

Format:

opaque

Coverage:

catalog_only

Adapter:

-

catalog store
catalog store
Role:

app_state

Format:

text

Coverage:

catalog_only

Adapter:

-

Role:

cache

Format:

text

Coverage:

catalog_only

Adapter:

-

opencode.db

opencode.db
default store
default store
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

opencode.storage_legacy
catalog store
catalog store
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

opencode.config
catalog store
catalog store
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

opencode.auth
private store
private store
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

opencode.snapshots
catalog store
catalog store
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

opencode.repos
catalog store
catalog store
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

opencode.logs
catalog store
catalog store
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

opencode.tool_output
catalog store
catalog store
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

id

TEXT

Session id (primary key)

project_id

TEXT

Git remote/root hash, or global

directory

TEXT

Working directory, stored verbatim

title

TEXT

Session title

time_created / time_updated

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 type

Searchable field

text

text (user prompts and assistant replies)

reasoning

text (model thinking)

subtask

prompt

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.