I have an application built with PHP & Mysql that I'd like to move to Supabase. I obviously just want to create web services for this part, and have already converted the DB form mysql to postgres. PS - I'm a newbie in supabase, and do not have a pro plan. I see that Supabase uses UUIDs for the user table, but mine are simple incremental IDs. 🆔 1.) What should be the best way to import the external DB in to Supabase? 2.) How to add the additional UUID field to the newly imported DB? Many thanks 🙏

Supabase gives you a full database port so you can use any tool like psql to import stuff. Not sure how you plan to use Supabase Auth and your user_id field if at all. In order for Supabase Auth to work you will need to create users in the auth.user table with the API or possibly with SQL. If you plan to use the auth, you would also have to deal with passwords if you have them. Googling importing users to supabase you can find a few hits. https://github.com/orgs/supabase/discussions/1264 is one talking about doing it from a firebase user dataset. https://kevcodez.medium.com/migrating-125-000-users-from-auth0-to-supabase-81c0568de307 another example You may want to ask a specific question with the title on importing users, I have not done it, and not paid much attention to the subject myself.

Thanks for the info @garyaustin , I am going to do a bit more research.