mosaic/stack
1
0
Fork 0
Code Issues 10 Pull Requests Actions Packages Projects Releases 2 Wiki Activity

PostgreSQL 17 + pgvector schema #2

New Issue
Closed
opened 2026-01-28 19:02:32 +00:00 by jason.woltje · 0 comments
jason.woltje commented 2026-01-28 19:02:32 +00:00
Owner
Copy Link

Design and implement the PostgreSQL 17 database schema with pgvector extension.

Tables:

  • users (id, email, name, auth_provider_id, preferences, created_at, updated_at)
  • workspaces (id, name, owner_id, settings, created_at, updated_at)
  • workspace_members (workspace_id, user_id, role, joined_at)
  • tasks (id, workspace_id, title, description, status, priority, due_date, assignee_id, ...)
  • events (id, workspace_id, title, description, start_time, end_time, recurrence, ...)
  • projects (id, workspace_id, name, description, start_date, end_date, status, ...)
  • activity_log (id, workspace_id, user_id, action, entity_type, entity_id, details, ...)
  • memory_embeddings (id, workspace_id, content, embedding vector(1536), ...)

Requirements:

  • pgvector extension enabled
  • Proper indexes for common queries
  • Support for RLS (prepared for M2)
  • Migration scripts
Design and implement the PostgreSQL 17 database schema with pgvector extension. **Tables:** - users (id, email, name, auth_provider_id, preferences, created_at, updated_at) - workspaces (id, name, owner_id, settings, created_at, updated_at) - workspace_members (workspace_id, user_id, role, joined_at) - tasks (id, workspace_id, title, description, status, priority, due_date, assignee_id, ...) - events (id, workspace_id, title, description, start_time, end_time, recurrence, ...) - projects (id, workspace_id, name, description, start_date, end_date, status, ...) - activity_log (id, workspace_id, user_id, action, entity_type, entity_id, details, ...) - memory_embeddings (id, workspace_id, content, embedding vector(1536), ...) **Requirements:** - pgvector extension enabled - Proper indexes for common queries - Support for RLS (prepared for M2) - Migration scripts
jason.woltje added this to the M1-Foundation (0.0.1) milestone 2026-01-28 19:02:32 +00:00
jason.woltje added the databasep0 labels 2026-01-28 19:02:32 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
ai
AI/LLM integration
 api
Backend/API work
 api
auth
Authentication
 database
database
Database/schema work
 devops
Docker/deployment
 docs
Documentation
 frontend
graph
knowledge-module
migration
Data migration
 orchestrator
Orchestrator service (apps/orchestrator/)
 p0
Critical priority
 p1
High priority
 p2
Medium priority
 p3
Low priority
 performance
Performance work
 phase-1
phase-2
phase-3
phase-4
phase-5
plugin
MoltBot plugin work
 search
security
Security-related
 setup
Initial setup
 testing
Testing/QA
 web
Frontend work
No Label database p0
Milestone
No items
No Milestone M1-Foundation (0.0.1)
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: mosaic/stack#2
Delete Branch "%!s()"

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?