mosaicstack/stack
1
0
Fork 0
Code Issues 13 Pull Requests Actions Packages Projects Releases 11 Wiki Activity

feat(db): @mosaic/db — Drizzle schema, PG connection, migrations #67

Merged
jason.woltje merged 1 commits from feat/p0-003-db-package into main 2026-03-13 02:17:19 +00:00
Conversation 0 Commits 1 Files Changed 13 +2451 -5
jason.woltje commented 2026-03-13 02:17:13 +00:00
Owner
Copy Link

Summary

  • Implements P0-003: shared database package with Drizzle ORM
  • 13 tables: auth (BetterAuth-compatible), brain entities, chat
  • createDb() factory with pool cleanup, runMigrations() with try/finally
  • Full FK relationships and indexes on query-hot columns
  • drizzle-kit generate/push/migrate/studio scripts

Verification

  • Schema pushed to PG 17, all 13 tables created
  • CRUD round-trip tested (insert + select + delete user)
  • Independent code review passed, findings remediated
  • All monorepo gates green (typecheck, lint, format)

Closes #3

## Summary - Implements P0-003: shared database package with Drizzle ORM - 13 tables: auth (BetterAuth-compatible), brain entities, chat - createDb() factory with pool cleanup, runMigrations() with try/finally - Full FK relationships and indexes on query-hot columns - drizzle-kit generate/push/migrate/studio scripts ## Verification - Schema pushed to PG 17, all 13 tables created - CRUD round-trip tested (insert + select + delete user) - Independent code review passed, findings remediated - All monorepo gates green (typecheck, lint, format) Closes #3
jason.woltje added 1 commit 2026-03-13 02:17:13 +00:00
feat(db): @mosaic/db — Drizzle schema, PG connection, migrations de44a5cd43 
Implements P0-003: shared database package with Drizzle ORM.

Schema: 13 tables across 3 domains:
- Auth (BetterAuth-compatible): users, sessions, accounts, verifications
- Brain: projects, missions, tasks, events, agents, tickets, appreciations
- Chat: conversations, messages

Features:
- createDb() factory with pool cleanup via DbHandle.close()
- runMigrations() with try/finally for connection safety
- drizzle-kit config for generate/push/migrate/studio
- Full FK relationships and indexes on query-hot columns
- ESM package with NodeNext resolution

Verified: schema pushed to PG 17, CRUD round-trip tested.

Closes #3

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
jason.woltje merged commit 2b1723e898 into main 2026-03-13 02:17:19 +00:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
jason.woltje
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: mosaicstack/stack#67
Delete Branch "feat/p0-003-db-package"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?