Use Airtable just like a Postgres database

[goldman]

Hey everyone,

Excited to share a new tool we built for Retool users that work with Airtable - Sync Inc (syncinc.so). With a couple clicks, we’ll setup a hosted Postgres follower database containing all your Airtable data. We keep your database in sync in real-time. All you have to do is connect your Sync Inc database to Retool with the standard Postgres connector.

Airtable and Retool are a great fit. Airtable makes it easy for teams to create and manage data that Retool can turn into powerful workflows and apps. But Retool doesn't have first-class support for Airtable. On top of that, the Airtable API is a little limited and clumsy. When working with our Airtable data, we found ourselves missing the power of SQL.

As we all know, Retool has first-class support for Postgres databases. By turning your Airtable base into a Postgres database, you can plug your Airtable data into Retool in no time.

You can try it out totally free here: https://syncinc.so.

If you’re curious about how it all works, check out our docs: https://docs.syncinc.so/

We’re looking forward to hearing feedback and answering any questions.

[sgallese]

This looks very helpful, excited to try it out.

[goldman]

Update: Now supporting writes

We added a proxy to Sync Inc that you can use when writing to Airtable from Retool.

The proxy sits in the middle of write requests to ensure that both Airtable and your Sync Inc Postgres database update simultaneously.

This ensures your Retool app is responsive and fast as you manipulate the underlying data in Airtable.

You can read more about how it works in our docs: Reference | Sequin

Or, if you'd like a step-by-step guide, check our our Retool playbook:

Retool | Sequin

[goldman]

Update: Step-by-step Video Tutorial

How to build a Retool app on Airtable using Sync Inc

In addition to our docs and playbook, we put together a video tutorial to show how you can rapidly build a Retool app on Airtable using Sync Inc and SQL.

More to come!