Can prefect be used to extract from a database and do an SFTP upload? Are there examples of this?

yes, what you do inside of your tasks is up to you, so this is definitely doable. You can have a look at the task library for examples: https://docs.prefect.io/core/task_library/overview.html#task-library-in-action