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.