Yes, you can use Supabase. You can find the database connection details provided and it would connect just like any other database.
Note: usually, we have the db running within the same server as the application or within a private network. This is to block public access to the database which delegates all security measures to the application server. In this case, your db connection to Supabase will happen over the www… which is a weak link for your application. Before you even start development, I suggest you configure SSL for the db access to local, prod and any other environment. enabling SSL will cause a bit of latency but in terms of security, this is the best available means to safe-guard your application against various attacks.
Please do share your experience once you have the system up and running… all the best!