Comment by pheeney

I was able to get it working and it seemed fast enough. However I don't have any local databases of similar size to compare to.

ssh -F ssh.config -L 4213:localhost:4213 dev 'DUCKDB_HTTPPORT=4213 ~/.duckdb/cli/latest/duckdb -ui'