First step is to list the available db's to figure out which one to describe and then copy the connectionName for.
gcloud sql instances list
Assuming the db you want is called foo you would then copy the connectionName as follows.
gcloud sql instances describe foo | grep connectionName | awk '{print $2}' | xclip -selection clipboard
Download cloud-sql-proxy here.