I have a live server that hosts my website.
Is there any way I can connect to this database from a local file on my computer without uploading it to the server?
Normally that would be blocked by the firewall. You might be able to skirt that with a VPN.
If you are developing locally, you can also just use a local db.