Skip to content
cccskills
FreePublished on GitHub

estuary-ssh-tunnels

Diagnose and fix SSH tunnel connection issues for Estuary captures and materializations. Use when seeing tunnel failures, connection timeouts, or permission denied errors. Use when user says "SSH tunnel failed", "connection timeout via tunnel", "permission denied SSH", "tunnel not working", "network-tunnel failed", "no pubkey loaded", "bastion host not connecting", or "RSA key format".

The English summary is being prepared. Showing the original description.

Works withMySQL
See how to install

Files included (1)

  • SKILL.md4.6 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

SSH Tunnel Troubleshooting for Estuary

Quick Checklist

Before deep debugging, verify these common issues:

  1. SSH Endpoint format: Must be ssh://user@hostname:port

    • Check for typos, spaces, missing hyphens
    • AWS regions use hyphens: us-west-2 not us-west 2
  2. Private key format: Must be RSA PEM format

    • Must start with -----BEGIN RSA PRIVATE KEY-----
    • NOT -----BEGIN OPENSSH PRIVATE KEY----- (OpenSSH format)
    • NOT -----BEGIN PRIVATE KEY----- (PKCS#8 format)
    • Ed25519 and ECDSA keys are not supported — only RSA
  3. IP allowlisting: Estuary data plane IPs must be allowed on:

    • Bastion/SSH server security group (port 22)
    • Database security group (from bastion's private IP)
    • Find the IPs for your data plane at Admin → Settings → Data Planes in the Estuary UI
    • Note: data plane IPs can change after infrastructure scaling — re-verify allowlists if a previously working tunnel stops connecting
  4. Data plane selection: The user should verify the correct data plane is selected in the Estuary UI when editing the connector. Each data plane has different egress IPs — using the wrong one means the wrong IPs are connecting.

Testing SSH Connectivity

If the quick checklist doesn't resolve the issue, instruct the user to test SSH connectivity from a machine that can reach the bastion host (e.g., their local machine or another server in the same network):

Test SSH connection

ssh -i /path/to/private_key -o StrictHostKeyChecking=no -v user@bastion-host -p 22

A successful connection confirms the key, username, and network path are correct.

Test the tunnel

ssh -i /path/to/private_key -o StrictHostKeyChecking=no \
    -L 3306:database-endpoint:3306 \
    user@bastion-host -N -v &

Then test the database connection through the tunnel (substitute the client and port for the relevant database type — MySQL 3306, PostgreSQL 5432, SQL Server 1433):

Important: The database address used here (and in the connector's address config field) must be the address as seen from the bastion host — not from the user's local machine. If the database is on a private subnet visible to the bastion (e.g., db.internal:5432), use that address.

mysql -h 127.0.0.1 -P 3306 -u dbuser -p

If this works locally but Estuary's connector fails, the issue is likely IP allowlisting — the user's machine can reach the bastion but Estuary's data plane IPs cannot.

Note: If the Test Connection button fails but the configuration looks correct, try Save and Publish anyway — test connectivity is sometimes stricter than the runtime connection.

Error Reference

Error MessageCauseSolution
network-tunnel failedGeneric tunnel failureCheck SSH endpoint format, key format, firewall rules
network-tunnel ready but connector still failingKnown false positive — this log can appear even when the tunnel failedCheck log entries before "tunnel ready" for the real error
Permission denied (publickey)Auth failureCheck key format (must be RSA PEM), username, key content — also check for trailing whitespace or extra newlines in the pasted key
no pubkey loadedKey format issueConvert key to RSA PEM format (see below)

Key Format Conversion

If the private key starts with -----BEGIN OPENSSH PRIVATE KEY-----, it needs to be converted to RSA PEM format:

ssh-keygen -p -N "" -m pem -f /path/to/key

To generate a new compatible key from scratch:

ssh-keygen -m PEM -t rsa -b 4096 -f mykey

Then add the public key (mykey.pub) to ~/.ssh/authorized_keys on the bastion host.

Common Endpoint Format Mistakes

# WRONG - space in region
ssh://estuary@ec2-35-87-112-173.us-west 2.compute.amazonaws.com:22

# WRONG - missing hyphen
ssh://estuary@ec2-35-87-112-173.uswest2.compute.amazonaws.com:22

# CORRECT
ssh://estuary@ec2-35-87-112-173.us-west-2.compute.amazonaws.com:22

Related Skills

  • estuary-logs — Start here to pull task logs and find the exact tunnel error message and timestamps
  • estuary-catalog-status — Check whether the task is running, failed, or disabled before debugging the tunnel

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Create an Alpaca capture using flowctl to stream stock trade data into Estuary collections. Use when setting up an Alpaca Market Data source for historical and real-time stock trades. Use when user says "capture Alpaca", "stream stock trades", "Alpaca market data", or "connect Alpaca to Estuary".

The English summary is being prepared. Showing the original description.

estuary/agent-skills7Updated Sep 25, 2026

Create a capture for ANY Estuary connector using dynamic schema discovery. Use when the user wants to capture from a source that doesn't have a dedicated skill (e.g., Kafka, Salesforce, HubSpot, Stripe, S3, GCS, Kinesis, or any of the 148+ connectors). Use when user says "capture from <source>", "stream from <source>", "connect <source> to Estuary", or "set up <source> capture" and no connector-specific skill exists.

The English summary is being prepared. Showing the original description.

estuary/agent-skills7Updated Sep 25, 2026

Create an HTTP Ingest (webhook) capture to receive data via HTTP POST requests. Use when setting up webhooks from GitHub, Shopify, Stripe, or any JSON source. Use when user says "set up webhook capture", "HTTP ingest to Estuary", "receive POST requests to Estuary", or "webhook capture".

The English summary is being prepared. Showing the original description.

estuary/agent-skills7Updated Sep 25, 2026

Create a HubSpot Real-Time capture using flowctl to stream CRM data into Estuary collections. Use when setting up a HubSpot source for contacts, companies, deals, tickets, or other HubSpot resources. Use when user says "capture HubSpot", "stream from HubSpot", "HubSpot CDC", or "connect HubSpot to Estuary".

The English summary is being prepared. Showing the original description.

estuary/agent-skills7Updated Sep 25, 2026

Create a MongoDB CDC capture using flowctl. Use when setting up real-time streaming from MongoDB Atlas, DocumentDB, or self-hosted MongoDB. Use when user says "capture MongoDB", "stream from Mongo", "MongoDB CDC", or "connect MongoDB to Estuary".

The English summary is being prepared. Showing the original description.

estuary/agent-skills7Updated Sep 25, 2026

Create a MySQL CDC capture using flowctl with binlog replication. Use when setting up streaming from MySQL, Amazon RDS MySQL, or Aurora MySQL. Use when user says "capture MySQL", "stream from MySQL", "MySQL CDC", "binlog replication", or "connect MySQL to Estuary".

The English summary is being prepared. Showing the original description.

estuary/agent-skills7Updated Sep 25, 2026

See all skills by estuary

Report a problem with this skill