Files
cannaiq/backend/migrations/064_ai_settings.sql
Kelly f7081838cf feat: Add AI settings to database (provider/model configurable via UI)
- ai_provider and ai_model stored in settings table
- Editable via /settings page in admin UI
- API keys remain in env vars for security
- Falls back to env vars if settings not in DB

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2025-12-07 23:18:52 -07:00

9 lines
420 B
SQL

-- Add AI provider settings to settings table
-- API keys remain in environment variables for security
INSERT INTO settings (key, value, description, updated_at)
VALUES
('ai_provider', 'claude', 'AI provider for content generation (claude or openai)', NOW()),
('ai_model', '', 'AI model to use (leave blank for default: gpt-4o for openai, claude-sonnet-4-20250514 for claude)', NOW())
ON CONFLICT (key) DO NOTHING;