What does real-time analytics mean in Query Streams?

It means every query executes against your live database at the moment you run it -- no caching layer, no intermediate warehouse, no scheduled delay. When you click Run in Excel or Google Sheets, the query travels to the Agent on your network, hits the database, and streams results back. For market data via the iTick WebSocket connector, updates arrive sub-second without any user action.

How fresh is the data when I run a query?

The data reflects the state of your database at the exact moment of query execution. Query Streams adds no artificial delay or cache between your query request and the database response. The only latency is network round-trip time between the Agent and your database.

What is iTick WebSocket streaming?

iTick is a real-time market data provider. The Query Streams Agent includes a WebSocket connector that maintains a persistent connection to iTick's data feed, receiving sub-second price updates for forex pairs, cryptocurrencies, equities, and commodities directly into Excel or Google Sheets.

Can I stream live market data into Microsoft Excel?

Yes. Configure the iTick WebSocket connector in the Query Streams Agent, select the symbols you want to track, and the Excel add-in receives streaming price data. Forex pairs, crypto, U.S. equities, and commodities are available with sub-second latency.

How does parallel query execution work?

You can launch up to 5 saved queries simultaneously from the Excel add-in or Google Sheets add-on. Each query targets a different worksheet tab, and the Agent streams all results concurrently regardless of result size.

Is real-time analytics different from scheduled reports?

They complement each other. Scheduled reports run queries on a cadence and push results to platforms. On-demand queries let any user pull fresh data whenever they need it. Both run live queries against your database -- the only difference is who triggers the execution: a schedule or a human.

Which databases support on-demand live queries?

All databases supported by Query Streams: Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, BigQuery, and DuckDB. API connector data from Stripe, HubSpot, Shopify, and others is also queryable on-demand.

Does Nova AI work with real-time data?

Yes. Every Nova AI query executes against your live database through the Agent. Nova generates SQL, runs it against current data, and returns results with charts and natural-language analysis.

Is there a free tier for real-time analytics?

Query Streams offers a free tier that includes on-demand live queries from a single Agent and data source. Nova AI is available on Business and Enterprise plans. The iTick WebSocket connector is available as an additional data source.

How does this compare to Power BI real-time dashboards?

Power BI real-time dashboards require a Pro or Premium license, a streaming dataset, and often Azure infrastructure. Query Streams delivers live data directly into Excel and Google Sheets without additional licensing or cloud infrastructure. Different tools for different needs.

Operational Analytics - Live Operational Data in Spreadsheets

Skip to content

Home
Features
Connectors
Pricing
Support
- Contact
- Docs

Get Started

Home
Features
Connectors
Pricing
Support
- Contact
- Docs

Setup

5

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

20

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
Stop Struggling with Google Apps Script JDBC
SQL Global Database Access Without Drivers or Gateways
Microsoft Excel Power Query Alternative
Power Query for Google Sheets

Airtable Automation

16

Airtable Google Search Console Integration – Sync Live Search Data Automatically
Airtable Google Analytics Integration – Sync Live Analytics Data Automatically
Airtable ShipStation Integration – Sync Live Shipping Data Automatically
How to Connect HubSpot to Airtable (2026) — Auto-Sync CRM Data, No Zapier
Airtable Shopify Integration – Sync Live E-commerce Data Automatically
Airtable Stripe Integration – Sync Live Payment Data Automatically
Airtable SQL Server Integration – Sync Live Database Data Automatically
Airtable PostgreSQL Integration – Sync Live Database Data Automatically
Airtable DuckDB Integration – Sync Live Database Data Automatically
Airtable BigQuery Integration – Sync Live Database Data Automatically
Airtable Snowflake Integration – Sync Live Database Data Automatically
Airtable Oracle Integration – Sync Live Database Data Automatically
Airtable Microsoft Access Integration – Sync Live Database Data Automatically
Airtable SQLite Integration – Sync Live Database Data Automatically
Airtable MariaDB Integration – Sync Live Database Data Automatically
Airtable MySQL Integration – Sync Live Database Data Automatically

Anvil.works automation

16

Anvil.works Google Search Console Integration – Sync Live Search Data Automatically
Anvil.works Google Analytics Integration – Sync Live Analytics Data Automatically
Anvil.works ShipStation Integration – Sync Live Shipping Data Automatically
Anvil.works HubSpot Integration – Sync Live CRM Data Automatically
Anvil.works Shopify Integration – Sync Live E-commerce Data Automatically
Anvil.works Stripe Integration – Sync Live Payment Data Automatically
Anvil.works SQL Server Integration – Sync Live Database Data Automatically
Anvil.works PostgreSQL Integration – Sync Live Database Data Automatically
Anvil.works DuckDB Integration – Sync Live Database Data Automatically
Anvil.works BigQuery Integration – Sync Live Database Data Automatically
Anvil.works Snowflake Integration – Sync Live Database Data Automatically
Anvil.works Oracle Integration – Sync Live Database Data Automatically
Anvil.works Microsoft Access Integration – Sync Live Database Data Automatically
Anvil.works SQLite Integration – Sync Live Database Data Automatically
Anvil.works MariaDB Integration – Sync Live Database Data Automatically
Anvil.works MySQL Integration – Sync Live Database Data Automatically

Baserow Automation

16

Baserow Google Search Console Integration – Sync Live Search Data Automatically
Baserow Google Analytics Integration – Sync Live Analytics Data Automatically
Baserow ShipStation Integration – Sync Live Shipping Data Automatically
Baserow HubSpot Integration – Sync Live CRM Data Automatically
Baserow Shopify Integration – Sync Live E-commerce Data Automatically
Baserow Stripe Integration – Sync Live Payment Data Automatically
Baserow SQL Server Integration – Sync Live Database Data Automatically
Baserow PostgreSQL Integration – Sync Live Database Data Automatically
Baserow DuckDB Integration – Sync Live Database Data Automatically
Baserow BigQuery Integration – Sync Live Database Data Automatically
Baserow Snowflake Integration – Sync Live Database Data Automatically
Baserow Oracle Integration – Sync Live Database Data Automatically
Baserow Microsoft Access Integration – Sync Live Database Data Automatically
Baserow SQLite Integration – Sync Live Database Data Automatically
Baserow MariaDB Integration – Sync Live Database Data Automatically
Baserow MySQL Integration – Sync Live Database Data Automatically

Query Streams docs category icon for Google Sheets automation, showing a cell grid with scheduled refresh arcs and the Google Sheets mark

Google sheet Automation

16

Google Sheets Google Search Console Integration – Sync Live Search Data Automatically
Google Sheets Google Analytics Integration – Sync Live Analytics Data Automatically
Google Sheets ShipStation Integration – Sync Live Shipping Data Automatically
Google Sheets HubSpot Integration – Sync Live CRM Data Automatically
Google Sheets Shopify Integration – Sync Live E-commerce Data Automatically
Google Sheets Stripe Integration – Sync Live Payment Data Automatically
Google Sheets SQL Server Integration – Sync Live Database Data Automatically
Google Sheets PostgreSQL Integration – Sync Live Database Data Automatically
Google Sheets DuckDB Integration – Sync Live Database Data Automatically
Google Sheets BigQuery Integration – Sync Live Database Data Automatically
Google Sheets Snowflake Integration – Sync Live Database Data Automatically
Google Sheets Oracle Integration – Sync Live Database Data Automatically
Google Sheets Microsoft Access Integration – Sync Live Database Data Automatically
Google Sheets SQLite Integration – Sync Live Database Data Automatically
Google Sheets MariaDB Integration – Sync Live Database Data Automatically
Google Sheets MySQL Integration – Sync Live Database Data Automatically

SeaTable Automation

16

SeaTable Google Search Console Integration – Sync Live Search Data Automatically
SeaTable Google Analytics Integration – Sync Live Analytics Data Automatically
SeaTable ShipStation Integration – Sync Live Shipping Data Automatically
SeaTable HubSpot Integration – Sync Live CRM Data Automatically
SeaTable Shopify Integration – Sync Live E-commerce Data Automatically
SeaTable Stripe Integration – Sync Live Payment Data Automatically
SeaTable SQL Server Integration – Sync Live Database Data Automatically
SeaTable PostgreSQL Integration – Sync Live Database Data Automatically
SeaTable DuckDB Integration – Sync Live Database Data Automatically
SeaTable BigQuery Integration – Sync Live Database Data Automatically
SeaTable Snowflake Integration – Sync Live Database Data Automatically
SeaTable Oracle Integration – Sync Live Database Data Automatically
SeaTable Microsoft Access Integration – Sync Live Database Data Automatically
SeaTable SQLite Integration – Sync Live Database Data Automatically
SeaTable MariaDB Integration – Sync Live Database Data Automatically
SeaTable MySQL Integration – Sync Live Database Data Automatically

Smartsheet Automation

16

Smartsheet SQL Server Integration – Sync Live Database Data Automatically
Smartsheet Google Search Console Integration – Sync Live Search Data Automatically
Smartsheet Google Analytics Integration – Sync Live Analytics Data Automatically
Smartsheet ShipStation Integration – Sync Live Shipping Data Automatically
Smartsheet HubSpot Integration – Sync Live CRM Data Automatically
Smartsheet Shopify Integration – Sync Live E-commerce Data Automatically
Smartsheet Stripe Integration – Sync Live Payment Data Automatically
Smartsheet DuckDB Integration – Sync Live Database Data Automatically
Smartsheet BigQuery Integration – Sync Live Database Data Automatically
Smartsheet Snowflake Integration – Sync Live Database Data Automatically
Smartsheet Oracle Integration – Sync Live Database Data Automatically
Smartsheet Microsoft Access Integration – Sync Live Database Data Automatically
Smartsheet SQLite Integration – Sync Live Database Data Automatically
Smartsheet MariaDB Integration – Sync Live Database Data Automatically
Smartsheet MySQL Integration – Sync Live Database Data Automatically
Smartsheet PostgreSQL Integration – Sync Live Database Data Automatically

Data

2

Share Live Data, Not Credentials
WordPress MySQL server using Query Streams, hosted on Siteground

MCP Server

16

How to Query Stripe Data with Claude / Cursor via MCP (Stripe MCP Server Setup)
How to Query Shopify Data with Claude / Cursor via MCP (Shopify MCP Server Setup)
How to Connect Snowflake to Claude / Cursor via MCP (Snowflake MCP Server Setup)
How to Query HubSpot CRM Data with Claude / Cursor via MCP (HubSpot MCP Server Setup)
How to Connect DuckDB to Claude / Cursor via MCP (DuckDB MCP Server Setup)
How to Connect BigQuery to Claude / Cursor via MCP (BigQuery MCP Server Setup)
How to Connect MySQL to Claude / Cursor via MCP (MySQL MCP Server Setup)
How to Connect Microsoft SQL Server to Claude / Cursor via MCP (SQL Server MCP Server Setup)
How to Query Google Analytics 4 with Claude / Cursor via MCP (Google Analytics MCP Server Setup)
How to Connect Microsoft Access to Claude / Cursor via MCP (Microsoft Access MCP Server Setup)
How to Connect Oracle Database to Claude / Cursor via MCP (Oracle MCP Server Setup)
How to Query Google Ads with Claude / Cursor via MCP (Google Ads MCP Server Setup)
How to Connect SQLite to Claude / Cursor via MCP (SQLite MCP Server Setup)
How to Connect MariaDB to Claude / Cursor via MCP (MariaDB MCP Server Setup)
How to Connect PostgreSQL to Claude or Cursor via MCP
How to Query Google Search Console with Claude or Cursor via MCP

RestAPI Platform

13

Power BI REST API: Connect Live SQL Data Without ODBC Drivers
How to Build a Stripe Reporting API for Partners
How to Expose a MariaDB Database as a Secure REST API
How to Expose a BigQuery Dataset as a Secure REST API
How to Expose a MySQL Database as a Secure REST API
How to Expose a Microsoft SQL Server Database as a Secure REST API
How to Expose an Oracle Database as a Secure REST API
How to Expose a Snowflake Database as a Secure REST API
How to Expose a Microsoft Access Database as a Secure REST API
How to Expose a SQLite Database as a Secure REST API
How to Expose a DuckDB Database as a Secure REST API
How to Expose a PostgreSQL Database as a Secure REST API
Instant REST API for popular SQL databases — how Query Streams turns a saved query into a partner-ready endpoint