SCP from standard input.

To create a TGZ file and upload it to a remote server directly.

tar cf - some_dir | gzip | ssh user@remoteserver "cat >some_dir.tgz"

SCP does not take input from standard input but SSH does.