2
Add beter ways to query users as an admin
Source: supabase/supabase#21721 · opened by @janglad
You can not query the auth.users table. I get why this is, but the provided admin api's are quite lackluster. An obvious gap is that you can not get a user by their email address, if you wanted to do this you'd need to query your public.users (assuming you have one), and then get the user by the id you retrieve that way.
The specific reason I ask for this though is because I'd like to get some analytic data. Like get a total user count, get count of users that have signed in the last month, ... . Obviously you could solve this with functions in Supabase itself, but this IMO not an ideal solution.
The specific reason I ask for this though is because I'd like to get some analytic data. Like get a total user count, get count of users that have signed in the last month, ... . Obviously you could solve this with functions in Supabase itself, but this IMO not an ideal solution.
No pledges yet. Be the first to back this.
Comments
Similar requests
[Feature Request] Call other saved SQL queries from Dashboard query
1 vote · 0 comments
[RFC] Query builder immutability and safe branching semantics across Supabase SDKs
1 vote · 0 comments
Feature Request(postgrest-js): Programmatic .or() Query Building
1 vote · 0 comments
Self-hosted Supabase doesn't support saving analytics queries
1 vote · 0 comments
GoTrue: Allow to send confirmation emails when creating users through admin API
5 votes · 0 comments
No comments yet.