How to delete records in Supabase?

 

Step 1: Set Up a Supabase Project

To get started with deleting records, you first need to have a Supabase project set up. If you haven't already done this, follow these steps to create a new project on Supabase:

• Visit the Supabase website.
• Log in to your account or sign up if you don't have one.
• Click on the "New Project" button.
• Fill in your project's details, such as project name and organization.
• Choose a database password, as you will need it later.
• Click "Create Project" and wait for Supabase to set it up.

 

Step 2: Navigate to the Supabase Dashboard

Once your project is up and running, navigate to the Supabase Dashboard for your project:

• Go to your Supabase account.
• Click on the project you set up in the previous step.

This will take you to the main dashboard for your project.

 

Step 3: Set Up Database Table

For deleting records, you need to have a database table in your project:

• From the Supabase dashboard, click on the "Table Editor."
• Create a new table by clicking on the "New Table" button.
• Define the columns needed for your table. For example, let's create a table named users with columns id, name, and email.
• Save your new table.

 

Step 4: Install Supabase Client in Your Application

To interact with your Supabase database, you'll use the Supabase client. Install the client in your application:

npm install @supabase/supabase-js

 

Step 5: Initialize Supabase Client

Initialize the Supabase client in your application code with your project's credentials:

import { createClient } from '@supabase/supabase-js'

// Replace with your Supabase API URL and Key
const supabaseUrl = 'https://xyzcompany.supabase.co'
const supabaseKey = 'public-anonymous-key'
const supabase = createClient(supabaseUrl, supabaseKey)

 

Step 6: Delete Records from Supabase Table

To delete records from a table, use the Supabase client to interact with your database:

async function deleteUser(userId) {
  const { data, error } = await supabase
    .from('users')
    .delete()
    .eq('id', userId)

  if (error) {
    console.error('Error deleting user:', error)
  } else {
    console.log('User deleted:', data)
  }
}

// Call the function with a specific user id
deleteUser(123)

 

Step 7: Verify Deletion via Supabase Dashboard

Finally, verify that the record has been deleted:

• Go back to the Supabase Dashboard.
• Navigate to "Table Editor."
• Select the users table.
• Check if the record with the specified id has been removed.