Tables · `opencode`

20 tables. Filter by name, verdict, or required-filter shape below.

Required filter:

20 of 20 tables

Status	Name	Required filters	Description
pass	account_states	—	Records which account and org are currently active in the OpenCode UI.
pass	accounts	—	OpenCode account rows used for provider authentication. Exposes the account email, url, token expiry, and timestamps. The underlying `access_token` / `refresh_token` are not exposed; they are live secrets.
pass	control_accounts	—	Control-plane account rows used for authenticated coordination. Exposes email, url, active flag, and timestamps. The underlying `access_token` / `refresh_token` are live secrets and not exposed.
pass	credentials	—	Stored provider credential rows (label, connector, method, active flag, timestamps). The underlying `value` is a live secret (API key / token) and is not exposed.
pass	data_migrations	—	Applied data migrations recorded by opencode, with the timestamp each completed at.
pass	event_sequences	—	Per-aggregate event sequencing counters opencode uses to keep events ordered. Useful for understanding which aggregate owns an event stream and how far it has advanced.
pass	events	—	The full OpenCode domain event log. This is OpenCode's largest and most granular table: every state change (session created, message appended, todo updated, ...) is recorded here with an aggregate id and per-aggregate sequence number. The `data` blob is typed by `type`.
pass	messages	—	All messages stored in the local OpenCode database, in session order. Each row exposes the message id, parent session, timestamps, and the full message payload as a JSON column.
pass	migrations	—	Applied schema migrations recorded by opencode, with the timestamp each completed at.
pass	parts	—	All message parts (text, tool calls, images, etc.) stored in the local OpenCode database. Each row carries the parent message and session ids, timestamps, and the full part payload — including the actual `text`, `tool_call`, or synthetic-tool fields — as JSON. This is the table to read when you want the transcript content.
pass	permissions	—	Permission rows describing what actions a project grants on a resource (read / write on sessions, projects, etc.).
pass	project_directories	—	Directory entries attached to OpenCode projects, with the entry's type (worktree, sandboxed, etc.) and strategy when present.
pass	projects	—	All projects stored in the local OpenCode database. Each row carries the project id, worktree, display name, and timestamps.
pass	session_context_epochs	—	Per-session context-epoch rows opencode uses to track context compaction / baseline snapshots. Useful for auditing compaction history.
pass	session_inputs	—	All user prompts that OpenCode has admitted to a session, in per-session admission order. Useful for replaying what the user asked for across a session.
pass	session_messages	—	Per-session message stream with the `seq` order OpenCode assigns internally, alongside the full payload as JSON. Use this when you need exact session-relative ordering rather than `time_created`.
pass	session_shares	—	All `opencode session share` records: public share URLs for sessions. The underlying share `secret` is a credential and is intentionally not exposed by this source.
pass	sessions	—	All sessions stored in the local OpenCode database, with flattened model, token, cost, and timestamp columns. Each row includes the raw `metadata`, `summary_diffs`, `revert`, and `permission` blobs in a `metadata` JSON column so nothing is lost.
pass	todos	—	All session todo list entries stored in the local OpenCode database. Each row carries the session id, content, status, priority, and ordering position.
pass	workspaces	—	All OpenCode workspaces. Each row carries the workspace id, project, directory, type, name, branch, extra metadata, and the recorded `time_used` counter.