Building a Sports Tracker for Kids with Prisma, Supabase & AI
Building a Kid's Sports Tracker with Prisma & Supabase | Fullstack AI-Powered Workshop
Welcome back to the channel where we help you build better, faster with the power of AI.
Today, you're watching the full video of our Live Workshop: AI for Database Design with ORM — featuring a complete walkthrough of the KidClub Sports Tracker, a fun, real-world app for managing youth sports teams.
In this recap session we take you from product idea to a fully functional backend using Prisma and Supabase, showcasing how AI can supercharge your schema design and development process.
💡 What You'll Learn:
How to rapidly design a normalized database schema based on product requirements
The best AI-assisted tools to generate, visualize, and manage your schema
How to integrate with ORMs like Prisma (Node.js) and scale with Supabase
A live demo where we go from idea → schema → backend in under 50 minutes
Tips to keep your schema flexible as your app grows
🚀 KidClub Sports Tracker: Fullstack Tech Stack
A web app to track teams, players, games, and achievements in youth sports — with real-time updates and gamified badges. Built for speed, scale, and great UX on the sidelines.
Frontend
⚛️ Next.js 14+ with App Router
🟦 TypeScript
🎨 Tailwind CSS, shadcn/ui, Radix UI
📈 Recharts, react-calendar
✨ Framer Motion for animations
📋 React Hook Form + Zod for forms and validation
🔄 TanStack Query (React Query) for data fetching and caching
Backend & Database
🔌 Prisma ORM (Node.js)
🗃️ Supabase (PostgreSQL, Auth, Storage, Realtime)
🔐 Supabase Auth with row-level security
Tooling & Dev
🧪 Vitest, ESLint, Prettier
🚀 CI/CD with GitHub Actions
🛠️ Deployed via Vercel + Supabase
Architecture Highlights
Modern SSR + RSC with interactive client components
Real-time data flows and secure role-based UI
Mobile-first design for in-game use
Schema-first, type-safe development using Prisma + Supabase
👥 Join Our Community Want to build smarter alongside other devs, PMs, and marketers?
👉 Join the free community: https://productfoundry.ai
🧠 Get tailored support via our AI Mentorship Program: https://gogetai.live
💼 Book a consult for hands-on help: https://calendly.com/productfoundary/...
🔔 Subscribe for More This channel is your go-to for practical AI-powered development:
✅ Fullstack application walkthroughs
✅ Smart schema design techniques
✅ Data workflows and automation with AI
✅ Real startup projects and technical deep dives
Let’s scale your business—smarter, cleaner, and faster—with AI.
#AIWorkshop #DatabaseDesign #Prisma #Supabase #Nextjs #ORM #BuildWithAI #ProductFoundry #GoGetAI #aimentorship #FullstackDevelopment #YouthSportsApp
👨💻 Meet your team of AI Experts: https://braendler.gumroad.com/l/gzpnj