Overview

Generate time-blocked, structured lesson plans by pulling real student data from Supabase (song repertoire, lesson history, notes) and synthesizing it via the AI layer into an actionable session plan.

Usage

When invoked, gather these inputs:

Student -- name or ID (query profiles table)
Session duration -- 30, 45, or 60 minutes (default: 45)
Focus area (optional) -- technique, repertoire, theory, performance prep

Then execute:

Step 1: Fetch Student Data

# Get student profile
mcp__supabase__execute_sql("SELECT * FROM profiles WHERE id = '<student_id>' OR email ILIKE '%<name>%'")

# Get song repertoire with statuses
mcp__supabase__execute_sql("
  SELECT s.id, s.title, s.author, s.level, s.key, s.chords, sr.status, sr.updated_at
  FROM songs s
  JOIN student_repertoire sr ON sr.song_id = s.id
  WHERE sr.student_id = '<student_id>'
  ORDER BY sr.updated_at DESC
")

# Get recent lessons (last 5)
mcp__supabase__execute_sql("
  SELECT l.id, l.lesson_number, l.date, l.notes, l.status,
         array_agg(s.title) as songs_covered
  FROM lessons l
  LEFT JOIN lesson_songs ls ON ls.lesson_id = l.id
  LEFT JOIN songs s ON s.id = ls.song_id
  WHERE l.student_id = '<student_id>'
  GROUP BY l.id
  ORDER BY l.date DESC LIMIT 5
")

# Get pending assignments
mcp__supabase__execute_sql("
  SELECT a.id, a.title, a.description, a.due_date, a.status
  FROM assignments a
  WHERE a.student_id = '<student_id>' AND a.status != 'completed'
  ORDER BY a.due_date
")

Usage

When invoked, gather these inputs:

Student -- name or ID (query profiles table)

Session duration -- 30, 45, or 60 minutes (default: 45)

Focus area (optional) -- technique, repertoire, theory, performance prep

Then execute:

Step 1: Fetch Student Data

# Get student profile mcp__supabase__execute_sql("SELECT * FROM profiles WHERE id = '<student_id>' OR email ILIKE '%<name>%'") # Get song repertoire with statuses mcp__supabase__execute_sql(" SELECT s.id, s.title, s.author, s.level, s.key, s.chords, sr.status, sr.updated_at FROM songs s JOIN student_repertoire sr ON sr.song_id = s.id WHERE sr.student_id = '<student_id>' ORDER BY sr.updated_at DESC ") # Get recent lessons (last 5) mcp__supabase__execute_sql(" SELECT l.id, l.lesson_number, l.date, l.notes, l.status, array_agg(s.title) as songs_covered FROM lessons l LEFT JOIN lesson_songs ls ON ls.lesson_id = l.id LEFT JOIN songs s ON s.id = ls.song_id WHERE l.student_id = '<student_id>' GROUP BY l.id ORDER BY l.date DESC LIMIT 5 ") # Get pending assignments mcp__supabase__execute_sql(" SELECT a.id, a.title, a.description, a.due_date, a.status FROM assignments a WHERE a.student_id = '<student_id>' AND a.status != 'completed' ORDER BY a.due_date ")

Section	30 min	45 min	60 min
Warm-up	3 min	5 min	5 min
Technique	5 min	10 min	15 min
Song work	15 min	20 min	25 min
New material	4 min	5 min	10 min
Wrap-up & homework	3 min	5 min	5 min

Lesson Plan Generator

Overview

Usage

Step 1: Fetch Student Data

Lesson Plan Generator

Overview

Usage

Step 1: Fetch Student Data

Step 2: Determine Skill Level

Step 3: Generate Plan

Step 4: Output Formatted Plan

Time Allocations

Skill Level Guidelines

Beginner

Intermediate

Advanced

Song Priority Order

AI Integration

Output Format

Error Handling

Examples

Key Files

Update Skills

Eval Harness

Ecc Tools Cost Audit

Code Tour

Rules Distill

Design System