Yield Forecasting Email Alerts (Target Triggers)

[edehvictor]

📝 Description

Users want to know when a vault hits a specific APY so they can move their funds. We need a system where users can set custom triggers (e.g., "Email me if USDC Vault APY goes above 10%").

🎯 Acceptance Criteria

• Create a database schema for user_alerts (user_id, vault_id, condition, threshold_value).
• Build a UI modal allowing users to create, view, and delete these alerts.
• Modify the backend TVL/APY indexing script to evaluate all active alerts whenever a new APY is calculated.
• Dispatch an email via Resend/SendGrid if the condition is met, and mark the alert as "triggered" so it doesn't spam the user repeatedly.

🛠 Technical Details

• Stack: React, Node.js, PostgreSQL, Email API.
• Location: /backend/services/alerts/
• Security: Add a maximum cap on active alerts per user to prevent database bloat.

⏱ Complexity & Scope

• Estimated Time: 2-3 weeks.
• Drips Complexity: High (200 points) - Event-driven backend logic and full-stack UI.

📋 Guidelines for Submission

• Minimum 90 percent test coverage required.
• Clear NatSpec-style documentation must be added to public contract functions.
• Timeframe for completion: 2 Wave cycles.

[GazzyLee]

@GazzyLee has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

hello, I can get this done under 45 mintes, please assign.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @GazzyLee to this issue.