Real-Time Analytics: Live Database Queries and Streaming Data in Spreadsheets

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams is a secure, real-time database integration platform that delivers live data from any database directly into Microsoft Excel, Google Sheets, and AI-powered analytics — on demand, with no stale exports or scheduled delays. Learn more at QueryStreams.com and sign up for free to start querying your databases in real time.

“Real-time analytics” is one of the most overused terms in data tooling. Vendors label 15-minute scheduled refreshes as “real-time.” Dashboard platforms claim live data while silently caching results for hours. Meanwhile, the operations manager checking inventory at 2 PM is making decisions based on data pulled at 8 AM. This guide cuts through the noise: what real-time analytics actually means, why batch and scheduled approaches fail for time-sensitive work, and how Query Streams delivers genuinely live data through three distinct modes — on-demand queries, WebSocket streaming, and conversational AI analytics.

What Real-Time Analytics Actually Means

Real-time analytics is the ability to query, analyze, and act on data as it exists right now — not as it existed when someone last ran an export or a scheduled refresh triggered. The term covers a spectrum of freshness, and understanding where your tools fall on that spectrum matters for operational decisions.

Most analytics tools operate in the first two rows. They pull data on a schedule, cache the results, and show you what was true 15 minutes — or 15 hours — ago. For compliance reporting or end-of-day summaries, that works. For operational analytics where decisions depend on current inventory levels, today’s revenue, or live market prices, it does not.

Query Streams operates in the bottom two rows. Every query runs against your live database at the moment you request it. And for financial market data, the iTick WebSocket connector pushes sub-second price updates continuously — no refresh button needed.

Why Batch and Scheduled Tools Fail for Operational Decisions

Batch exports and scheduled refreshes were designed for a world where data changed slowly and decisions could wait until the next morning. That world no longer exists for most businesses. Consider these scenarios where stale data actively harms decision-making:

Inventory management: A warehouse manager checking stock levels in a spreadsheet exported at 6 AM may approve a purchase order for items that were already restocked at 10 AM. The data was accurate when it was pulled — but the decision is being made with six-hour-old information.

Financial trading: A portfolio analyst reviewing currency positions in a dashboard that refreshes every 30 minutes could miss a significant intraday move. In forex and crypto markets, 30 minutes of delay can represent meaningful price movement.

Sales operations: A sales director reviewing pipeline data in a scheduled report sees yesterday’s close numbers. Meanwhile, three large deals closed this morning — but the report won’t reflect them until the next refresh cycle. The 3 PM sales meeting proceeds with incomplete data.

The common thread: the tool is not broken, but the data is stale. Reporting automation built on batch exports inherits this staleness by design. Real-time analytics eliminates it by querying your database at the moment you need the answer.

Three Modes of Real-Time Data in Query Streams

Query Streams provides three distinct approaches to real-time analytics, each designed for different use cases and data freshness requirements:

Mode 1: On-Demand Live Queries in Excel and Google Sheets

The foundation of real-time analytics in Query Streams is the on-demand live query. When you click “Run” in the Excel add-in or Google Sheets add-on, the query travels to the Query Streams Agent running on your infrastructure, executes against your live database, and streams the results back to your spreadsheet. No intermediate cache. No scheduled pipeline. The data you see reflects the state of your database at the moment of execution.

This architecture supports over 10 database connectors: Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, BigQuery, DuckDB, and API connectors for SaaS platforms. The Agent runs on Windows, Linux, and macOS, connects outbound only (no firewall changes required), and self-updates automatically. Deploy multiple Agents across your infrastructure — on-premise, in AWS EC2, Azure VMs, Google Cloud, or any global environment — and they all appear as available data sources in a single dropdown list.

Queries support interactive filters so end users can adjust date ranges, regions, product categories, or any parameter without modifying SQL. Share a saved query with a teammate or external partner, and they run it from their own spreadsheet — selecting filters and getting fresh results independently, without ever seeing your SQL code or database credentials.

Mode 2: WebSocket Streaming with iTick

On-demand queries are “real-time” in the sense that every execution hits the live database. But they still require someone to click “Run.” For data that changes continuously — like financial market prices — you need data that flows without user action. That is what the iTick WebSocket connector provides.

iTick is a real-time market data provider that delivers forex currency pairs, cryptocurrency prices, stock quotes, and commodity prices via WebSocket connections. The Query Streams Agent maintains a persistent WebSocket connection to iTick’s data feed and pushes sub-second price updates directly into your Microsoft Excel or Google Sheets spreadsheet. Prices update as they change in the market — no refresh button, no polling interval, no manual action.

This is fundamentally different from tools that poll an API every 5 or 15 minutes. WebSocket is a persistent, bidirectional connection: the server pushes new data the instant it becomes available. There is no request/response cycle, no interval timer, and no wasted bandwidth from polling when nothing has changed. For forex traders tracking EUR/USD, crypto analysts monitoring BTC/USD, or portfolio managers watching equity positions, the difference between sub-second streaming and 15-minute polling is the difference between actionable and historical.

Mode 3: Nova AI — Conversational Real-Time Analytics

The third mode of real-time analytics in Query Streams is Nova AI, a conversational analytics engine that connects directly to your live database. Ask a question in plain English — “What were our top 10 products by revenue this week?” — and Nova reads your actual database schema, generates dialect-correct SQL (T-SQL for SQL Server, PL/pgSQL for PostgreSQL, MySQL syntax for MySQL, and so on), validates the query against your real tables and columns, executes it against your live data, and returns results with auto-generated charts.

Nova supports six chart types — bar, line, pie, area, scatter, and table — selected automatically based on the shape of your data. Ask for a time series and Nova generates a line chart. Ask for a ranking and you get a horizontal bar chart. Ask for composition and it produces a pie chart. You can switch types with a follow-up message or ask Nova to “show this as a line chart instead.” Every chart is generated from your live query results, not a cached snapshot.

The conversational aspect is what separates Nova from static BI dashboards. After seeing initial results, you refine: “Now break this down by region,” or “Only show customers who signed up in the last 90 days.” Nova iterates on the previous query context, runs the refined SQL, and presents updated results. It also analyzes the data in natural language — identifying anomalies, trends, and actionable patterns that raw numbers might not make obvious.

Reporting Automation That Stays Current

Real-time on-demand queries address the freshness problem when a human is present to click “Run.” But what about reports that need to reach inboxes or update platforms on a schedule? Query Streams handles reporting automation through scheduled sync, which executes your saved queries on a defined cadence and pushes results to destinations including Airtable, Smartsheet, Baserow, and SeaTable.

The key difference between Query Streams’ reporting automation and traditional batch export pipelines: each scheduled execution runs a live query against your database at that moment. There is no intermediate data warehouse, no ETL pipeline introducing additional lag, and no cached layer between the schedule trigger and the database. If your scheduled report fires at 9:00 AM, it queries the database at 9:00 AM and delivers results that reflect 9:00 AM data — not data from a 6:00 AM batch extract.

Combine scheduled delivery with on-demand access: the 9 AM report runs automatically, but any recipient can also open Excel or Google Sheets at 2 PM and run the same query on-demand to get an afternoon update. Scheduled reporting and real-time on-demand access are not mutually exclusive — they complement each other. Build your operational analytics around both: automated baseline reports that arrive on schedule, plus the ability for anyone to pull fresh data whenever they need it.

Operational Analytics Use Cases

Real-time analytics and reporting automation serve different roles across an organization. Here’s how teams use each mode of Query Streams for operational decision-making:

Who This Is For

Operations teams that need current data for intraday decisions — inventory, logistics, support ticket volumes — and cannot wait for scheduled dashboard refreshes. On-demand live queries in Excel and Google Sheets give you the freshest data your database has, anytime.

Financial analysts and traders who need sub-second market data in their spreadsheets. The iTick WebSocket connector streams forex, crypto, equities, and commodities directly into Excel without terminal software fees or API coding.

Business analysts and data teams who build reports for others and want those reports to always reflect current data. Save queries with parameters, share them across the organization, and let recipients run them on-demand in their own spreadsheet. Combine with scheduled automation for recurring delivery.

Small businesses without a data team that need analytics from their PostgreSQL, MySQL, or SQL Server databases. Nova AI lets anyone ask questions in plain English and get live results with charts — no SQL expertise required, no BI tool to configure.

Who Should Look Elsewhere

How to Get Started

Step 1: Install the Query Streams Agent. Sign up at my.querystreams.com and download the Agent onto any machine that can reach your database. The Agent connects outbound only — no firewall changes, no VPN configuration. It runs on Windows, Linux, and macOS, and supports SQL Server, PostgreSQL, MySQL, MariaDB, Oracle, Snowflake, BigQuery, DuckDB, SQLite, Microsoft Access, and the iTick WebSocket connector for live market data.

Step 2: Connect your data sources. Add your database connections through the Agent’s local web interface. Each connector becomes available as a data source across the platform — in the Excel add-in, Google Sheets add-on, Nova AI, web dashboard, and scheduled automation. Deploy multiple Agents across different environments and they all present their data sources in a unified dropdown list.

Step 3: Query in real time. Open the Excel add-in or Google Sheets add-on, select a data source, and run your first query. Results stream directly into your spreadsheet from your live database. For market data, configure the iTick WebSocket connector and watch prices flow in continuously. For AI-driven analytics, open Nova AI and ask your first question in plain English.

Frequently Asked Questions

Get Started with Real-Time Analytics

Related guides: Databases in Microsoft Excel | Databases in Google Sheets | BI and AI Data Analytics | Database Dashboard | Schedule SQL Reports | Download the Agent

Category: Articles

Tags: real time analytics, reporting automation, operational analytics, live database queries, streaming data, WebSocket, iTick, Nova AI, Excel, Google Sheets, parallel execution, on-demand queries

Meta Description: Live database queries, WebSocket streaming, and AI analytics in Excel and Google Sheets. Real-time data, not stale exports.