Skip to main content

Introducing Query Streams - Automatic Database to Airtable Sync

  • January 22, 2026
  • 6 replies
  • 72 views
Q
Forum|alt.badge.img+1
Hi Airtable Community!
We're Query Streams, and we built a tool to automatically keep your Airtable bases updated with data from your databases and APIs.
What it does:
Connect your database or API to Airtable and set a schedule. Your bases stay updated automatically - no more manual imports or copy-pasting.
  • New records get added
  • Changed records get updated
  • Deleted records get removed (if you want)
Works with:
  • Databases: SQL Server, MySQL, PostgreSQL, Oracle, and many more
  • APIs: Google Analytics, HubSpot, Shopify, Stripe, ShipStation, and more coming
Schedule options:
Every few minutes, hourly, daily - whatever fits your workflow
Common uses:
  • Project data from ERP systems
  • Sales numbers from your CRM
  • Live inventory counts
  • Marketing metrics from Google Analytics
  • Order data from Shopify
We'd love your feedback:
  • What databases or APIs do you work with most?
  • What would make this useful for your team?
Check it out at querystreams.com - we have a free tier to get started.
Happy to answer any questions!

    6 replies

    Philip_Ade
    Forum|alt.badge.img+3
    • Philip_Ade
    • Participating Frequently
    • January 22, 2026

    Hi! This sounds useful, but to be a good fit for the Airtable community it would help to clarify a few things. How does Query Streams compare to existing tools like Airtable Sync, Automations, or third-party connectors such as Zapier or Make? How do you handle schema changes, large datasets, and API rate limits? Also, does it support two-way sync or only one-way into Airtable? A short concrete example and pricing limits of the free tier would make it easier for teams to evaluate.

    Philip_Ade
      Q
      Forum|alt.badge.img+1
      • querystreams
      • Author
      • New Participant
      • January 22, 2026
      Hi Philip! Great questions - thanks for helping clarify this for the community.
      How it differs from existing tools:
      • vs Airtable Sync: Query Streams connects to SQL databases and APIs that Airtable Sync doesn't support (like on-premise SQL Server, MySQL, PostgreSQL, Oracle, etc.)
      • vs Automations: We handle the scheduled querying and data transformation - you write a SQL query once and we keep it synced on whatever schedule you need
      • vs Zapier/Make: We're optimized for database sync specifically - can handle large datasets efficiently (thousands of rows), whereas Zapier/Make charge per record and can get expensive fast for bulk data
      Technical details:
      • Schema changes: You control the mapping - if your query returns new columns, you map them to Airtable fields. We don't auto-modify your base structure
      • Large datasets: We stream data efficiently and handle pagination automatically. We've synced tables with 50k+ rows without issue
      • Rate limits: We respect Airtable's API limits and batch requests appropriately. If you hit limits, we queue and retry
      • Direction: One-way only (source → Airtable). We're focused on bringing external data into your bases, not syncing changes back
      Concrete example:
      A customer syncs their SQL Server inventory database to Airtable every 15 minutes. Their SQL query pulls active products with stock levels, and we update ~2,000 records each sync. Their warehouse team updates the SQL database, and their sales team collaborates in Airtable with that live data
        Mike_AutomaticN
        Forum|alt.badge.img+28

        Hey ​@Philip_Ade,
         

        Do you happen to have a video doing a demo for an interesting use case? I think that would help! Checked out your site but did not find any.

        Mike, Consultant @ Automatic Nation 
        YouTube Channel 

          Q
          Forum|alt.badge.img+1
          • querystreams
          • Author
          • New Participant
          • January 22, 2026

          We do not have any videos currently, but we definitely need to make some. We just created our youtube channel so those may be coming in the future.

            G
            Forum|alt.badge.img+1
            • g58211702
            • Participating Frequently
            • January 25, 2026

            Nice concept, automatic syncing with full add, update, and delete support solves a real Airtable pain point. Curious how you handle large datasets, rate limits, and conflict resolution compared to native Airtable automations.

              Q
              Forum|alt.badge.img+1
              • querystreams
              • Author
              • New Participant
              • January 25, 2026
              Great question! Here are our actual benchmarks for Full Sync mode (clear table + insert all rows):
              Rows Sync Time
              100 ~8 sec
              500 ~40 sec
              1,000 ~1.5 min
              5,000 ~7 min
              10,000 ~14 min
              25,000 ~35 min

               

              This accounts for Airtable's 5 req/sec rate limit and 10-record batch size.

              Append mode is significantly faster since it skips the read + delete phase - roughly 2x the speed of full sync for the same row count.

               

              Issue is with Airtables API hit rate lmits. If they could open it up, that would be nice! =)

                Terms & ConditionsAccessibility statement