Summary

• move Memory Core dreaming runtime state from legacy .dreams/*.json sidecars into SQLite-backed plugin state
• add doctor migration for persistent daily/session/short-term/phase state while leaving transient lock/cache state behind
• update doctor/control stats, REM harness facade wiring, repair paths, and tests to use the canonical SQLite state
• include a narrow ACPX doctor type-guard fix so the extension typecheck lane stays green on current main

Verification

• pnpm exec oxfmt --check src/memory-host-sdk/dreaming.ts extensions/memory-core/doctor-contract-api.ts extensions/memory-core/doctor-contract-api.test.ts
• pnpm tsgo:core
• pnpm tsgo:extensions
• node scripts/run-vitest.mjs src/memory-host-sdk/dreaming.test.ts src/plugin-sdk/memory-core-bundled-runtime.test.ts src/plugin-sdk/memory-core-engine-runtime.test.ts src/gateway/server-methods/doctor.test.ts extensions/memory-core/src/short-term-promotion.test.ts extensions/memory-core/src/dreaming-phases.test.ts extensions/memory-core/src/dreaming-repair.test.ts extensions/memory-core/src/dreaming.test.ts extensions/memory-core/src/cli.test.ts extensions/memory-core/src/tools.citations.test.ts extensions/memory-core/doctor-contract-api.test.ts
• /Users/steipete/Projects/agent-scripts/skills/autoreview/scripts/autoreview --mode local clean, no accepted/actionable findings