Description
Read from an EXTERNAL Postgres through a secure SSH tunnel (DBeaver-style). READ-ONLY (SELECT/EXPLAIN only), mandatory host-key pinning against MITM, SSRF and DNS-rebinding guards, credentials from the per-tenant vault.
External DB via SSH (SELECT)
db_remote_ssh_query · action · Database · Available · v1.0.0
⚙️ Configuration parameters
Fields shown in the editor when configuring the node. Generated directly from the NodeDefconfigFields.
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
sshConnessione SSH | JSON object/array | yes | — | { host, port, user, hostKeyFingerprint, auth:{ method:"key", privateKeySecretRef } } |
dbDatabase remoto | JSON object/array | yes | — | { engine:"postgres", host, port, database, userSecretRef?, passwordSecretRef? } |
sqlSQL (solo SELECT) | code | yes | — SELECT * FROM clienti LIMIT 100 | — |
rowLimitLimite righe | number | no | 1000 | — |
💡 Configuration example
JSON snippet of the node as it appears in the workflow. Values are derived fromdefaultValue and from required parameters.
{
"id": "node-db_remote_ssh_query-1",
"defId": "db_remote_ssh_query",
"label": "External DB via SSH (SELECT)",
"config": {
"ssh": "<ssh>",
"db": "<db>",
"sql": "SELECT * FROM clienti LIMIT 100",
"rowLimit": 1000
}
}🔗 Related nodes in the same category
Ready to use External DB via SSH (SELECT)?
Available now on all FlowForge plans. Try it free without a credit card.
Start freeBrowse all nodes