Classes 10–12 (G): Create the database

Part of the task-app setup for Classes 10–12. Work through the parts in order, doing every step yourself; Start here has the worksheet, the screenshot log, how to ask Claude when you’re stuck, and the list of all parts.

Time: about 5 minutes.

As of Oct 22, 2026 · Official docs: Supabase: Database migrations · supabase db push · Supabase Storage

In VS Code’s terminal, first go into the app’s folder (harmless if you’re already there; this just makes sure):

cd ~/projects/full-stack-demo-app/task-app

Then type:

npx supabase db push

If it asks whether to push the migrations, type y and press Enter. It prints “Applying migration …” for each file, from 0_init_profile.sql to 8_flexible_labels.sql.

npx supabase runs the Supabase CLI, and db push means “send my database changes up to my Supabase project” (db for database, push for upload). It applies the project’s migrations: the files in supabase/migrations that create the tables (profiles, tasks, usage tracking), the security rules, the task-attachments storage bucket for images, and the Stripe connection. In the Supabase dashboard, Table Editor now shows the tables and Storage shows the bucket. See Step 9: Set Up Supabase Database.

Skip the manual steps in Step 10: Set Up Supabase Storage Bucket: the migration already created the bucket, and the chapter’s bucket name (task-images) is wrong.

© 2025-2026 Y. Rosenthal. All rights reserved.