Local on Windows uses ports to connect to the database, whereas Linux and Mac use unix sockets for performance reasons.
If you are on one of those *nix systems and want to connect to the DB over a port, you can follow the steps in this FAQ:
You’re right that Sequel Pro has been discontinued. We are planning on removing that from Local, but haven’t had a chance to get to it yet.
In terms of getting a connection to Sequel Ace, someone tried to create a Local add-on to help with that setup but ran into an issue in that the Sequel Ace team doesn’t support connecting over sockets: