v0.10.1: refined Gamma prompt with slide-by-slide instructions from a…

…ctual PDF content

v0.10.0-docs-update: PRD rewritten for Bishop State focus, Gamma slid…

…e deck prompt added

v0.9.0-vercel-deploy: hosted Supabase + Vercel deployment, deploy scr…

…ipt, Next.js CVE fix, ML pipeline fixes

feat: SQL Query Interface UX — result table, chart layout, tooltips, …

…prompt history (#62)

* fix: quote Retention column in KPIs query and coerce pg string counts to numbers for Recharts

* fix: use exact case-sensitive column names in LLM schema prompt to prevent Postgres quoting errors

* fix: chart ratios, tooltip overflow, and raw data table below viz

* feat: add POST /api/query-history for server-side audit logging

Appends JSONL entries to logs/query-history.jsonl on each POST.
Returns 400 on missing/invalid fields, 500 on write errors.
Adds logs/ to .gitignore so log file is not committed.

* feat: add prompt history panel with localStorage persistence and re-run

* fix: bar chart colors, tooltip contrast, bar width, remove API Query String field

- Replace hsl(var(--x)) with var(--x) throughout — CSS vars use oklch() not HSL,
  so the hsl() wrapper produced invalid colors (black bars, broken tooltips)
- Extract shared TOOLTIP_STYLE constant with popover-foreground color for contrast
- Add maxBarSize={48} to Bar to prevent bars spanning full category width
- Remove 'API Query String' field from QueryPlanPanel

* fix: remove bar chart hover cursor background

feat: update methodology page — remove impl refs, add worked examples (…

…#60)

* fix: quote Retention column in KPIs query and coerce pg string counts to numbers for Recharts

* fix: use exact case-sensitive column names in LLM schema prompt to prevent Postgres quoting errors

* feat: update methodology page — remove impl refs, add worked examples

- Remove Script and Table header badges (internal details)
- Remove 'Data Source' section (table names, script paths not user-facing)
- Replace raw db field names in sub-score tables with plain English labels
- Remove input_features column reference from Transparency card
- Add 'Worked Examples' section with Maria T. (High, 0.699) and Jordan M. (Low, 0.386)
- Each example: inputs table, step-by-step sub-score math, color-coded final score

Closes #59

v0.6.0-readiness-engine: Readiness rule engine (PDP-aligned), methodo…

…logy docs, LiteLLM enrichment, frontend methodology page

v0.5.0-docs-cleanup: Documentation updated, KCTCS data files removed,…

… Docker migrated to Postgres (Tasks 10-12)

v0.4.0-frontend-rebrand: Frontend UI, dashboard API, and query API re…

…branded to Bishop State Community College (Tasks 7-9)

v0.3.0-postgres-migration: Python DB layer and Next.js migrated from …

…MariaDB/mysql2 to Postgres/psycopg2 (Tasks 4-6)

v0.2.0-bishop-state-data: Bishop State data added, synthetic data gen…

…eration, Supabase initialized