Data Analytics Platform: SQL-Powered Analytics for Every Database

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, SQL-powered data analytics platform that connects any database to the tools your team already uses. Install a lightweight Agent on your network, build or generate queries through a web portal with AI assistance, and deliver live results directly to Microsoft Excel and Google Sheets — no VPN changes, no data exports, no BI licenses. Learn more at QueryStreams.com and sign up for free to start building your analytics stack.

What Makes a Data Analytics Platform

A data analytics platform is the layer between your raw databases and the people who need answers from them. At minimum, it handles connectivity (getting data out of databases securely), querying (writing or generating SQL), analysis (understanding what the data means), and delivery (putting results where people actually work). Most platforms handle one or two of these well and hand the rest off to other tools, other vendors, or your engineering team.

The analytics platform market has grown rapidly. According to Gartner, the global analytics and business intelligence market exceeds $28 billion annually, yet adoption among non-technical business users remains below 35%. The gap is not about demand — it is about accessibility. Most platforms still assume their users can write code, model data, or navigate complex interfaces. The organizations that close this gap are the ones that treat analytics as a workflow problem, not a technology problem.

What Traditional Analytics Platforms Get Wrong

There is no shortage of analytics platforms. Tableau, Power BI, Looker, Metabase, Apache Superset, and dozens of others compete for the same use case. They are powerful tools. But they share a set of assumptions that limit how many people in an organization can actually use them — and how quickly anyone can get from question to answer.

They build walled gardens around your data. Results live inside proprietary dashboards that require licensed access to view, filter, or export. When a stakeholder needs the data in a spreadsheet — which they almost always do — someone has to export a CSV and email it. The data is stale before it arrives.

They require data modeling before anyone can ask a question. Before a single chart appears, someone has to define relationships, build measures, create calculated fields, and publish a semantic model. This front-loaded investment means new questions that fall outside the model require another engineering cycle.

They charge per seat. Tableau Creator costs $75/user/month. Power BI Pro is $10/user/month but Premium Per User jumps to $20+. For a 50-person finance team that needs access to quarterly reports, annual BI licensing alone can exceed $45,000 — and that is before implementation, training, and data engineering time.

They assume cloud-hosted data. Many modern analytics platforms work best (or only) with cloud data warehouses like Snowflake, BigQuery, or Redshift. Organizations with on-premise Microsoft SQL Server, PostgreSQL, MySQL, or MariaDB databases face integration complexity, latency, or the pressure to migrate data to the cloud just to run reports.

The Query Streams Approach: SQL at Every Layer

Query Streams takes a different position in the analytics platform market. Instead of replacing SQL with a proprietary abstraction, the entire platform is built around it. SQL is the query language. Spreadsheets are the presentation layer. AI generates the SQL when needed. And a secure Agent handles the database connectivity without exposing your network. For a detailed walkthrough of the web portal, see our database dashboard guide.

The end-to-end flow looks like this:

Layer 1: The Agent — Secure Database Connectivity

The Query Streams Agent is a lightweight service that runs on your infrastructure — Windows, Linux, or macOS. It makes outbound-only connections to the Query Streams cloud, which means no inbound ports, no firewall changes, and no VPN configuration. Database credentials stay on your machine and are never transmitted. You can download the Agent and have your first data source connected in under five minutes.

Deploy multiple Agents across your infrastructure based on your subscription tier. Install one in your office for on-premise SQL Server, another on an AWS EC2 instance for your PostgreSQL cluster, and a third on a Google Cloud VM for BigQuery. Each Agent self-maintains with automatic updates and presents its data sources as a unified dropdown in the query builder, so users select from available sources without needing to know which Agent or network location hosts each database. For optimal performance, deploy Agents in the same network or region as their databases.

The Agent supports 10+ database connectors: Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, BigQuery, and DuckDB. It also includes 6+ API Bridge connectors — Stripe, HubSpot, Shopify, Google Analytics, Google Search Console, and iTick — that cache API data locally in DuckDB so you can query SaaS platforms using standard SQL.

Layer 2: The Portal — Query Building and Management

The Query Streams portal at my.querystreams.com is where queries are written, tested, saved, and shared. The web-based query builder provides a SQL editor with syntax highlighting, a schema explorer showing tables and columns from your connected databases, and a results pane that displays data in tabular format.

Semantic Intelligence sits underneath the query builder. It profiles your database metadata — table names, column names, data types, relationships, and cardinality — and feeds that context to both the manual query experience and the AI layer. When you start typing a table name, the editor autocompletes from your actual schema. When Nova AI generates a query, it uses the same metadata to write SQL that references real tables and real columns.

Interactive filters are a core feature. Query Streams can detect filterable values in your SQL — both explicit variables (e.g., @region) and static values that can be parameterized (e.g., WHERE status = 'active'). Enable filters from the query Properties tab, and anyone you share the query with can adjust those parameters independently from Excel or Google Sheets without ever seeing or modifying the SQL code.

Query sharing lets you securely share the interactive capability to run a specific query, not just the results. Shared users pick a query from their personal list, adjust filters, and get live data on-demand from their own spreadsheet — anytime, anywhere. The original query creator does not need to be involved.

Layer 3: Nova AI — Conversational Analytics

Nova AI is the built-in BI and AI analytics engine. It turns plain English questions into validated, dialect-correct SQL, executes the query against live data, and presents results with auto-generated charts and natural-language analysis. For a deeper look at the conversational experience, see our conversational BI guide.

What makes Nova different from generic AI SQL tools is schema awareness. Before generating a single line of SQL, Nova loads your actual table metadata through Semantic Intelligence. It knows your column names, data types, and relationships. When it generates SQL, it uses a dedicated dialect engine with 9 production dialects — T-SQL for SQL Server, PL/pgSQL for PostgreSQL, MySQL syntax for MySQL, and so on. Every query passes through a multi-layer validation pipeline: syntax check, table name verification, column name validation with fuzzy correction, and structural checks. The result is SQL that actually runs on the first attempt.

Nova supports 6 chart types — bar, line, pie, scatter, area, and horizontal bar — automatically selecting the most appropriate visualization based on query results. Charts are generated alongside data and conversational analysis, so you get the full picture in a single response. Follow-up questions refine the analysis without starting over. Ask “break that down by region” or “show the last 6 months only” and Nova adjusts the query, re-executes, and updates the chart.

Layer 4: Delivery — Excel, Google Sheets, and Beyond

The final layer is where most analytics platforms fall short: getting results into the tools people actually work in. Query Streams delivers live data to Microsoft Excel and Google Sheets through native add-ins.

The add-ins support parallel query execution. Launch five saved queries into five different worksheet tabs simultaneously, and the Agent streams each concurrently, regardless of result size. Each query runs on-demand — no scheduled refreshes, no stale exports. Users select a query from their list, adjust available filters, and get live results in their spreadsheet. The person who created the query does not need to be involved.

Beyond spreadsheets, Query Streams includes automation and integration that syncs query results to Airtable, Smartsheet, Baserow, and SeaTable on a scheduled basis. Turn any query — manually written or AI-generated — into a recurring data pipeline without writing integration code.

Platform Capabilities at a Glance

Each layer of the platform includes specific capabilities designed to reduce the distance between a question and an answer.

Who This Is For

Query Streams works well for a specific set of use cases. It is not trying to replace every analytics platform on the market — it is built for organizations and individuals that want SQL-based analytics with spreadsheet delivery.

Who Should Look Elsewhere

Honest positioning matters more than marketing claims. Query Streams is not the right fit for every analytics need, and knowing when to look elsewhere saves time for everyone.

Supported Databases and Connectors

Query Streams connects to relational databases, analytical engines, and SaaS APIs through a unified Agent architecture. Nova AI generates dialect-correct SQL for each, and the Excel/Sheets add-ins deliver results regardless of the source.

More database integrations are coming soon. API Bridge connectors are actively expanding — each connector syncs data locally into DuckDB, so Nova queries them with DuckDB SQL syntax while your team sees the data alongside traditional database results in the same interface.

Security Architecture

Security is not an add-on feature — it is the foundation of the platform’s architecture. The Agent model was designed specifically for organizations that cannot (or should not) expose database ports to the internet.

How It Compares

Every analytics platform makes trade-offs. The table below compares Query Streams against common alternatives across the dimensions that matter most to teams evaluating options.

Frequently Asked Questions

Get Started

Related guides: Database Dashboard | Conversational BI | Databases in Microsoft Excel | Databases in Google Sheets | BI and AI Data Analytics | Automation and Integration | API to SQL | Download the Agent

Category: Articles

Tags: data analytics platform, analytics platform, SQL analytics, database analytics, Excel analytics, Google Sheets analytics, Nova AI, query builder, data visualization, API to SQL, database reporting, spreadsheet analytics

Meta Description: SQL-powered data analytics platform with AI, 10+ databases, and live Excel/Sheets delivery.