Why it is worth attention

It bridges ChatGPT reports with spaced-repetition review and grammar drills, all in a privacy-focused PWA with Supabase-backed authentication and Row-Level Security.

Who it is for

English learners who practice with ChatGPT voice conversations
Self-directed learners looking for structured vocabulary and grammar tracking
Developers interested in integrating AI (Gemini) with Supabase Edge Functions for language learning tools

Use cases

Import and review personalized speaking feedback from ChatGPT sessions
Track vocabulary, sentence patterns, and corrections with spaced repetition
Generate targeted grammar practice exercises based on learner content
Use as an installable mobile-first PWA for on-the-go review

Strengths

Mobile-first PWA enables seamless access without app store installation
Imports structured JSON reports from ChatGPT for tailored learning
Combines spaced review with AI-generated grammar practice for holistic improvement
Security-conscious design: Supabase RLS, no API keys in client, Git-ignored secrets

Considerations

Requires users to export ChatGPT reports in a specific LINGOTRACE_REPORT_V1 format
Local setup demands manual configuration of Supabase, Gemini API, and Edge Function deployment
Grammar practice generation depends on Gemini API availability and may fall back to deterministic exercises

README quick start

LingoTrace

在线体验： https://lingo-trace.vercel.app/

配套指令： LingoTrace 英语口语项目指令 V2

LingoTrace is a mobile-first English learning tracker for importing structured ChatGPT speaking reports, reviewing vocabulary and sentence patterns, tracking corrections, and generating targeted grammar practice.

Features

Google sign-in through Supabase Auth
Import and merge LINGOTRACE_REPORT_V1 JSON reports
Vocabulary, sentence-pattern, and correction libraries
Spaced-review state and lightweight practice tracking
Gemini-generated grammar practice with a deterministic local fallback
Installable PWA interface

Tech stack

React, TypeScript, Vite and Tailwind CSS
Supabase Auth, Postgres, Row Level Security and Edge Functions
Gemini API, called only from a Supabase Edge Function

Local setup

Requirements: Node.js and pnpm.

Install dependencies:
```
pnpm install
```

Copy .env.example to .env.local and provide your own Supabase project values:

VITE_SUPABASE_URL="https://your-project.supabase.co"
VITE_SUPABASE_PUBLISHABLE_KEY="sb_publishable_your_key"

Apply the SQL files in supabase/migrations/ to your Supabase project in filename order.
Add GEMINI_API_KEY to Supabase Edge Function Secrets. Never place this key in a VITE_ variable or commit it to Git.

Deploy the Edge Function:

supabase functions deploy generate-grammar-practice

Start the app:
```
pnpm dev
```

Security notes

.env.local and other .env* files are ignored by Git; only .env.example is tracked.
The Supabase publishable key is intended for browser use. Database access is protected by the included owner-only Row Level Security policies.
Never commit a Supabase service-role key, Gemini API key, access token, user export, or real conversation JSON.

Related repositories

Similar projects matched by category, topics, and programming language.

TanStack

Featured

router

TanStack Router is a type-safe, data-driven React router with built-in caching, prefetching, and nested layouts, while TanStack Start extends it into a full-stack SSR framework.

Web DevelopmentFrontend Frameworks

14,861

vercel-labs

Featured

scriptc

scriptc compiles ordinary TypeScript into small, fast native executables without needing Node.js, V8, or any JavaScript runtime in the binary.

Developer ToolsCode Quality & Build

1,985

Jakubantalik

Featured

thinking-orbs

A React component library that renders six hand-tuned animated thought orb loading indicators on a plain 2D canvas, with two purpose-tuned sizes and automatic theme detection for AI and agent UIs.

AI & Machine LearningAI Agents

1,191