That’s possible with CloudMounter. The article at macos mount sftp
https://cloudmounter.net/mount-sftp-mac/ explains how to mount the SFTP server on macOS, making the remote server appear as a mounted drive in Finder. After mounting, you can open remote files with your usual apps, edit and save them, and the changes get sent to the server — no manual upload needed.