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

Add LlmProviderInstance Prisma Schema #128

New Issue
Closed
opened 2026-01-30 21:28:41 +00:00 by jason.woltje · 0 comments
jason.woltje commented 2026-01-30 21:28:41 +00:00
Owner
Copy Link

Create database schema for LLM provider instance configuration.

Objective: Add LlmProviderInstance model for database-backed configuration.

Tasks:

  • Add LlmProviderInstance model to schema.prisma
  • Define fields: id, provider_type, display_name, user_id, config, is_default, is_enabled
  • Add indexes for performance
  • Create migration
  • Run migration on dev database
  • Update Prisma client types

Schema Pattern:

  • System-level instances: user_id = NULL
  • User-level instances: user_id = UUID
  • JSON config field for provider-specific settings

Acceptance Criteria:

  • Migration runs successfully
  • Model accessible via Prisma client
  • Indexes created correctly
  • No data loss

Related: Epic #121, Phase 1 LLM Abstraction

Create database schema for LLM provider instance configuration. Objective: Add LlmProviderInstance model for database-backed configuration. Tasks: - Add LlmProviderInstance model to schema.prisma - Define fields: id, provider_type, display_name, user_id, config, is_default, is_enabled - Add indexes for performance - Create migration - Run migration on dev database - Update Prisma client types Schema Pattern: - System-level instances: user_id = NULL - User-level instances: user_id = UUID - JSON config field for provider-specific settings Acceptance Criteria: - Migration runs successfully - Model accessible via Prisma client - Indexes created correctly - No data loss Related: Epic #121, Phase 1 LLM Abstraction
jason.woltje added the databasedatabasep0phase-1 labels 2026-01-30 21:28:41 +00:00
jason.woltje added this to the M4-LLM (0.0.4) milestone 2026-01-30 23:40:48 +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 database p0 phase-1
Milestone
No items
No Milestone M4-LLM (0.0.4)
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#128
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?