Skip to main content

Connecting Airtable Base to PostgreSQL via SSH tunnel

  • November 16, 2021
  • 2 replies
  • 21 views
A

Hi all,

We use Airtable as our internal operating system but our customer-facing web-app is built using a Postgres DB. So, we’re trying to two-way sync our Airtable base with our Postgres DB. We’ve looked at other tools such as Retool or UI Bakery that allow for SSH tunneling but really don’t want to leave Airtable. We’ve also looked to connect Airtable to our db by way of Zapier but Zapier currently requires us to whitelable essentially all IP adddress for the Eastern US to enable the connection, which we’re not comfortable doing for obvious security reasons. Also, Zapier does not currently support SSH tunneling.

We welcome any solutions or suggestions.

Thanks,

A.J.

    2 replies

    I
    Forum|alt.badge.img+3
    • IanYanusko11
    • Known Participant
    • 13 replies
    • December 6, 2022

    Hey AJ, leaving this here in case it’s still a problem for you or anyone else that stumbles along this post.

    You can use Bracket to do a two-way data sync between Airtable and Postgres (or any database / data warehouse). And it’s built to move data securely via SSH as well.

    All you have to do is submit your Airtable API key and link it up to your Postgres with those credentials (via SSH if you choose), and you’re done. We also support SQL queries from Postgres into Airtable to make your syncs fully customizable.

    Disclaimer: I’m the founder and built for this use case because I needed a solution myself. 

    you can go here to get started right away: https://app.usebracket.com/

     

    MJen
    Forum|alt.badge.img+7
    • MJen
    • Participating Frequently
    • 11 replies
    • December 30, 2024

    Hello,

    Try Skyvia. It is a third-party tool that supports SSH tunneling. Skyvia supports multiple data integration scenarios, including 2-way sync using the ETL approach.

    You can read more about it here.

    Mary Jennings

    Reply


    Most helpful members this week

    Terms & Conditions