Dashboard Overview

Using the Revvhire_db tool, fetch all candidates from the candidate_evaluations table where the role is "[ROLE_NAME]". Analyze each candidate based on their overall_score, skills_score, experience_score, education_score, and market_score. Return a ranked shortlist of the top 5 candidates with: - Name, Email, Overall Score - Key Strengths (from skills_note, experience_note) - Key Concerns - Recommendation Also flag any candidates with score above 8.0 as Priority Picks.

Using the Revvhire_db tool, fetch ALL candidates from the candidate_evaluations table. Provide a full pipeline analysis: 1. Total candidates by role (sorted by count) 2. Average score per role 3. Top 3 candidates overall (highest overall_score) 4. Candidates with status "Pending" that have score > 7.0 — these need urgent review 5. Any red flags: candidates with recommendation containing negative keywords Format the output in clear sections with emojis.

Using the Revvhire_db tool, find the candidate named "[CANDIDATE_NAME]" in candidate_evaluations. Provide a comprehensive evaluation report: - Overall Score: [score] / 10 - Skill Assessment: [skills_score] — [skills_note] - Experience Assessment: [experience_score] — [experience_note] - Education Assessment: [education_score] — [education_note] - Market Fit: [market_score] — [market_note] - AI Recommendation: [recommendation] - Final Verdict: [final_verdict] - Hiring Decision: Should we proceed to interview? Give a clear YES/NO with justification.

Using the Revvhire_db tool, fetch all candidates from candidate_evaluations. Generate a weekly hiring report for the Revv Growth team: 📊 SUMMARY - Total applications received - Total evaluated, passed, rejected, hired 🏆 TOP CANDIDATES THIS WEEK - List top 5 by overall_score (include name, role, score, verdict) ⚡ ACTION REQUIRED - Candidates with status Pending for more than expected (flag them) - Candidates with score > 8 waiting for final decision 📈 ROLE BREAKDOWN - Table: Role | Applied | Passed | Rejected | Hired Format this as a clean, professional report I can share with the leadership team.