How to use Airtable as a Database in Node.js

When you want to build custom tools or websites on your Airtable data - then you’ll be using the Airtable API and almost certainly some JavaScript (in this case Node.js) to work with your data.

Soon you will probably start asking questions like:

  • How do I paginate through the Airtable REST API?
  • How do I manage the 5 calls / second rate limit in Airtable’s API?
  • How can I find specific records using filterBy?
  • How do I use the API to return linked data from several tables?

TL;DR - the answers were just as tedious to build as we thought. So we built a tool and wrote a tutorial on how to skip the API and use Airtable as a database.

You’ll find many iterations of answers to these same questions here in the Airtable community. Yes, all of this is possible using the REST API, but it takes a bit of wrangling and time :cowboy_hat_face:

We wanted to simplify the problem and completely skip the tedium of working through the nuances of the API. So we wrote up a tutorial on how to easily read from and write to Airtable using our Sync Inc database and proxy.

With SQL, reading data from across your Airtable base (or bases - just ask us how :wink: ) is intuitive and fast.

Writing data to Airtable has always been much easier - but with the proxy you no longer need to worry about the last remaining snag — rate limits.

We hope this provides another way for developers to build amazing services and apps on Airtable.