Feed Generator AI Assistant Enhancements & User-Customizable System Prompts

Peter Menegayrequested to merge
60-create-alternative-to-the-importance-proposition-for-users-to-view-priority-items-part2 into main

Summary

This MR introduces significant enhancements to the Feed Generator feature, including an AI-powered assistant for creating feed generators and user-customizable system prompts.

Key Features

AI-Assisted Feed Generator Builder

  • Added conversational AI assistant to help users create feed generator SQL queries and MDX templates
  • Preview feature to view/edit the full prompt before sending to Claude
  • Ability to load saved feed generators with conversation history
  • Error detection and AI-assisted fix suggestions
  • Improved prompt engineering for more consistent MDX output (2-line format, proper links)

User-Customizable System Prompts

  • Users can ask the AI to "record lessons learned" in the system prompt
  • Customizations are stored per-user in the database
  • "View System Prompt" button to inspect current prompt with customizations
  • Reset to default option available

Feed Management Improvements

  • Batch delete feature for feed-management page
  • Event-type dropdown filter on following page
  • Timeframe filter for Recent Events

Statistical Events

  • Extended statistical events to support tags (in addition to propositions)
  • Prototype capability for statistical feed/follow events

Bug Fixes

  • Fixed TEST QUERY failing when parameters (e.g., $tag_name$) are present
  • Fixed system prompt customizations not being sent to Claude
  • Fixed conversation scroll position when loading saved generators
  • Fixed bug where new feed generators were not showing events

Database Migrations

  • V082: Add AI custom events
  • V083: Add feed generator conversation history
  • V084: Allow parameterized duplicates in feed generators
  • V085: User AI prompt customizations table
  • V086: Extend statistical events for tags

Merge request reports