Create the database dump:
ssh -i pemfile.pem user@ip-address "wp db export /home/user/mysql.sql"
ssh -i pemfile.pem user@ip-address "docker exec <container_name> wp db export /home/user/mysql.sql"Download that file into current folder:
scp -i pemfile.pem user@ip-address:/home/user/mysql.sql ./