This tutorial guides users through building a simple and secure social media site using Magic and Hasura. The process involves creating an account and application with Magic, setting up a new project with Hasura, adding environment variables, and running the npx make-magic command to create a template for the project. The app allows users to share photos of their kittens and view other people's galleries. The tutorial covers building a Heroku PostgreSQL database, setting up user roles, creating tables, establishing relationships between them, and implementing object and array relationships. It also explains how to build a Next.js client with core UI components, integrate Magic authentication, create a GraphQL API, and log in or out of the application. The final result is an open-source social media site where users can share and view photos of kittens.