📚 Issue #28 — Implement AI Assistant Query History

[vic-Gray]

Harvest Finance will add a Query History feature for the AI Assistant. Contributors will implement functionality that stores and displays previous questions and AI responses, allowing farmers to review past advice and make informed decisions.

This enhances the LLM-powered killer feature, making it more usable, trackable, and trustworthy.

Objectives

Store all AI Assistant queries and responses for each farmer

Display query history in the Farm Vault Dashboard

Allow farmers to search, filter, or revisit advice

Optional: export AI insights for record-keeping or sharing

Requirements
1️⃣ Backend

Store queries and responses in PostgreSQL / Supabase

Include timestamps, vault context, and seasonal data

Secure endpoints using JWT authentication

2️⃣ Frontend

Display query history as a scrollable list or card layout

Include search/filter options

Provide option to revisit or re-run queries

3️⃣ UI / UX

Green & white dashboard theme

Smooth animations for opening history items

Mobile-first, responsive design

Technical Suggestions

Frontend: React / Next.js, TailwindCSS, Framer Motion

Backend: NestJS, TypeORM / Supabase

Optional caching of responses for faster retrieval

Reuse Card and Badge components for consistency

Expected Outcome

Farmers can view all past AI queries and responses

History is organized, searchable, and visually intuitive

Integrates seamlessly with dashboard and AI Assistant

Acceptance Criteria

All queries and responses are stored accurately

History displays correctly in the dashboard

Search/filter works as intended

UI is responsive and visually consistent

[Timothy2025-20]

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

Hi maintainer, am a frontend engineer with years of experience. Pls I will really like to resolve this issue if assigned. Thank you

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

[drips-wave]

Congratulations, @Timothy2025-20! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on March 30, 2026.

🧑‍💻 @Timothy2025-20: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊