clickhouse-ssh
v1.0.0
Published
connect clickhouse over ssh tunnel
Downloads
4
Readme
clickhouse-ssh
connect clickhouse server over ssh tunnel.
API
.connect(sshConfig, chConfig)
sshConfig
should be an object according to thessh2
package. see options.chConfig
should be an object according to theclickhouse
package. see options- Returns a Object, containing a
client
from theclickhouse
package andclose
function.
Usage
Don't forget to close()
the tunnel connection when you're done with clickhouse.
(async () => {
const { client, close } = await require('clickhouse-ssh').connect({
host: '127.0.0.1',
port: 22,
username: 'user',
password: 'pass',
}, {
host: '127.0.0.1',
port: 8123,
auth: 'user:pass'
});
try {
const result = await client.querying('select 1 as c');
console.log(result);
} catch (e) {
console.log(e);
} finally {
close();
}
})();