Distillation

Date: Sep 14, 2026

• 🔴 [requested-read-only-research] (16:34) User requested post-restart, read-only repository research with no file edits, narrowly limited to: (1) exact current patterns for adding a Core SQLite table and generating its migration, and (2) starting a process-global Core node in both standalone Server and integrated OpenCode V2 composition.
• 🟡 (16:34) User requested concise evidence with exact file paths, symbols, line ranges, and the exact migration-generation command; any read failure must be returned with its exact error rather than an empty result.
• 🔴 (16:34) User directed not to investigate or design attempt lifecycle, recovery events, runner changes, or tests because the parent is handling those areas.
• 🔴 (16:34) User-provided repository guidance states: replace <platform> with the applicable platform, with examples darwin-arm64 and linux-x64, when running ./packages/opencode/dist/opencode-<platform>/bin/opencode; source is /home/byk/Code/opencode/CONTRIBUTING.md:56-70.
• 🟡 (16:34) Assistant reported that the required repo-setup skill was unavailable, so it read repository guidance directly while retaining read-only scope.
• 🟡 (16:34) Core package migration entry points are defined in /home/byk/Code/opencode/packages/core/package.json:8-13: script "db": "bun drizzle-kit" and script "migration": "bun run script/migration.ts"; Core requires Bun tooling and uses drizzle-kit.
• 🟡 (16:35) Current Core SQLite schema pattern is Drizzle sqliteTable(...) declarations in /home/byk/Code/opencode/packages/core/src/session/sql.ts: SessionTable at :22-66, MessageTable at :68-80, PartTable at :82-98, TodoTable at :100-117, SessionMessageTable at :119-138, SessionInputTable at :140-166, and SessionContextEpochTable at :168-176. Tables use typed text()/integer() fields, foreign-key .references(...), Timestamps, and index declarations in the third sqliteTable argument where needed.
• 🟡 (16:35) Drizzle discovers Core schema files through schema: ["./src/**/*.sql.ts", "./src/**/sql.ts"] with dialect: "sqlite" in /home/byk/Code/opencode/packages/core/drizzle.config.ts:1-10; therefore a Core table is added in a matching sql.ts or *.sql.ts source file.
• 🟡 (16:35) /home/byk/Code/opencode/packages/core/script/migration.ts:10-21 defines migration artifacts and CLI options: baseline snapshot packages/core/schema.json, generated migration directory packages/core/src/database/migration, registry packages/core/src/database/migration.gen.ts, schema packages/core/src/database/schema.gen.ts, and flags --check plus --name.
• 🟡 (16:35) Core migration generation flow in /home/byk/Code/opencode/packages/core/script/migration.ts:28-61 copies packages/core/schema.json into a temporary incremental baseline, invokes Drizzle, requires at most one generated migration, writes it as packages/core/src/database/migration/<name>.ts, updates packages/core/schema.json, regenerates packages/core/src/database/schema.gen.ts, and regenerates packages/core/src/database/migration.gen.ts.
• 🟡 (16:35) The migration script’s underlying exact Drizzle invocation is bun drizzle-kit generate --config ${config} ${name ? ["--name", name] : []}, run with cwd packages/core, at /home/byk/Code/opencode/packages/core/script/migration.ts:94-106. Repository stale-artifact errors prescribe bun script/migration.ts from packages/core at :64-88; the package-level entry point is bun run migration from packages/core, with optional script argument --name.
• 🟡 (16:35) Generated migrations are rendered as TypeScript objects satisfying DatabaseMigration.Migration, with id and up(tx) calling tx.run(...), in /home/byk/Code/opencode/packages/core/script/migration.ts:127-173; generated migration modules are dynamically imported into the registry by renderRegistry(...) at :187-195.
• 🟡 (16:35) Standalone Server process-global node composition pattern is /home/byk/Code/opencode/packages/server/src/routes.ts:26-37: add the Core node to the module-level const applicationServices = LayerNode.group([...]). Current members are Database.node, EventV2.node, httpClient, ToolOutputStore.cleanupNode, SessionV2.node, PermissionSaved.node, PtyTicket.node, Credential.node, PtyEnvironment.node, and LocationServiceMap.node.
• 🟡 (16:35) Standalone Server builds that process-global graph once in makeRoutes(...) using AppNodeBuilder.build(applicationServices, [[SessionExecution.node, SessionExecutionLocal.node]]) at /home/byk/Code/opencode/packages/server/src/routes.ts:51-62, then provides the resulting serviceLayer to the HTTP API layer.
• 🟡 (16:35) Integrated OpenCode V2 composition is in /home/byk/Code/opencode/packages/opencode/src/server/routes/instance/httpapi/server.ts: module-level const app = LayerNode.group([...]) begins at :212; createRoutes(...) begins at :271; V2 route composition supplies AppNodeBuilderV1.build(SessionV2.node, [..., [SessionExecution.node, SessionExecutionLocal.node], ...]) at :298-303, supplies locationServiceMapV2 at :304, and supplies the process-global application graph with AppNodeBuilderV1.build(app) at :306.
• 🔴 (16:36) User-provided repository source comment states that OpenApi.fromApi is deferred until /doc is requested so processes that never serve it, including CLI processes and scripts, do not pay its cost at module load; source is /home/byk/Code/opencode/packages/opencode/src/server/routes/instance/httpapi/server.ts:183-184.