Windows: Sessions not showing in opencode desktop UI due to inconsistent path separator (/ vs \) #31597

Description

On Windows, sessions created at different times store the directory field in the SQLite DB with inconsistent path separators — some use forward slashes (D:/Workspace/my-project), others use backslashes (D:\Workspace\my-project). The project.worktree field uses backslashes (D:\Workspace\my-project).

When opencode loads sessions for the current project, it appears to match session.directory against the current working directory (or project.worktree) using exact string comparison. Because of the slash mismatch, sessions stored with / are not displayed in the opencode desktop UI session list.

opencode does not normalize path separators when persisting session.directory. On Windows, path.resolve() or equivalent can return either / or \ depending on the calling context (e.g. Git integration may return /, Node.js process.cwd() returns ).

Suggested Fix
Normalize all file paths to use the OS-native separator (or consistently use /) before writing to the database. For example, call path.normalize() or replace / with \ on Windows before any DB write.

Workaround
Manually update the SQLite database:

sqlite3 ~/.local/share/opencode/opencode.db
"UPDATE session SET directory = REPLACE(directory, '/', '') WHERE directory LIKE '%:/%';"

Plugins

No response

OpenCode version

v1.14.22

Steps to reproduce

-- project table
SELECT worktree FROM project WHERE id='abc123...';
-- Result: D:\Workspace\my-project

-- session table (before fix)
SELECT directory, COUNT(*) FROM session WHERE project_id='abc123...' GROUP BY directory;
-- Result:
-- D:/Workspace/my-project | 17
-- D:\Workspace\my-project | 1

17 sessions were invisible in the TUI because their directory used / while the project used .

Screenshot and/or share link

No response

Operating System

Windows 11

Terminal

opencode desktop