What is database automation and how does it differ from ETL?

Database automation refers broadly to using software to perform recurring database tasks without manual intervention â€” including scheduled query execution, data delivery, and report distribution. ETL (Extract, Transform, Load) is a specific type of data pipeline that extracts data from source systems, transforms it (cleaning, aggregating, restructuring), and loads it into a destination like a data warehouse. Query Streams focuses on the query-to-delivery pipeline: executing SQL and delivering raw or filtered results directly to spreadsheets and collaboration platforms. If you need heavy transformations between source and destination, a traditional ETL tool may be more appropriate, but for delivering query results on a schedule, Query Streams eliminates the need to build and maintain ETL infrastructure.

How do I schedule a SQL report to run automatically?

In the Query Streams web portal , create a saved query by writing your SQL and configuring any interactive filters. Then navigate to the Automation settings for that query, define a schedule (daily, weekly, monthly, or custom), and select one or more delivery destinations â€” such as an Airtable base, Smartsheet sheet, Baserow table, or SeaTable table. The Query Streams Agent executes the query on the defined schedule and pushes results to each configured destination automatically. Users can also pull data on demand from the Excel add-in or Google Sheets add-on at any time between scheduled runs.

Which databases does Query Streams support for scheduled automation?

Query Streams supports Microsoft SQL Server (including Azure SQL Database), PostgreSQL (including AWS RDS, Google Cloud SQL), MySQL , MariaDB , SQLite , Microsoft Access , Oracle , Snowflake , Google BigQuery , and DuckDB . A single Agent installation can connect to multiple database engines simultaneously, and all data sources appear as a unified dropdown in the query builder. More database integrations are coming soon.

Can I sync SQL results to Airtable and Smartsheet automatically?

Yes. Query Streams' Automation and Integration feature supports scheduled sync to Airtable, Smartsheet, Baserow, and SeaTable. You configure the destination in the web portal â€” specifying which Airtable base/table or Smartsheet sheet receives the data â€” and set a sync schedule. The Agent executes the query and pushes results directly into the destination platform without any intermediary scripts, Zapier automations, or custom API integrations.

Does Query Streams require inbound firewall rules or VPN access?

No. The Query Streams Agent makes outbound-only connections on standard HTTPS/WSS ports. No inbound firewall rules, no port forwarding, and no VPN tunnels are required. Your database never accepts connections from the internet. The Agent behaves like a web browser connecting to an external service â€” it works behind corporate firewalls, NATs, and proxy servers without any special network configuration. This makes it suitable for deployment in highly restricted enterprise environments.

Can I automate reports from SaaS platforms like Stripe and HubSpot?

Yes, through the API Bridge . Query Streams can connect to SaaS platforms including Stripe, HubSpot, Shopify, and Google Analytics 4 and expose their data as queryable SQL tables. You write SQL against your SaaS data the same way you query a traditional database, and the results flow through the same scheduling and delivery pipeline. You can even join SaaS data with your internal database tables in a single query.

How is Query Streams different from using cron jobs or SSIS?

Cron jobs and SSIS packages require scripting, server maintenance, and manual credential management for every automated report. Query Streams replaces the script-per-report pattern with a visual, web-based configuration: write a query, set a schedule, pick destinations. There is no crontab syntax, no Python scripts, no deployment pipelines, and no credentials stored in config files. Database passwords stay on the Agent and are never shared. Query Streams also adds built-in execution logging, multi-destination delivery from a single query, and end-user self-service from spreadsheets â€” capabilities that cron and SSIS do not provide out of the box.

Can multiple users refresh data at the same time?

Yes. Query Streams supports parallel query execution . Individual users can launch multiple saved queries simultaneously into different worksheet tabs in Excel or Google Sheets, and the Agent streams each result concurrently regardless of data volume. Multiple users can also pull data from the same or different queries at the same time without queuing or blocking each other. This makes batch refresh operations fast even for large teams with many reports.

What operating systems does the Query Streams Agent support?

The Agent is available for Windows (exe installer), Ubuntu/Debian Linux (deb package), any Linux distribution (tar.gz archive), and macOS for both Intel and Apple Silicon. You can deploy agents on-premises, in AWS EC2, Azure VMs, Google Cloud, or any other environment. Multiple agents per account are supported based on your subscription tier, and all agents self-maintain with automatic updates. Download the Agent to get started.

Is database automation with Query Streams free to try?

Yes. Query Streams offers a free tier that lets you deploy an Agent, connect data sources, build saved queries, and use the Excel and Google Sheets integrations. You can sign up for free and start automating data delivery without entering a credit card. Paid plans unlock additional features including more agents, more users, advanced scheduling, and expanded sync destinations.

Database Automation - Schedule SQL Queries and Reports

Skip to content

Home
Features
Connectors
Pricing
Support
- Contact
- Docs

Get Started

Home
Features
Connectors
Pricing
Support
- Contact
- Docs

Setup

6

Is the Agent Online? What Offline Means and How to Fix It
How to Install the Query Streams Agent on Windows
How to Install the Query Streams Agent on Linux
How to Install the Query Streams Agent on macOS
Query Streams Access Level Permissions: Complete User Role Management Guide
How to Install the Query Streams Google Sheets Addon

Nova AI

8

Nova Concierge Mode: A Personal Data Analyst for Every User
Nova Taught Knowledge: How Verified Learning Works
How Nova AI Learns Your Database Schema Automatically
AI Data Analytics: Query Any Database Without a BI Tool
BI and Data Analytics Without Tableau or Power BI
Text to SQL: How Nova AI Turns Questions Into Database Queries
AI Powered Analytics: Ask Questions, Get SQL + Charts
Natural Language to SQL: How Nova AI Turns Questions Into Database Queries

API to SQL Connector Setup

14

How to Connect iTick to Google Sheets — Live Stocks, Crypto, and Forex Data
How to Connect iTick to Microsoft Excel — Live Stocks, Crypto, and Forex Data
How to Connect Google Analytics to Google Sheets – Query Web Analytics with SQL
How to Connect Google Analytics to Excel – Query Web Analytics with SQL
How to Connect Google Search Console to Google Sheets – Query SEO Data with SQL
How to Connect Google Search Console to Excel – Query SEO Data with SQL
How to Connect HubSpot to Google Sheets – Query CRM Data with SQL
How to Connect HubSpot to Excel – Query CRM Data with SQL
How to Connect ShipStation to Excel – Query Shipping Data with SQL
How to Connect ShipStation to Google Sheets – Query Shipping Data with SQL
How to Connect Shopify to Google Sheets – Query E-Commerce Data with SQL
How to Connect Shopify to Excel – Query E-Commerce Data with SQL
How to Connect Stripe to Google Sheets – Query Payment Data with SQL
How to Connect Stripe to Excel – Query Payment Data with SQL

Data Connector Setup

26

Set up the PostgreSQL connector
Set Up the Microsoft SQL Server Connector: Server Name, SQL Express, Logins and Cloud
Open a Firewall Port on Windows for SQL Server, PostgreSQL, MySQL or Oracle
Create a read-only database user for the Agent
Where the Agent Can Read Files From: Drive Letters, Shares, Cloud Folders, Mac and Linux
Set Up the Microsoft Access Connector: Database Engine and File Path
How to Connect BigQuery to Google Sheets – Stream Live Data Warehouse Analytics
How to Connect Oracle to Google Sheets – Stream Live Enterprise Database Data
How to Connect Oracle to Excel – Stream Live Enterprise Database Data
How to Connect BigQuery to Excel – Stream Live Data Warehouse Analytics
How to Connect DuckDB to Google Sheets – Stream Live Analytics Database Data
How to Connect DuckDB to Excel – Stream Live Analytics Database Data
How to Connect Snowflake to Excel – Stream Live Data Warehouse Analytics
How to Connect Snowflake to Google Sheets – Stream Live Data Warehouse Analytics
How to Connect Microsoft Access to Excel – Stream Live Database Data
How to Connect Microsoft Access to Google Sheets – Stream Live Database Data
How to Connect MariaDB to Google Sheets – Stream Live Database Data
How to Connect MariaDB to Excel – Stream Live Database Data
How to Connect MySQL to Google Sheets – Stream Live Database Data
How to Connect MySQL to Excel – Stream Live Database Data
How to Connect SQLite to Google Sheets – Stream Live Lightweight Database Data
How to Connect SQLite to Excel – Stream Live Lightweight Database Data
How to Connect PostgreSQL to Google Sheets – Stream Live Database Data
How to Connect PostgreSQL to Excel – Stream Live Database Data
How to Connect Microsoft SQL Server to Google Sheets – Stream Live Database Data
How to Connect Microsoft SQL Server to Excel – Stream Live Database Data

Articles

51

Airtable Automation — Sync Live Database and API Data Automatically
Real-Time Analytics: Live Database Queries and Streaming Data in Spreadsheets
Excel Automation: Automate Live Database Reports Without Macros or VBA
ETL Tools Alternative: Skip the Pipeline, Query Your Database Live
Data Visualization Tools: Create Charts & Dashboards from Live SQL Queries
Data Integration Platform: Connect Any Database to Excel, Sheets & More
Database Analytics: Query, Analyze & Visualize Your Data Without a BI Platform
Data Democratization: Give Every Team Member Access to Database Insights
Data Analytics Platform: SQL-Powered Analytics for Every Database
Business Intelligence Software: Lightweight BI for Teams That Don’t Need Tableau
BI Tools for Spreadsheet Users: Real Analytics Without Leaving Excel or Google Sheets
Smartsheet Database Automation — Sync Live SQL Data Without Zapier
ODBC Alternative for Google Sheets
SeekWell Alternative — SQL to Spreadsheets Without Slack
SQL Server Reporting Without SSRS: Live Reports in Excel and Google Sheets
Oracle Reporting: Live Oracle Data in Excel and Google Sheets
Mixed Analytics Alternative for Google Sheets
Microsoft Access Reports: Build Better Reports from Your Access Database
Flatly Alternative for Google Sheets — Live SQL Without CSV Exports
Database Reporting Tool: SQL Reports Without a BI Platform
Database Automation: Schedule SQL Reports to Excel, Sheets and Airtable
Database Dashboard: Build Live SQL Dashboards in Excel and Google Sheets
Data Query in Excel: Pull Live Database Results into Any Spreadsheet
Connect REST APIs to Excel Without VBA or Power Query
Conversational BI: Query Any Database in Plain English
Airtable Reporting: Sync Live Database Results to Airtable
Connect Cloud Databases to Excel and Google Sheets (AWS RDS, Azure SQL, Google Cloud SQL)
Apipheny Alternative — API to Sheets Without Limits
Build No-Code Database Apps with Live SQL Data
Query Streams vs Coupler.io: Which Data Connector Is Right for You?
Skyvia Alternative 2026: Live Database Queries Without ETL
Google Sheets Reporting: Automate Live Database Reports
How to Import Any Database into Excel
Database vs Spreadsheet: When to Use Each and How to Connect Them
How to Run SQL Queries in Excel
SQL Reporting: Build Live Database Reports Without a BI Tool
Google Sheets Database 2026: Connect Any SQL Database to Sheets
Data Analytics to Increase Sales: Live CRM and Database Reporting in Sheets and Excel
Database Automation for IT Teams and DBAs: Secure Self-Service Data Access
BI Tools for Small Business: Analytics in Excel and Sheets Without Expensive Software
Financial Data Analytics: Live Database Queries in Excel and Google Sheets
SQL for Data Analysts: Live Database Queries in Excel and Google Sheets
Coefficient for Google Sheets: A Smarter Alternative for Database Users
ODBC Driver for Excel: Why You Don’t Need One Anymore
Supermetrics Alternative: SQL Databases + APIs in One Platform
Power BI Alternative: Live SQL in Excel & Google Sheets
Share ERP Data with External Partners Without System Access
Run SQL in Google Sheets Without Apps Script JDBC
SQL Global Database Access Without Drivers or Gateways
Microsoft Excel Power Query Alternative
Power Query for Google Sheets