Query Streams

Overview

Query Streams routes database and API data to spreadsheets, AI clients, apps, and scheduled syncs through a hybrid deployment. It is a strong fit for people who want SQL-based access across existing tools while keeping credentials on their own network. Its guarded access model stands out; the Free tier’s small monthly traffic budget is the main constraint.

Key features

The Network Agent makes an encrypted outbound connection, so setup requires neither inbound ports nor a VPN. It limits queries to SELECT, WITH, and EXPLAIN, and database credentials stay on the user’s network. Those controls suit teams seeking a narrower path to data than direct database access, though they do not replace decisions about who should receive access.

Nova AI reads a database schema, translates plain-English questions into read-only SQL, and returns metrics, tables, and charts. That can help people explore data without writing queries, but Nova is included with Business Core, not the $15 a month entry paid plan.

The hosted MCP server connects sources to Claude, Cursor, ChatGPT, and Grok through a revocable key. Excel and Google Sheets add-ins run shared saved queries and stream live results into cells without exposing SQL to recipients. Federated queries can join databases and API sources in one SQL statement and return a single table. Together, these features suit workflows built around spreadsheets and AI clients rather than a separate reporting destination.

The connector directory covers 53 sources: 11 database engines, 27 hosted or managed services, 8 business APIs, and 7 file and folder types. Scheduled SQL results can be sent to Smartsheet, Airtable, Google Sheets, SeaTable, Baserow, and Anvil as often as every five minutes. Usage is measured by megabytes processed, not rows, so row-heavy workloads may still be economical if they process little data, while large transfers can consume quota quickly.

Pricing

New accounts get 30 days with every feature unlocked, then move to Free; no credit card is required. That is a useful way to assess premium features before committing, but the trial does not extend the Free tier’s ongoing capacity.

The cheaper paid tiers raise capacity and add workflow controls, but Business Core is the stated route to Nova AI. Compare expected processed data with each quota before choosing; the published limits do not establish a monthly traffic allowance for the higher plans.

Platforms

Query Streams supports API, Linux, macOS, self-hosted, web, and Windows environments. Its SQL, REST API, and MCP access, plus a hybrid deployment model, make it relevant to both interactive tool integrations and automated data delivery. Query acceleration is supported; there is no semantic layer.

Who it's for

Choose Query Streams if spreadsheet users, AI clients, or scheduled workflows need governed access to multiple databases and APIs, particularly when keeping credentials on the user's network matters. Its one-table federated results can simplify queries across sources, and its saved-query spreadsheet integrations avoid exposing SQL to recipients. Look elsewhere if your workload cannot fit the available quotas or if Nova is essential but Business Core does not suit your budget.

Pros and cons

Pros

• Outbound-only encrypted connectivity avoids inbound ports and VPN setup while keeping credentials on the user's network.
• SELECT, WITH, and EXPLAIN-only enforcement narrows the permitted query types.
• Spreadsheet, MCP, REST API, and scheduled-sync options connect results to several familiar workflows.
• Federated SQL can combine databases and APIs into one result table.

Cons

• Free allows only 5 MB per month and caps API and federated calls at 250 rows, limiting ongoing use.
• Scheduled pushes on Free stop at 125 rows, and the plan allows just one data source.
• Nova AI requires the $50 a month Business Core plan.

Alternatives

For a broader comparison, see Data Virtualization Software.

• Stardog is another freemium option, with a free renewable one-year license covering up to 1 million stored edges and 3 databases, plus community support.
• Apache Drill is a free, downloadable SQL engine that can run embedded or in a cluster.
• Denodo Platform has a free Developer plan for a single server with 4 cores, 50 data products, and 2.5 TB per year, alongside unlimited sources, consumers, and Data Marketplace users.
• PrestoDB is a free, self-hosted open-source SQL query engine.
• Spice.ai OSS is a free Apache 2.0-licensed option distributed as a self-hostable binary or Docker image.
• Teradata VantageCloud offers a free plan and trial; its VantageCloud Lake Standard plan has custom pricing.
• Starburst Galaxy has a free forever plan with up to 3 clusters for ad hoc queries, alongside a Pro plan starting at $0.50 per contact.
• Teiid is a free open-source data virtualization project without commercial plans.

Verdict

Query Streams is a compelling choice for people who need governed database and API access inside spreadsheets, AI clients, and scheduled syncs without moving credentials off their network. Its read-only controls and range of integrations make that combination unusually practical. The deciding caveat is capacity: check the Free limits carefully, and choose a paid plan only after matching its stated features to the workload you need to support.