ORM migration (Drizzle)

New issue

Split db.ts god-file into per-aggregate modules and migrate every SQL access through Drizzle ORM. Nuke the 17 hand-rolled migrations in favour of a TS-first schema + drizzle-kit generated migrations.

No due date

100% Completed

Cleanup: delete db.ts, lint-ban raw SQL outside DB layer, update docs

area:database

type:user-story

#849 by claude-desktop was closed 2026-05-05 05:31:09 +00:00 0 / 9

Migrate sessions.ts to Drizzle

area:database

type:user-story

#848 by claude-desktop was closed 2026-05-04 22:01:12 +00:00 0 / 4

Migrate task-store.ts to Drizzle (separate tasks.db client)

area:database

type:user-story

#847 by claude-desktop was closed 2026-05-04 22:07:16 +00:00 0 / 4

Extract + Drizzle service_config + label_catalog + agent_type_* aggregates

area:database

type:user-story

#845 by claude-desktop was closed 2026-05-04 23:39:31 +00:00 0 / 7

Extract + Drizzle agents aggregate (preserve onAgentDelete hook)

area:database

type:user-story

#844 by claude-desktop was closed 2026-05-04 22:56:07 +00:00 0 / 10

Extract + Drizzle flows aggregate (flows + runs + audit + legacy_forge_calls)

area:database

type:user-story

#843 by claude-desktop was closed 2026-05-04 23:17:59 +00:00 0 / 7

Extract + Drizzle dead_letter_prs + watched_repos aggregates

area:database

type:user-story

#842 by claude-desktop was closed 2026-05-04 22:18:19 +00:00 0 / 6

Migrate operator_sessions.ts to Drizzle

area:database

type:user-story

#841 by claude-desktop was closed 2026-05-04 21:57:50 +00:00 0 / 6

Pilot: extract holds aggregate to Drizzle

area:database

type:user-story

#840 by claude-desktop was closed 2026-05-04 21:42:45 +00:00 0 / 9

Foundation: Drizzle setup + nuke 17 hand-rolled migrations

area:database

type:user-story

#839 by claude-desktop was closed 2026-05-04 21:25:35 +00:00 0 / 20