© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
7 replies
Miguel

Insert many auth.users

Hey 👋

I would need to import many auth.users at once (we’re talking way above 10k each time).

Since the
supabase.auth.admin
supabase.auth.admin
API (createUser or inviteUserByEmail) does not allow to create more than one user at once, we were thinking of doing it through a RPC function and basically do an
insert into auth.users ...
insert into auth.users ...
that would work but the issue is that the uuid is required and it opens the risk that we randomly prepare an uuid already used by someone.

Are there better solutions to do something like this? Doing them one by one in a for loop would take too long…

Thanks!
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Local; How can I insert test data into auth.users?
SupabaseSSupabase / help-and-questions
4y ago
Manage Auth users
SupabaseSSupabase / help-and-questions
4y ago
DB Function to Insert New Users
SupabaseSSupabase / help-and-questions
4y ago
ConnectionRateLimitReached: Too many connected users
SupabaseSSupabase / help-and-questions
4mo ago