Introducing Query Streams - Automatic Database to SeaTable Sync

Developer Talk
1

Hi SeaTable Community!

We’re Query Streams, and we built a tool to automatically keep your SeaTable bases updated with data from your databases and APIs.

What it does:

Connect your database or API to SeaTable 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!

2 Likes
2

@querystreams that sound very good. Thanks for including the Seatable Ecosystem.

As a public administration Seatable Enterprise customer, on question: Where does querystreams run? Cloud? On Premise as well? We are very restricted because our Seatable server is behind an inpenetrable firewall.

3

Hi @abaer! Great question - this is actually one of our core design principles.

How it works:

Query Streams uses a lightweight agent that you install on your network (behind your firewall). The agent:

  • Runs on-premise on Windows (Linux coming soon)
  • Makes outbound connections only (no inbound firewall rules needed)
  • Connects to your databases locally on your network
  • Your database credentials never leave your network

The cloud part:

  • Our web portal (my.querystreams.com) is where you configure your queries and schedules
  • The agent checks in with the portal to get instructions
  • All actual data processing happens on your agent - data flows directly from your database to SeaTable

Important note for your setup:

Currently we support SeaTable Cloud. Self-hosted SeaTable is on our roadmap, but not available yet. If you’re running SeaTable on-premise behind your firewall, we can’t connect to it at the moment - but we’d love to understand your use case better as we plan that feature!

Security-focused customers love this because:

  • No VPN required
  • No firewall changes for database access
  • Database credentials stay internal
  • You control where the agent runs

Would self-hosted SeaTable support be valuable for your organization? Happy to discuss your requirements and timeline!

2 Likes
4

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.