---
title: Sync MariaDB to Airtable on a Schedule
description: "[![](https://querystreams.com/wp-content/uploads/2025/09/maria-db-40.png)](https://querystreams.com/database-integrations/mariadb/)[![](https://querystreams.com/wp-content/uploads/2026/01/icon-airtable.png)](https://querystreams.com/features/automation-integration/)Automation · MariaDB to Airtable Keep *Airtable* in step with your MariaDB database, *on a schedule* Write the SQL once. Query Streams runs it on your schedule, anything from every five minutes to weekly, and writes the rows into your…"
url: "https://querystreams.com/docs/airtable-mariadb-integration/"
updated: "2026-11-09"
category: Automations / Airtable Automation
tags:
  - airtable
  - automation
  - "database-integration"
  - mariadb
  - "no-code"
---

# Sync MariaDB to Airtable on a Schedule

[![](https://querystreams.com/wp-content/uploads/2025/09/maria-db-40.png)](https://querystreams.com/database-integrations/mariadb/)[![](https://querystreams.com/wp-content/uploads/2026/01/icon-airtable.png)](https://querystreams.com/features/automation-integration/)Automation · MariaDB to Airtable

Keep *Airtable* in step with your MariaDB database, *on a schedule*

Write the SQL once. Query Streams runs it on your schedule, anything from every five minutes to weekly, and writes the rows into your Airtable table. Match rows by a key so edits land in place and rows that left the query are removed, or simply append. No Zapier, no scripts, no exports. About fifteen minutes the first time, and the Free plan covers it.

 About 15 minutes No coding needed Data stays on your network Every 5 minutes to weekly **Stuck at any point? Just ask us.** Open [Support](https://my.querystreams.com/support) in Query Streams (top-right menu → Support) and send us a message. Real people read it, and “I don’t know what this screen is asking for” is a perfectly good question. More for MariaDB[![](https://querystreams.com/wp-content/uploads/2025/09/my-sql-40.png)Running MySQL?](https://querystreams.com/docs/airtable-mysql-integration/)[![](https://querystreams.com/wp-content/uploads/2025/09/icons8-google-sheets-40.png)Google Sheets](https://querystreams.com/docs/how-to-connect-mariadb-to-google-sheets/)[![](https://querystreams.com/wp-content/uploads/2025/09/icons8-excel-40.png)Excel](https://querystreams.com/docs/how-to-connect-mariadb-to-microsoft-excel/)[![](https://querystreams.com/wp-content/uploads/2026/05/icons8-claude-48.png)Claude (MCP)](https://querystreams.com/docs/how-to-connect-mariadb-to-claude-via-mcp/)[![](https://querystreams.com/wp-content/uploads/2025/12/icons8-rest-api-64.png)REST API](https://querystreams.com/docs/expose-mariadb-as-rest-api/)[![](https://querystreams.com/wp-content/uploads/2026/08/database.png)Read-only login](https://querystreams.com/docs/create-a-read-only-database-user/)[![](https://querystreams.com/wp-content/uploads/2026/08/database.png)Open a firewall port](https://querystreams.com/docs/open-a-firewall-port-on-windows/)

## What you’ll end up with

![MariaDB logo](https://querystreams.com/wp-content/uploads/2025/09/maria-db-40.png)An Airtable table that holds the rows your MariaDB query returns and is brought up to date on a schedule, every five minutes to weekly, with a receipt of what changed on every run. Like this:

 ![](https://querystreams.com/wp-content/uploads/2026/01/icon-airtable.png) Orders to Airtable ActiveDaily sync · 09:00 · Airtable 1,643 rows · 8.8s**1,627**rows in syncmatched by key · nothing to do**11**newappended under your headers, same columns**5**updatedprices changed in MariaDB, 5 rows updated in place**0**removedrows leaving the query are removed from the table![](https://querystreams.com/wp-content/uploads/2025/08/cropped-Transparent-01.png) AutomationSource![](https://querystreams.com/wp-content/uploads/2025/09/maria-db-40.png) My MariaDB databaseTargetOrders · AirtableKeyorder_idScheduleDaily at 9 AMLast sync2m agoNext runtomorrow 09:00 Run

MariaDB holds your data on a server you or your team run. Your team works in Airtable. The usual bridge is a Zapier or Make scenario, or a CSV someone uploads that breaks quietly and copies one row at a time. Query Streams Automation does it differently: the Agent that already sits with your MariaDB database runs your saved SQL on a schedule and writes the whole result into Airtable in one pass, matching rows by a key so the table stays correct rather than growing.

The Agent lives with your data and runs the query when the schedule says so. Airtable just receives the rows. Nobody has to press anything.

## What you’ll need

### A Query Streams account

The Free plan is enough for this guide. Sign up at [my.querystreams.com](https://my.querystreams.com).

![](https://querystreams.com/wp-content/uploads/2025/09/maria-db-40.png)

### MariaDB connected through the Agent

The Agent installed where your MariaDB database is, with the connection added in Data Agents. Not done yet? [Connect MariaDB first](https://querystreams.com/docs/how-to-connect-mariadb-to-google-sheets/); it takes about ten minutes.

### A saved query

The SELECT you want to keep in sync, saved in [Query Builder](https://my.querystreams.com/query-builder). Step 1 below shows one. If you want changed rows updated in place, include a column that is unique per row, like an ID.

![](https://querystreams.com/wp-content/uploads/2026/01/icon-airtable.png)

### Your Airtable login

Airtable asks you to let Query Streams read and write records, and read and write table structure, in the bases you choose. A Personal Access Token works too if your workspace prefers it.

**Where does the work happen?** On the computer that runs the Agent. It runs the query on the schedule and writes the rows to Airtable, so that computer needs to stay on. Your browser can be closed. Query Streams itself never stores the rows.

## Set it up in six steps

1. ### Save the query you want to keep in sync

   Open [Query Builder](https://my.querystreams.com/query-builder), pick your MariaDB connection (not connected yet? [start here](https://querystreams.com/docs/how-to-connect-mariadb-to-google-sheets/)), and write the SELECT that returns exactly the rows and columns you want in Airtable. This one pulls a few columns from a **customers** table:
    Example · SQL
   ```
   SELECT customer_id, name, city
   FROM customers
   ORDER BY name
   LIMIT 100;
   ```

   Run it, then **Save** it with a name you will recognise, like “Orders for Airtable”. Keep a column that is unique per row in the SELECT, here **customer_id**. That is the key Full Sync uses to update rows in place. Edit and re-save the query later and the automation picks up the change on its next run.
2. ### Open Automation and choose Airtable

   In the portal, open [**Automation**](https://my.querystreams.com/automation/integrations) (top menu **Streams → Scheduled → Automation**) and click **New automation**. The wizard has five short steps. On **Step 1** click the **Airtable** card.
    [Open Automation](https://my.querystreams.com/automation/integrations)
   **Seeing “Before You Begin” instead?** The wizard only opens once an Agent is online with a connection and at least one saved query exists. The page lists which of the three is missing and links to it.
3. ### Connect Airtable

   On **Step 2** click **Connect with Airtable**. Airtable opens, asks which bases Query Streams may use, and sends you back. Airtable asks you to let Query Streams read and write records, and read and write table structure, in the bases you choose. A Personal Access Token works too if your workspace prefers it. Already connected once? The page offers **Use This Connection** instead.
4. ### Choose where the rows land

   On **Step 3** pick the **Base**, then the **Table** the rows should land in. Starting fresh is easiest: choose **Create New Table**, type a name and click **Create**; Query Streams creates the fields from your query’s columns. If the table already has rows, a preview shows them and explains what each sync mode would do to them. One automation per table.
5. ### Pick the query and decide how rows land

   On **Step 4** open the **Saved Query** list and choose the query from step 1. Query Streams runs it once to read the columns, tells you how many rows it returns, and shows two choices:
    Append · fast
   ### Append
   Every run adds the query’s rows to the bottom of the table. Nothing is updated and nothing is deleted, so it is the quick choice for logs, events and history you want to accumulate. No key column needed. A row that comes back unchanged is not added again; a row whose values changed is added below as a new line and the old one stays.
   Full Sync · mirrors
   ### Full Sync
   Rows are matched by a **key** column such as an order ID. New rows are added, changed rows are updated in place, and rows that no longer come back from the query are removed, including rows someone typed into the table by hand, so keep hand-made rows on another table. This is the choice for inventory, pipelines, master data and dashboards.
   Full Sync is set per column, which is what makes it useful in a shared table:
   **Key**
   : The column that identifies a row, for example **order_id**. It has to be unique in the query result; Query Streams checks that for you and refuses duplicates.
   **Sync**
   : Overwritten from MariaDB on every run. If someone edits a Sync column in Airtable, the next run puts the source value back.
   **Preserve**
   : Written when the row first arrives and never compared again, so a change to it in MariaDB does not trigger an update. For notes, owners and follow-up dates your team types by hand, use a column that is not in the query at all: columns that exist only in Airtable are never touched by a sync.
   **Which is faster?** Append writes without reading the table first. Full Sync reads it, compares every row, and writes only the differences, so it takes longer but the table always matches the query. You can switch later from the automation’s Edit panel.

   For a table you want to trust, click **Create all columns as Sync**, then click the key icon on **customer_id** to make it the **Key**. Query Streams scans the whole result to confirm the key is unique and warns you if it is not. Keep your team’s own notes in columns that are not part of the query; those are never touched. For a log that should only ever grow, click **Create all columns as Preserve** instead and skip the key. Click **Continue**.
6. ### Set the schedule, name it, create it

   On **Step 5** choose **Run on a schedule** and pick a **Frequency**:

   | Frequency | Runs |
   | --- | --- |
   | **Every 5 Minutes** | every 5 minutes, the fastest allowed |
   | **Every 15 Minutes** | every 15 minutes |
   | **Every 30 Minutes** | every 30 minutes |
   | **Every Hour** | at the top of every hour |
   | **Daily at 9 AM** | every day at 9:00, the default |
   | **Daily at 6 AM** | every day at 6:00 |
   | **Weekdays at 9 AM** | Monday to Friday at 9:00 |
   | **Weekly (Monday 9 AM)** | every Monday at 9:00 |
   | **Custom Schedule** | your own minutes, hours, days of the week or day of the month |
   Times follow the **Timezone** you pick, which starts as your browser’s. You can also choose **Manual only** and press **Run** whenever you like; a schedule can be added later from the automation’s Edit panel. Scheduled runs happen on the Agent, so they keep going while your browser is closed. If the computer running the Agent is off when a run is due, the missed run happens once, shortly after the Agent starts again.

   Give it an **Integration Name**, such as “Orders to Airtable, daily”, check the **Ready to Create** summary and click **Create Automation**. Back on the Automation page, press **Run** once to do the first sync now rather than waiting for the schedule. Open Airtable: the rows are there, under your column headers.

**That’s it.** From now on the table keeps itself current. Nothing left your network except the rows the query returned, and nobody has to remember to run anything.

## What you see afterwards

The [Automation page](https://my.querystreams.com/automation/integrations) lists every automation with its status, source, target, key, schedule, last sync and row count. Open one for the **Executions** tab: every run with its trigger (manual or scheduled), duration, and rows created, updated, deleted and unchanged. A **Performance** tab shows data processed and success rate over 7 to 90 days.

### You are told when it stops

Every organisation has a **Sync Issues** alert rule from day one: an in-app notice and an email when a sync fails, and one more when it recovers. One message per incident, never one per retry. Turn it off or change the channels under Streams → Alerts & Reports.

### It pauses itself when it should

If Airtable stops accepting the connection, or the data connector is deleted, the automation pauses and says why. Reconnect or pick a new source and press Resume. Other errors keep the schedule going and show on the row.

### Key column missing

If someone renames or deletes the key column in Airtable, Full Sync stops before writing anything and shows **Fix options**: put the column back with its exact name and run again. Your other columns are never deleted by a sync.

## What the plans allow

Automation is on every plan, including Free, with no limit on how many automations you create. What each plan limits is how many rows one query may return per run:

| Plan | Rows per run |
| --- | --- |
| Free | 125 |
| Personal Core | 500 |
| Personal Plus | 1,000 |
| Business Core | 2,500 |
| Business Plus | 5,000 |
| Business Max | 10,000 |
| Enterprise Core | 25,000 |
| Enterprise Plus | 100,000 |
| Enterprise Max | 250,000 |

If a query returns more, the run is held rather than cut short, and the automation tells you which plan fits or suggests adding a filter such as a date range. Each successful run also counts against your Data Realm allowance, the same pool your Excel and Sheets queries use. [See the pricing page](https://querystreams.com/pricing/) for the allowances.

## Good next moves

- **Add a filter** to the query, such as the last 90 days, so the table stays small and fast and fits your plan’s row limit.
- **Keep hand-typed notes in their own columns**, outside the query, so they survive every sync.
- **Group your automations** from the Edit panel once you have a few; the Automation page filters by group.

## Questions people ask

 Will the sync overwrite notes my team adds in Airtable?

Not if the notes live in their own column. Columns that exist only in Airtable and not in your query are never touched, so add a Notes or Owner column beside the synced ones and type there. Columns marked **Sync** are put back to the MariaDB value on every run; **Preserve** columns are filled when a row first arrives and are not compared afterwards.

Does my MariaDB data get stored by Query Streams?

No. The Agent runs the query on your side and sends the rows straight on to Airtable over an encrypted link. Query Streams keeps the configuration, the schedule and a count of rows per run, not the rows themselves.

Does my computer need to stay on?

The one running the Agent does, because the Agent is what runs the query and writes to Airtable. Your own laptop and browser can be closed. If that computer is off when a run is due, the missed run happens once, shortly after the Agent starts again.

Can I change the query later?

Yes. Edit and save it in Query Builder and the next run uses the new version automatically. If you add or remove columns, open the automation’s Edit panel to map them.

Can two automations write to the same table?

No, one automation per table. Point a second automation at a different table, or widen the query behind the first one.

Does the Free plan really cover this?

Yes. Free is a plan you keep, not a trial that expires. Automation is included on every plan; what changes by plan is how many rows one query may return per run. See exactly what Free includes on the [pricing page](https://querystreams.com/pricing/).

 **Still stuck?** Open [Support](https://my.querystreams.com/support) in Query Streams and tell us which step you are on and what you see. We will get you connected. [Create your Free plan account](https://my.querystreams.com)[See what Free includes](https://querystreams.com/pricing/)

## Related guides

- [MySQL to Airtable](https://querystreams.com/docs/airtable-mysql-integration/)
- [PostgreSQL to Airtable](https://querystreams.com/docs/airtable-postgresql-integration/)
- [Microsoft SQL Server to Airtable](https://querystreams.com/docs/airtable-sql-server-integration/)
- [MariaDB to Google Sheets](https://querystreams.com/docs/google-sheets-mariadb-integration/)
- [MariaDB to Smartsheet](https://querystreams.com/docs/smartsheet-mariadb-integration/)
- [How to connect MariaDB to Google Sheets](https://querystreams.com/docs/how-to-connect-mariadb-to-google-sheets/)
- [All Airtable automation guides](https://querystreams.com/docs-category/airtable-automation/)

 The same saved query can also be kept in step with[Google Sheets](https://querystreams.com/docs-category/google-sheet-automation/)[Smartsheet](https://querystreams.com/docs-category/smartsheet-automation/)[Baserow](https://querystreams.com/docs-category/baserow-automation/)[SeaTable](https://querystreams.com/docs-category/seatable-automation/)[Anvil.works](https://querystreams.com/docs-category/anvil-works-automation/)[and more](https://querystreams.com/features/automation-integration/)

Every guide for MariaDB

- [![](https://querystreams.com/wp-content/uploads/2025/09/icons8-excel-40.png)Excel](https://querystreams.com/docs/how-to-connect-mariadb-to-microsoft-excel/)
- [![](https://querystreams.com/wp-content/uploads/2025/09/icons8-google-sheets-40.png)Google Sheets](https://querystreams.com/docs/how-to-connect-mariadb-to-google-sheets/)
- [![](https://querystreams.com/wp-content/uploads/2026/05/icons8-claude-48.png)Claude (MCP)](https://querystreams.com/docs/how-to-connect-mariadb-to-claude-via-mcp/)
- [![](https://querystreams.com/wp-content/uploads/2025/12/icons8-rest-api-64.png)REST API](https://querystreams.com/docs/expose-mariadb-as-rest-api/)
- [![](https://querystreams.com/wp-content/uploads/2025/09/icons8-google-sheets-40.png)Sync to Google Sheets](https://querystreams.com/docs/google-sheets-mariadb-integration/)
- [![](https://querystreams.com/wp-content/uploads/2026/01/icon-smartsheet.png)Sync to Smartsheet](https://querystreams.com/docs/smartsheet-mariadb-integration/)
- [![](https://querystreams.com/wp-content/uploads/2026/01/icon-baserow.png)Sync to Baserow](https://querystreams.com/docs/baserow-mariadb-integration/)
- [![](https://querystreams.com/wp-content/uploads/2026/01/icon-seatable.png)Sync to SeaTable](https://querystreams.com/docs/seatable-mariadb-integration/)
- [![](https://querystreams.com/wp-content/uploads/2026/01/icon-anvilworks.png)Sync to Anvil.works](https://querystreams.com/docs/anvil-works-mariadb-integration/)

Not quite your setup?

- Running MySQL? Pick the MySQL card instead; the steps are the same → [MySQL](https://querystreams.com/docs/airtable-mysql-integration/)

Setup trouble?

- Want the Agent to sign in with a login that can only read? Create a read-only database user, with copy-paste SQL for each database → [Create a read-only database user](https://querystreams.com/docs/create-a-read-only-database-user/)
- Test connection cannot reach the database server? Open the database's port in Windows Defender Firewall on the computer it runs on → [Open a firewall port on Windows](https://querystreams.com/docs/open-a-firewall-port-on-windows/)
- Agent shows Offline, or Test connection and Browse are greyed out? Check that the Agent is online → [Is the Agent online?](https://querystreams.com/docs/is-the-agent-online/)
