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

Ideas / Brain Dumps (quick capture with semantic search) #38

New Issue
Closed
opened 2026-01-29 18:21:48 +00:00 by jason.woltje · 1 comment
jason.woltje commented 2026-01-29 18:21:48 +00:00
Owner
Copy Link

Overview

Add an Ideas model for brain dump capture with semantic search via pgvector.

Background

Brain dumps are sacred. Nothing gets lost unless explicitly requested. This supports ADHD-friendly capture where:

  1. Capture everything first
  2. Organize and connect after
  3. Challenge and sanity-check AFTER dumping completes

Requirements

Prisma Schema

model Idea {
  id          String   @id @default(uuid()) @db.Uuid
  workspaceId String   @map("workspace_id") @db.Uuid
  domainId    String?  @map("domain_id") @db.Uuid
  projectId   String?  @map("project_id") @db.Uuid
  
  title       String?
  content     String   @db.Text  // The brain dump
  
  status      IdeaStatus @default(CAPTURED)
  priority    TaskPriority @default(MEDIUM)
  
  category    String?
  tags        String[]
  
  metadata    Json     @default("{}")
  
  // Embedding for semantic search (pgvector)
  embedding   Unsupported("vector(1536)")?
  
  createdBy   String   @map("creator_id") @db.Uuid
  createdAt   DateTime @default(now()) @map("created_at") @db.Timestamptz
  updatedAt   DateTime @updatedAt @map("updated_at") @db.Timestamptz
  
  // Relations
  workspace   Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  domain      Domain?   @relation(fields: [domainId], references: [id], onDelete: SetNull)
  project     Project?  @relation(fields: [projectId], references: [id], onDelete: SetNull)
  creator     User      @relation(fields: [createdBy], references: [id], onDelete: Cascade)
  
  @@map("ideas")
}

enum IdeaStatus {
  CAPTURED     // Just captured, unprocessed
  PROCESSING   // Being organized/analyzed
  ACTIONABLE   // Converted to task/project
  ARCHIVED     // Kept for reference
  DISCARDED    // Explicitly removed
}

API Endpoints

  • GET /api/ideas — List ideas (with filters)
  • POST /api/ideas — Quick capture (minimal fields required)
  • PATCH /api/ideas/:id — Update idea
  • DELETE /api/ideas/:id — Soft delete
  • POST /api/ideas/search — Semantic search via embedding

UI

  • Quick Capture Widget — Minimal friction input
  • Ideas List — Grouped by status/domain
  • Semantic Search — "Find ideas about..."
  • Convert to Task — One-click conversion

Acceptance Criteria

  • Prisma schema with migration
  • API endpoints with tests
  • Quick capture endpoint (title optional, content required)
  • Embedding generation on create/update (Ollama integration)
  • Semantic search endpoint
  • Quick Capture widget in HUD
  • Convert idea to task action
## Overview Add an **Ideas** model for brain dump capture with semantic search via pgvector. ## Background Brain dumps are sacred. Nothing gets lost unless explicitly requested. This supports ADHD-friendly capture where: 1. Capture everything first 2. Organize and connect after 3. Challenge and sanity-check AFTER dumping completes ## Requirements ### Prisma Schema ```prisma model Idea { id String @id @default(uuid()) @db.Uuid workspaceId String @map("workspace_id") @db.Uuid domainId String? @map("domain_id") @db.Uuid projectId String? @map("project_id") @db.Uuid title String? content String @db.Text // The brain dump status IdeaStatus @default(CAPTURED) priority TaskPriority @default(MEDIUM) category String? tags String[] metadata Json @default("{}") // Embedding for semantic search (pgvector) embedding Unsupported("vector(1536)")? createdBy String @map("creator_id") @db.Uuid createdAt DateTime @default(now()) @map("created_at") @db.Timestamptz updatedAt DateTime @updatedAt @map("updated_at") @db.Timestamptz // Relations workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) domain Domain? @relation(fields: [domainId], references: [id], onDelete: SetNull) project Project? @relation(fields: [projectId], references: [id], onDelete: SetNull) creator User @relation(fields: [createdBy], references: [id], onDelete: Cascade) @@map("ideas") } enum IdeaStatus { CAPTURED // Just captured, unprocessed PROCESSING // Being organized/analyzed ACTIONABLE // Converted to task/project ARCHIVED // Kept for reference DISCARDED // Explicitly removed } ``` ### API Endpoints - `GET /api/ideas` — List ideas (with filters) - `POST /api/ideas` — Quick capture (minimal fields required) - `PATCH /api/ideas/:id` — Update idea - `DELETE /api/ideas/:id` — Soft delete - `POST /api/ideas/search` — Semantic search via embedding ### UI - **Quick Capture Widget** — Minimal friction input - **Ideas List** — Grouped by status/domain - **Semantic Search** — "Find ideas about..." - **Convert to Task** — One-click conversion ## Acceptance Criteria - [ ] Prisma schema with migration - [ ] API endpoints with tests - [ ] Quick capture endpoint (title optional, content required) - [ ] Embedding generation on create/update (Ollama integration) - [ ] Semantic search endpoint - [ ] Quick Capture widget in HUD - [ ] Convert idea to task action
jason.woltje added this to the M3-Features (0.0.3) milestone 2026-01-29 18:25:32 +00:00
jason.woltje commented 2026-01-29 22:00:51 +00:00
Author
Owner
Copy Link

Absorbed by Knowledge Module.

The Knowledge Module provides:

  • Quick capture via entry creation
  • Semantic search for retrieval
  • Wiki-style linking for connections

See: #81 (Epic), docs/design/knowledge-module.md

Absorbed by **Knowledge Module**. The Knowledge Module provides: - Quick capture via entry creation - Semantic search for retrieval - Wiki-style linking for connections See: #81 (Epic), `docs/design/knowledge-module.md`
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
Milestone
No items
No Milestone M3-Features (0.0.3)
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#38
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?