0
Total Alumni
0
Old Boys
0
Old Girls
0
With Occupation
0
House Recorded
0
Pending
🔍
| # | File # ⇅ | Name ⇅ | School | House | Class ⇅ | Occupation | Location | Status | Actions |
|---|
👤
Click a name
to view full profile
Pending Registrations
Alumni who submitted the public form. Verify file numbers before approving.
| School | File # | Name | House | Class | Submitted | Verification | Actions |
|---|
📬
No pending registrations.
Add New Alumni Record
Manually add a verified alumnus. File number will be validated.
New Alumni Record
All fields except First Name are optional but help build a richer directory
Identity
Starehe Details
Contact
Professional
Education
Social
Story
Advanced Search
Full-text search across all fields. Combine multiple criteria for precise results.
| # | File # | Name | School | House | Class | Occupation | University | Status | Actions |
|---|
Import & Export
Manage data in bulk. CSV exports include all fields.
⬇ Export to CSV
Download all alumni records as a spreadsheet-compatible CSV file including all fields.
⬆ Import from CSV
Bulk-import. Required header: firstName. All other columns optional: school, fileNumber, lastName, title, email1, email2, phone, kenyaPhone, classYear, house, occupation, location, region, university, degree, fieldOfStudy, gradYear, linkedin, twitter, facebook, memories, notes, status.
📄
Click to select CSV file
or drag & drop
📊 Database Statistics
Total records—
Old Boys—
Old Girls—
With house—
With email—
With occupation—
With university—
Pending submissions—
🔄 Reset Database
Restore all 316 original Starehe Boys alumni records. All changes, Girls records, and pending submissions will be permanently lost.
Admin Roles, Accounts & Passwords
Manage admin accounts, change passwords, and review role permissions. Only Super Admins can change passwords.
🔑
Change Admin Password
Passwords are stored in your browser. Connect Supabase for persistent server-side auth.
⚠️ Only Super Admins can change passwords.
Minimum 8 characters. Changes take effect immediately for this session.
Admin Accounts
| Username | Role | Password Status | Edit | Delete | Approve | Action |
|---|
💡 Default password for all accounts: starehe2024. Changed passwords are saved in your browser and reset if you clear browser data. Connect Supabase for permanent server-side passwords.
Role Permissions Reference
👑 Super Admin
Accounts: admin · oss
✅ View all ✅ Edit ✅ Delete ✅ Approve
✅ Change passwords ✅ All settings
✅ Change passwords ✅ All settings
✏️ Editor
Account: editor
✅ View all ✅ Edit records ❌ Cannot delete
❌ Cannot approve ✅ Export only
❌ Cannot approve ✅ Export only
📬 Registrar
Account: registrar
✅ View all ❌ Cannot edit ❌ Cannot delete
✅ Approve / reject submissions ✅ Export
✅ Approve / reject submissions ✅ Export
👁️ Viewer
Account: viewer
✅ View all records ❌ No edits or deletes
❌ Cannot approve ✅ Export only
❌ Cannot approve ✅ Export only
Connect to Supabase
Connect a free cloud database so data persists across devices and sessions. Free tier supports 500MB — plenty for this directory.
Step 1 — Create Supabase Project
Go to supabase.com → New Project → copy your Project URL and anon public key.
Not connected — enter credentials below
Step 2 — Enter Credentials
Saved in your browser only. Never shared.
Step 3 — Run SQL Schema
In Supabase → SQL Editor → paste and run this to create both tables:
CREATE TABLE alumni (
id BIGSERIAL PRIMARY KEY,
school TEXT DEFAULT 'boys',
file_number TEXT,
first_name TEXT NOT NULL,
last_name TEXT,
title TEXT,
email1 TEXT,
email2 TEXT,
phone TEXT,
kenya_phone TEXT,
class_year TEXT,
house TEXT,
occupation TEXT,
location TEXT,
region TEXT,
university TEXT,
degree TEXT,
field_of_study TEXT,
grad_year TEXT,
linkedin TEXT,
twitter TEXT,
facebook TEXT,
memories TEXT,
notes TEXT,
status TEXT DEFAULT 'Active',
created_at TIMESTAMPTZ DEFAULT NOW(),
updated_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE submissions (
id BIGSERIAL PRIMARY KEY,
data JSONB,
submitted_at TIMESTAMPTZ DEFAULT NOW(),
status TEXT DEFAULT 'pending'
);
ALTER TABLE alumni ENABLE ROW LEVEL SECURITY;
ALTER TABLE submissions ENABLE ROW LEVEL SECURITY;
CREATE POLICY "public_read" ON alumni FOR SELECT USING (true);
CREATE POLICY "auth_write" ON alumni FOR ALL USING (true);
CREATE POLICY "pub_sub_insert" ON submissions FOR INSERT WITH CHECK (true);
CREATE POLICY "auth_sub_read" ON submissions FOR SELECT USING (true);
Step 4 — Push All Records to Supabase
Once connected, push all 316 records from this session to your Supabase database.
📋 Final Recommendations — Make This World-Class
🚀 1. Deploy to a subdomain
Upload this file to Netlify.com (free), then point alumni.starehefoundation.org at it. Takes 15 minutes. I can guide you step by step.
🗄️ 2. Connect Supabase (above)
Free cloud database — makes data permanent across all devices. Run the SQL above, enter credentials, push records. The community boards also sync once connected.
📋 3. Import full file number register
If you have the historical enrollment register (even a spreadsheet), import all 18,000 file numbers so the system validates against a real list — not just the range 1–19000.
📸 4. Profile photos
Add an optional photo upload to the registration form. Visual directories are far more engaging and help alumni recognise each other across decades.
📧 5. Email welcome on approval
When a registrar approves a submission, automatically send the alumnus a welcome email with their login PIN for the community boards. Use Supabase Edge Functions (free).
💰 6. Annual giving module
The Foundation already tracks donation history. A simple "Give to Starehe" campaign counter on the public page — linked to M-Pesa or Stripe — directly serves the Foundation's mission.
🏷️ 7. Suggested name: NatulengaNet
A global alumni platform: NatulengaNet.com. Start with Starehe, scale to universities worldwide: starehe.natulenganet.com → uon.natulenganet.com → harvard.natulenganet.com.
📅 8. Events & reunions board
Add an upcoming events section (galas, reunions, homecoming) with RSVP. Alumni seeing their classmates on the list will drive registration and engagement dramatically.
Natulenge Juu — We Aim High. This portal is built. The data is here. The community boards are live. The next step is simply deploying it. You have something genuinely worth being proud of.
Community Boards
Alumni can discuss by class year or house. Boards are moderated — admins can pin, delete, or lock threads.
Select a board
ADM
💬
No posts yet. Be the first to start a discussion!
Members in this board
Jobs Board
Alumni posting opportunities for the Starehe community. Verify each posting before it goes live.
🔍
💼
No jobs found. Be the first to post an opportunity!Starehean Stories
Alumni sharing the stories of their lives. Inspiring journeys, lessons learned, and legacies being built.
📜
Starehe School Rules Apply Here
Rule 1: A Starehian respects Authority; is dutiful, polite and considerate of others' feelings. Keeps themselves clean and smart.
Rule 2: Anything contrary to decency, good manners and common sense is contrary to the rules of the school.
📖
No stories yet. Share yours — inspire the next generation of Stareheans.Community Leaderboard
Alumni ranked by their contributions to the community — posts, stories, job postings, and engagement.
🏆 Top Contributors
Alumni who post most actively across boards, stories, and jobs.
📊 Activity Breakdown
How points are earned in the community.
Board post+5 pts
Story published+20 pts
Story comment+3 pts
Job posted+10 pts
Job question answered+5 pts
Received a 👍 reaction+2 pts
| Rank | Alumni | Class | House | Board Posts | Stories | Jobs | Comments | Total Points | Badge |
|---|
🏆
No activity yet. Start contributing to earn your rank!