⚡️ Quickstart

Start querying your Airtable base with SQL in 2 minutes.

Add your first base

First, let's connect your Airtable base to Sync Inc:

Inventory Tracking base

(For this quickstart, we'll be using the Inventory Tracking template. Feel free to join along or use another great sample from the Airtable Universe!)

  1. Create a new account at https://app.syncinc.so/signup.

  2. The first step is to name your resource. To keep it simple, we suggest you reuse your base name from Airtable.

Name your resource
  1. Provide us with your Airtable API key. Click the the Where do I find this? link if you need a little help finding your API key on your Airtable account page.

  2. Now, enter the ID for your Airtable base. Again, click our friendly Where do I find this? link if you could use some help finding your base ID on Airtable's REST API site.

  3. Last, enter the names of the tables in the base. Do this for each and every table in your base. Please enter the name of the table exactly as it appears in Airtable:

Enter table names
  1. Click Start syncing.

After you click Start syncing, we'll immediately connect to Airtable and begin syncing with your base.

Start syncing

For most Airtable bases, the sync will complete in a couple seconds. For larger bases of around ~10,000 records, the sync might take around 30 seconds to complete.

Connect to your database

Now that your database is setup, you can connect to it.

Sync Inc provisioned you a Postgres database. You can connect to your database in all the ways you're used to. For this guide, we'll use TablePlus, which supports both macOS and Windows.

TablePlus is in alpha for Linux. If you're a Linux user, we recommend you check out DBeaver as a great alternative.

  1. Download and install TablePlus from https://tableplus.com/.

  2. Open TablePlus and click Create a new connection...

  3. Click the Import from URL button.

  4. Copy and paste the Connect URL from Sync Inc into the Connection URL in TablePlus then click Import.

  5. Then simply name your your TablePlus connection (we recommend reusing the name of your Airtable base again) and click Create.

That's it!

Connecting on TablePlus

Query your base

You'll now see your entire Airtable base represented in Postgres tables!

Note that we convert your table names to snake_case (i.e lowercase words delineated by an underscore). So what was Product Inventory in Airtable is now product_inventory in your database.

To start querying, click the SQL button and have at it. For instance:

SELECT sum(revenue) AS "Gross Revenue" FROM sales_orders;

Enter table names

You can now query all your Airtable data with full fledged SQL: SELECT, JOIN, UNION and more. And because your data is now in a Postgres database, you can connect to your data using a variety of tools and programming languages.

From here, check out our Cheat Sheet for quick tips on how to query your Airtable base in SQL.

Read our Query docs to learn more about how we make Airtable work with SQL.