🏫 School Scout — Architecture

School evaluation research service. SvelteKit dashboard + Deno + Supabase + Ollama (Mac Mini) + web scraping.

🛠️ Tech Stack

Component	Technology	Why
Frontend	SvelteKit	Report viewer, comparison matrix, school search
Backend	Deno 2	Research agent, web scraping, PDF generation
Database	Supabase (PostgreSQL)	Schools DB, reports, user accounts
AI Research	Ollama (Mac Mini)	Synthesizes cultural fit from reviews
Scraping	Cheerio + Playwright	School websites, Niche, GreatSchools, state databases
Payments	Stripe	One-time purchases and subscriptions
PDF	Puppeteer	Generate formatted PDF reports

schools
id	uuid
name	varchar(255)
location	varchar(255)
type	enum('private','charter','public')
grades	varchar(50)	K-5, 6-8, 9-12
tuition	integer	Annual tuition in dollars
academic_data_json	jsonb	SAT/ACT averages, college placement
teacher_data_json	jsonb	Turnover rate, tenure, credentials
ratios_json	jsonb	Student-teacher ratio, class sizes
programs_json	jsonb	STEM, arts, languages, special programs
cultural_score	integer (0–100)	AI-calculated cultural fit score
last_researched_at	timestamp

1. Academic Outcomes

Scrape school website + Niche + GreatSchools + state DOE database for test scores, college placement, AP pass rates.

2. Teacher & Staff Data

State Department of Education has teacher turnover data publicly available. Compile tenure, credentials, awards.

3. Cultural Synthesis

Aggregate parent reviews from Niche, Google, Facebook. Ollama synthesizes into cultural fit score + themes.

4. Comparison Matrix

Side-by-side comparison of all schools across 15 metrics. AI-generated summary of tradeoffs.