Use existing User Database

Hey, I already have an existing Discord user database from my Discord. This database will continue to be populated and updated by my Discord bot backend.
Now I want to create a Next.js app for the backend. I want to use BetterAuth there, but it should utilize the existing Discord user database. There’s no need for duplicate entries in the database. The app will only support Discord login. Are there ways for BetterAuth to work with this setup, or do I need to adjust my database schema?

DDevPanda Hey, I already have an existing Discord user database from my Discord. This data...

FalconiZzare•5/5/25, 12:32 PM

I think you need to migrate your schema according to better auth schema as better auth needs those specific tables to work with.

FFalconiZzare I think you need to migrate your schema according to better auth schema as bette...

DevPandaOP•5/5/25, 12:36 PM

Okay, I’ve already tried that. I adjusted the User table from BetterAuth and added my data to it. However, when I try to log in, it attempts to create the user in the database, which doesn’t work because the Discord ID already exists. I think this might have something to do with the Account table.

DDevPanda Okay, I’ve already tried that. I adjusted the User table from BetterAuth and add...

FalconiZzare•5/5/25, 12:37 PM

u need the user, account and session table.

FFalconiZzare u need the user, account and session table.

DevPandaOP•5/5/25, 12:41 PM

I have added all the tables that BetterAuth requires. I simply merged my current DiscordUser table with the User table from BetterAuth. However, it always tries to create the user during login, even though they already exist. I think this is because there’s no corresponding account in the Account table yet.

DevPandaOP•5/5/25, 12:42 PM

If there’s no other way, I’ll have to link the User table with the Discord table and then manually add the values to the session or load them into a store/context.

DDevPanda I have added all the tables that BetterAuth requires. I simply merged my current...

FalconiZzare•5/5/25, 12:47 PM

That sounds expected as idToken and accessTokens are stored on account table, not usertable. If your previous user table contains all of these together (email, image, idToken, accessToken,refreshToken) then you have to manually separate them and insert into new user and acocunt table.

FalconiZzare•5/5/25, 12:47 PM

userTabale and accountTable has one to many relationship.

FFalconiZzare That sounds expected as idToken and accessTokens are stored on account table, no...

DevPandaOP•5/5/25, 12:52 PM

here my Prisma Schema Models for better-auth https://pastie.io/vzseuq.dart

DDevPanda here my Prisma Schema Models for better-auth https://pastie.io/vzseuq.dart

FalconiZzare•5/5/25, 12:56 PM

looks ok, how are populating these fields?

FFalconiZzare looks ok, how are populating these fields?

DevPandaOP•5/5/25, 1:09 PM

also for the user I can fill the mandatory fields without problems with the mapProfileToUser function I can customize everything well. the problem is simply he always wants to create it directly. I don't even see in the debug log of Prisma that it checks if the user is there

DDevPanda also for the user I can fill the mandatory fields without problems with the mapP...

FalconiZzare•5/5/25, 1:22 PM

What data of a user do you currently have? can u show me a dummy row of ur existing data?

FFalconiZzare What data of a user do you currently have? can u show me a dummy row of ur exist...

DevPandaOP•5/5/25, 1:28 PM

{
"id": "w9pw4ydz1v0cgjtiglwxrn80",
"discordId": "283414457193988096",
"username": "devpanda_",
"logoUrl": "",
"currentOrganizationId": null,
"guildIds": [],
"createdAt": "2025-05-01 21:46:07.241",
"updatedAt": "2025-05-01 21:47:44.179",
"email": null,
"emailVerified": false,
"image": null
}

DDevPanda { "id": "w9pw4ydz1v0cgjtiglwxrn80", "discordId": "283414457193988096", ...

FalconiZzare•5/5/25, 1:36 PM

Oh. No this is not a proper OAuth authenticated data. If you must use better auth, your users must login/signup again. However, the discordId will remain the same for users even if they sign in again, so any data tied to this Id should still be usable.

FalconiZzare•5/5/25, 1:41 PM

make sure to map "discordId" to "accountId" in accounts table

FFalconiZzare make sure to map "discordId" to "accountId" in accounts table

DevPandaOP•5/5/25, 1:44 PM

What do you mean exactly?

FalconiZzare•5/5/25, 1:52 PM

this one = accountId in better auth schema. so it should be removed from user table and be added to accounttable

FalconiZzare•5/5/25, 1:54 PM

So you have to manually populate the accounts table with your existing discord user ids, keep the idToken, accessToken and refreshToken as NULL and when the user signs in it will be aquired automcatically. Make sure to register in discord developer console first

FalconiZzare•5/5/25, 1:54 PM

https://www.better-auth.com/docs/authentication/discord

Discord | Better Auth

Discord provider setup and usage.

FalconiZzare•5/5/25, 1:55 PM

FFalconiZzare So you have to manually populate the accounts table with your existing discord u...

DevPandaOP•5/5/25, 9:22 PM

I’ll just do it in two tables. It’s simpler.

DDevPanda I’ll just do it in two tables. It’s simpler.

FalconiZzare•5/6/25, 4:03 AM

Whatever you do, you have to adapt to better auth schema if you want to use better auth.

Use existing User Database

Similar Threads

Similar Threads

Similar Threads