Resources

Migrate from Auth0 to Supabase Auth

Learn how to migrate your users from Auth0

You can migrate your users from Auth0 to Supabase Auth.

Changing authentication providers for a production app is an important operation. It can affect most aspects of your application. Prepare in advance by reading this guide, and develop a plan for handling the key migration steps and possible problems.

With advance planning, a smooth and safe Auth migration is possible.

Before you begin

Before beginning, consider the answers to the following questions. They will help you need decide if you need to migrate, and which strategy to use:

  • How do Auth provider costs scale as your user base grows?
  • Does the new Auth provider provide all needed features? (for example, OAuth, password logins, Security Assertion Markup Language (SAML), Multi-Factor Authentication (MFA))
  • Is downtime acceptable during the migration?
  • What is your timeline to migrate before terminating the old Auth provider?

Migration strategies

Depending on your evaluation, you may choose to go with one of the following strategies:

  1. Rolling migration
  2. One-off migration
StrategyAdvantagesDisadvantages
Rolling
  • 0 downtime
  • Users may need to log in again
  • Need to maintain 2 different Auth services, which may be more costly in the short-term
  • Need to maintain separate codepaths for the period of the migration
  • Some existing users may be inactive and have not signed in with the new provider. This means that you eventually need to backfill these users. However, this is a much smaller-scale one-off migration with lower risks since these users are inactive.
One-off
  • No need to maintain 2 different auth services for an extended period of time
  • Some downtime
  • Users will need to log in again. Risky for active users.

Migration steps

Auth provider migrations require 2 main steps:

  1. Export your user data from the old provider (Auth0)
  2. Import the data into your new provider (Supabase Auth)

Step 1: Export your user data

Auth0 provides two methods for exporting user data:

  1. Use the Auth0 data export feature
  2. Use the Auth0 management API. This endpoint has a rate limit, so you may need to export your users in several batches.

To export password hashes and MFA factors, contact Auth0 support.

Step 2: Import your users into Supabase Auth

The steps for importing your users depends on the login methods that you support.

See the following sections for how to import users with:

Password-based methods

For users who sign in with passwords, we recommend a hybrid approach to reduce downtime:

  1. For new users, use Supabase Auth for sign up.
  2. Migrate existing users in a one-off migration.
Sign up new users

Sign up new users using Supabase Auth's signin methods.

Migrate existing users to Supabase Auth

Migrate existing users to Supabase Auth. This requires two main steps: first, check which users need to be migrated, then create their accounts using the Supabase admin endpoints.

  1. Get your Auth 0 user export and password hash export lists.

  2. Filter for users who use password login.

    • Under the identities field in the user object, these users will have auth0 as a provider. In the same identity object, you can find their Auth0 user_id.
    • Check that the user has a corresponding password hash by comapring their Auth0 user_id to the oid field in the password hash export.

  3. Use Supabase Auth's admin create user method to recreate the user in Supabase Auth. If the user has a confirmed email address or phone number, set email_confirm or phone_confirm to true.


    _10
    const { data, error } = await supabase.auth.admin.createUser({
    _10
    _10
    password_hash: '$2y$10$a9pghn27d7m0ltXvlX8LiOowy7XfFw0hW0G80OjKYQ1jaoejaA7NC',
    _10
    email_confirm: true,
    _10
    })

    If you have a plaintext password instead of a hash, you can provide that instead. Supabase Auth will handle hashing the password for you. (Passwords are always stored hashed.)


    _10
    const { data, error } = await supabase.auth.admin.createUser({
    _10
    _10
    password: 'supersecurepassword123!',
    _10
    })

  4. To sign in your migrated users, use the Supabase Auth sign in methods.

    To check for edge cases where users aren't successfully migrated, use a fallback strategy. This ensures that users can continue to sign in seamlessly:

    1. Try to sign in the user with Supabase Auth.
    2. If the signin fails, try to sign in with Auth0.
    3. If Auth0 signin succeeds, call the admin create user method again to create the user in Supabase Auth.

Passwordless methods

For passwordless signin via email or phone, check for users with verified email addresses or phone numbers. Create these users in Supabase Auth with email_confirm or phone_confirm set to true:


_10
const { data, error } = await supabase.auth.admin.createUser({
_10
_10
email_confirm: true,
_10
})

Check your Supabase Auth email configuration and configure your email template for use with magic links. See the Email templates guide to learn more.

Once you have imported your users, you can sign them in using the signInWithOtp method.

OAuth

Configure your OAuth providers in Supabase by following the Social login guides.

For both new and existing users, sign in the user using the signInWithOAuth method. This works without pre-migrating existing users, since the user always needs to sign in through the OAuth provider before being redirected to your service.

After the user has completed the OAuth flow successfully, you can check if the user is a new or existing user in Auth0 by mapping their social provider id to Auth0. Auth0 stores the social provider ID in the user ID, which has the format provider_name|provider_id (for example, github|123456). See the Auth0 identity docs to learn more.

Mapping between Auth0 and Supabase Auth

Each Auth provider has its own schema for tracking users and user information.

In Supabase Auth, your users are stored in your project's database under the auth schema. Every user has an identity (unless the user is an anonymous user), which represents the signin method they can use with Supabase. This is represented by the auth.users and auth.identities table.

See the Users and Identities sections to learn more.

Mapping user metadata and custom claims

Supabase Auth provides 2 fields which you can use to map user-specific metadata from Auth0:

  • auth.users.raw_user_meta_data : For storing non-sensitive user metadata that the user can update (e.g full name, age, favorite color).
  • auth.users.raw_app_meta_data : For storing non-sensitive user metadata that the user should not be able to update (e.g pricing plan, access control roles).

Both columns are accessible from the admin user methods. To create a user with custom metadata, you can use the following method:


_10
const { data, error } = await supabase.auth.admin.createUser({
_10
_10
user_metadata: {
_10
full_name: 'Foo Bar',
_10
},
_10
app_metadata: {
_10
role: 'admin',
_10
},
_10
})

These fields are stored as columns in the auth.users table using the jsonb type. Both fields can be updated by using the admin updateUserById method. If you want to allow the user to update their own raw_user_meta_data , you can use the updateUser method.

If you have a lot of user-specific metadata to store, it is recommended to create your own table in a private schema that uses the user id as a foreign key:


_10
create table private.user_metadata (
_10
id int generated always as identity,
_10
user_id uuid references auth.users(id) on delete cascade,
_10
user_metadata jsonb
_10
);

Frequently Asked Questions (FAQ)

Useful references