Deploy Supabase Skill

This skill provides the definitive set of instructions for taking a local Supabase development environment and deploying it to a remote Supabase project (e.g., staging or production). As an AI Agent, use these guidelines when instructed to "deploy Supabase", "sync local Supabase to production", or "link to a remote Supabase project".

1. Prerequisites & Authentication

Before deploying, ensure the CLI is authenticated and the user has a remote project ready.

1. Login: Ensure the CLI is authenticated. Run supabase login. This will require the user to provide a Personal Access Token from https://supabase.com/dashboard/account/tokens.
2. Get Project Ref: Ask the user for the Reference ID of their remote project (a 20-character string found in the project's dashboard URL: https://supabase.com/dashboard/project/<project-ref>).

2. Linking the Local Project to Remote

To ensure migrations and deployments target the correct remote database:

1. Link Project: Run supabase link --project-ref <project-ref>.
2. Database Password: The CLI will prompt for the remote database password (not the user's account password). Ask the user to enter this when prompted, or pass it via the SUPABASE_DB_PASSWORD environment variable.

3. Database Migrations