v0.2.0 — English-canonical + Supabase CLI migrations
Rename pass. The project is now English-canonical from the database up through the MCP tool names, and migrations moved to supabase/migrations/ so the Supabase CLI tracks them properly.
If you're upgrading from v0.1.0, schema changes are required — git pull alone won't fix your DB. See the upgrade block below.
Breaking
- MCP tools renamed.
list_klausuren→list_exams,update_klausur→update_exam.upsert_schedule_slot→create_schedule_slot(pure create; useupdate_schedule_slotto patch).now_berlinremoved — usenow_here. Any cached tool lists in Claude.ai / Claude Code need re-fetching. - DB schema. Table
klausuren→exams. Columnscourses.klausur_weight/klausur_retries→exam_weight/exam_retries. - Enum values. Slot / lecture / topic / deliverable kinds normalised from German to English (
lecture|exercise|tutorial|lab,submission|project|lab|block, …). Legacy German values are still accepted at the API boundary and normalised — existing MCP integrations keep working. - Migration location.
db/migrations/→supabase/migrations/with timestamp-based filenames.
Added
- Single-file README with a same-page
<details name="lang">toggle — click 🇬🇧 English or 🇩🇪 Deutsch, the other collapses. - New migration
20260420000001_english_canonical_kinds.sqlthat normalises existing data on upgrade. - FastMCP server-level
instructions— domain mental model + tool-picking guidance injected oninitialize.
Changed
- Every MCP tool description rewritten with "when to use / when NOT to use" disambiguation. Tool count 46 → 44.
- UI: hardcoded German strings replaced with English everywhere (
Klausuren→Exams, slot-kind selects, etc.). INSTALL.md§4 now documentssupabase db pushas the primary flow with an upgrade path for existing DBs.
Upgrade from v0.1.0
git pull origin main
npx supabase link --project-ref YOUR-PROJECT-REF
# If you applied 0001–0004 via the SQL editor before, mark them applied first:
npx supabase migration repair --status applied 20260101000001 20260115000001 20260201000001 20260301000001
npx supabase db push # applies the English-canonical migrationThen rebuild the frontend (cd web && pnpm install && pnpm build) and redeploy.
Full changelog: https://github.com/AmmarSaleh50/study-dashboard/blob/main/CHANGELOG.md