Postgres full-text search over counselling reports, ranked by relevance. Filter by school, grade, or report kind.
Aanya Iyer was engaged today. We explored their interest in data science, discussing pathway options at the intersection of curiosity and aptitude. Aanya Iyer surfaced stream selection between Science and Commerce as a s…
Met with parents of Harsh Bhatt (Grade 12). Discussion focused on engineering as a pathway and the family's view on balancing creative interests with stable career paths. Parents shared concern about return on investment…
Met with parents of Anika Subramanian (Grade 11). Discussion focused on design as a pathway and the family's view on balancing creative interests with stable career paths. Parents shared concern about return on investmen…
Krishna Subramanian completed the mock CET aptitude battery. Performance: Maths 77/100, Logical Reasoning 56/100, English 75/100. Time management appears strong; accuracy on data interpretation section is the gap. Recomm…
Compiled career review for Zara Menon based on assessment battery + 3 counselling sessions. Top pathway: data science (consistent across RIASEC, DAT V, and self-report interest). Family conversation flagged tension aroun…
Conducted Holland Code session with Ishita Banerjee. Top RIASEC dimensions: Realistic (46), Investigative (83), Artistic (60). The pattern suggests strong fit for analytical-creative pathways. Ishita Banerjee responded m…
Siddharth Kapoor completed the mock CET aptitude battery. Performance: Maths 83/100, Logical Reasoning 70/100, English 86/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommend…
Mira Krishnan completed the mock CET aptitude battery. Performance: Maths 58/100, Logical Reasoning 57/100, English 72/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommendati…
Ananya Bhatt completed the mock CET aptitude battery. Performance: Maths 82/100, Logical Reasoning 59/100, English 85/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommendatio…
Yash Bhatt was engaged today. We explored their interest in medicine, discussing pathway options at the intersection of curiosity and aptitude. Yash Bhatt surfaced time management between assessments and school as a stic…
Pranav Krishnan completed the mock CET aptitude battery. Performance: Maths 91/100, Logical Reasoning 81/100, English 72/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommenda…
Sneha Verma completed the mock CET aptitude battery. Performance: Maths 61/100, Logical Reasoning 79/100, English 91/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommendation…
Harsh Kapoor completed the mock CET aptitude battery. Performance: Maths 60/100, Logical Reasoning 90/100, English 65/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommendatio…
Met with parents of Yash Bhatt (Grade 12). Discussion focused on design as a pathway and the family's view on stream selection between Science and Commerce. Parents shared concern about return on investment given current…
Sneha Patel completed the mock CET aptitude battery. Performance: Maths 81/100, Logical Reasoning 90/100, English 72/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommendation…
Compiled career review for Anvi Patel based on assessment battery + 3 counselling sessions. Top pathway: design (consistent across RIASEC, DAT V, and self-report interest). Family conversation flagged tension around time…
Ananya Shetty completed the mock CET aptitude battery. Performance: Maths 90/100, Logical Reasoning 63/100, English 73/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommendati…
Compiled career review for Aditi Krishnan based on assessment battery + 3 counselling sessions. Top pathway: entrepreneurship (consistent across RIASEC, DAT V, and self-report interest). Family conversation flagged tensi…
Compiled career review for Vanya Singh based on assessment battery + 3 counselling sessions. Top pathway: civil services (consistent across RIASEC, DAT V, and self-report interest). Family conversation flagged tension ar…
Conducted Holland Code session with Yash Bhatt. Top RIASEC dimensions: Realistic (23), Investigative (41), Artistic (25). The pattern suggests strong fit for analytical-creative pathways. Yash Bhatt responded most positi…
Met with parents of Sneha Patel (Grade 12). Discussion focused on medicine as a pathway and the family's view on time management between assessments and school. Parents shared concern about return on investment given cur…
Conducted Holland Code session with Drishti Kumar. Top RIASEC dimensions: Realistic (68), Investigative (29), Artistic (35). The pattern suggests strong fit for analytical-creative pathways. Drishti Kumar responded most …
Conducted Holland Code session with Ananya Desai. Top RIASEC dimensions: Realistic (56), Investigative (28), Artistic (35). The pattern suggests strong fit for analytical-creative pathways. Ananya Desai responded most po…
Compiled career review for Aditya Banerjee based on assessment battery + 3 counselling sessions. Top pathway: data science (consistent across RIASEC, DAT V, and self-report interest). Family conversation flagged tension …
Conducted Holland Code session with Harsh Bhatt. Top RIASEC dimensions: Realistic (88), Investigative (59), Artistic (84). The pattern suggests strong fit for analytical-creative pathways. Harsh Bhatt responded most posi…
Vivaan Singh was engaged today. We explored their interest in design, discussing pathway options at the intersection of curiosity and aptitude. Vivaan Singh surfaced managing parental expectations as a sticking point. Co…
Arjun Rao was engaged today. We explored their interest in civil services, discussing pathway options at the intersection of curiosity and aptitude. Arjun Rao surfaced JEE preparation pressure as a sticking point. Counse…
Vivaan Chatterjee completed the mock CET aptitude battery. Performance: Maths 59/100, Logical Reasoning 73/100, English 87/100. Time management appears strong; accuracy on data interpretation section is the gap. Recommen…
Met with parents of Vanya Subramanian (Grade 9). Discussion focused on creative writing as a pathway and the family's view on managing parental expectations. Parents shared concern about return on investment given curren…
Compiled career review for Anika Subramanian based on assessment battery + 3 counselling sessions. Top pathway: entrepreneurship (consistent across RIASEC, DAT V, and self-report interest). Family conversation flagged te…
Every reports.text and counsellor_note is indexed by Postgres tsvector (english config). One GIN index, refreshed on insert.
Search box runs plainto_tsquery + ts_rank_cd. Filter chips (school, grade, RIASEC, kind) compose into the same SQL — no client-side filtering.
ts_headline wraps matches in <mark> tags so counsellors see the evidence in context.
Top 30 sorted by rank × recency. The aim is < 200 ms server-side on the full corpus, no Elasticsearch needed.