The following VS Code extension will help you:
Extension Name: SFTP
Author: Satiro Marra
Documentation: visit
{
"name": "Site name",
"host": "host name",
"protocol": "sftp",
"port": 9,
"username": "username",
"password": "password",
"remotePath": "//",
"uploadOnSave": false,
"useTempFile": false,
"openSsh": false
}