Product setup guide: Phantom

To begin, navigate to Supabase. Here, you will need to create an organisation. This is essential as it serves as the container for your projects. Fill in the required details, such as the organisation name, and click on the "Create" button. Once created, you will be redirected to your organisation dashboard.

After setting up your organisation, head to Supabase Projects. Click on the "New Project" button. You will be prompted to enter a project name, select a database password, and choose a region for your database. Ensure that the project name is unique within your organisation. Once you have filled in the details, click "Create Project" to proceed.

Once your project is created, navigate to the SQL Editor. Here, you can execute SQL commands to set up your database schema. Copy the SQL script from this Pastebin link and paste it into the SQL editor. After pasting, click the "Run" button to execute the script. This will create the necessary tables and relationships in your database.

Go to Supabase API Settings and copy your three API keys (URL, Anon public, and Service Role) into your .env file.

Go to User Management and create a new login by clicking "Add user". Then, copy the ID of the new user, go to Table Editor, open the "users" table, add a new row with that user ID.