Does supabase work like a normal database?

Yes it works like a normal database, you can get the connection information from under

settings/database

inside of the Supabase dashboard, just scroll down to the Connection string area at the bottom for the information.