All projects · Supabase Full-Stack Apps
Help Centre — FAQ / Help-Centre CMS
A full-stack FAQ and help-centre content management system with a dark admin dashboard for creating, editing, publishing, and deleting FAQs, plus…
A full-stack FAQ and help-centre content management system with a dark admin dashboard for creating, editing, publishing, and deleting FAQs, plus a light public-facing help page that only shows published entries. Built as a single standalone HTML file backed by Supabase (with a mock-data fallback so it runs without any backend config), plus a Postgres/Supabase SQL schema.
- Two hash-routed views in one file: dark admin panel (#admin) and light public help centre (#public)
- CMS publish gate — new FAQs default to Draft; public page queries only status='Published', proving the moderation workflow
- Admin dashboard with 4 stat cards (Total/Published/Draft/Pending), search, category + status filters, and per-row edit/publish/delete actions
- SQL schema with a faqs table (category and status CHECK constraints), RLS enabled with an open demo policy, and 23 seeded FAQs (15 Published / 5 Draft / 3 Pending)
- Mock-data fallback lets the app run client-side with no Supabase credentials configured
Built with: HTML, CSS, Vanilla JavaScript, Supabase JS v2 (CDN), PostgreSQL / Supabase, Row Level Security, Plus Jakarta Sans (Google Fonts)