Does the Supabase UI perform any magic behind the scenes? Like can I just use my personal database editor to run queries or does the Supabase UI do something I might miss by using something else?

By UI, do you mean the dashboard, or the UI library? The dashboard doesn't do anything different with regards to data handling. It exists as a more convenient way of managing data for most people. The main difference is that it's not possible to modify email templates and other infrastructure settings from a DB tool. I generally prefer to use PGAdmin for anything related to SQL since I can easily view functions, types, enums, triggers and everything else in once place without having to navigate between pages or type out queries. For viewing data quickly though, the dashboard is really convenient. If you mean the UI library, you could consider it as a set of React components, and you can certainly create your own versions of those components if you prefer.

Ah I meant the dashboard. That's perfect to hear. Thank you !