How to Set Up Supabase Locally (CLI, Migrations, Production)
We're building Trelly: a task management app, and this is video 1 of a series where each video adds one Supabase feature. Auth, RLS, Edge Functions, Realtime, Storage, CI/CD. all coming.
Local Supabase MCP: claude mcp add local-supabase -s project -- npx -y @modelcontextprotocol/server-postgres "postgresql://postgres:[email protected]:54322/postgres"
Supabase Postgres Best Practices SKILL: https://skills.sh/supabase/agent-skil...
⏱ Timestamps:
0:00 Why you should work with Supabase locally
1:01 Setting up the Trelly project with Next.js
1:25 Initialize Supabase with supabase init
1:49 Start the local environment with supabase start
2:27 Tour the local Studio UI
4:18 Create migrations with supabase db diff
4:52 Reset and apply migrations with supabase db reset
7:50 Link to remote Supabase with supabase link
8:34 Push migrations to production with supabase db push
9:10 Add the local Supabase MCP server
9:15 Connect Claude to read and write to your database
10:06 Import Supabase Postgres Best Practices skill for AI
🔗 Repo: https://github.com/wassimbenr/trelly
🛠 Tools used:
Supabase CLI: https://supabase.com/docs/guides/loca...
Docker: https://docs.docker.com/desktop
Claude Code: https://claude.ai/code
Next.js: https://nextjs.org/docs/app/getting-s...
Shadcn template: https://ui.shadcn.com/create?preset=a...
📋 Supabase — From Zero to Production (full playlist): • Supabase - From Zero to Production
#supabase #nextjs #webdev #postgresql #tutorial