Query Streams
querystreams.com
What it is
Query Streams gives spreadsheets, AI clients, apps, and scheduled syncs governed access to databases and APIs through an outbound-only Network Agent. Nova AI accepts plain-English questions, reads a database schema, runs read-only SQL, and returns metrics, tables, and charts. A hosted MCP server connects sources to Claude, Cursor, ChatGPT, and Grok using 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 join data from multiple databases and API sources in one SQL statement. Scheduled results can be sent to supported services as often as every five minutes. The Network Agent makes an encrypted outbound connection, needs no inbound ports or VPN, restricts queries to SELECT, WITH, and EXPLAIN, and keeps database credentials on the user's network. The Free tier is free and includes 5 MB/month query traffic; paid plans start at $15 a month. New accounts receive a 30-day trial with every feature unlocked and no credit card.
Spec sheet
- What it does
- Query Streams runs governed live SQL against databases and APIs and delivers results to spreadsheets, AI clients, REST endpoints and scheduled destinations.Read 15 Oct 2026 · querystreams.com
- Purpose
- Query Streams provides governed access to databases and APIs for spreadsheets, AI clients, apps, and scheduled data syncs through an outbound-only Network Agent.Read 29 Sep 2026 · querystreams.com
- Trial
- New accounts receive 30 days with every feature unlocked before moving to the Free plan, without a credit card.Read 29 Sep 2026 · querystreams.com
- Security
- The Network Agent initiates an encrypted outbound connection, requires no inbound ports or VPN, and enforces SELECT, WITH, and EXPLAIN-only queries; database credentials stay on the user's network.Read 29 Sep 2026 · querystreams.com
- Support
- The site provides a contact form for questions and links to its documentation archive.Read 29 Sep 2026 · querystreams.com
- License
- The service and Agent are proprietary commercial software licensed for internal business use; the terms prohibit copying, modification, reverse engineering and redistribution.Read 15 Oct 2026 · querystreams.com
- Founded
- LinkedIn lists Query Streams as founded in 2025.Read 15 Oct 2026 · linkedin.com
- AI integrations
- Its hosted MCP server connects databases and API sources to Claude, Cursor, ChatGPT, and Grok using a revocable key.Read 29 Sep 2026 · querystreams.com
- AI provider disclosure
- When MCP is used, requested results are sent to the selected AI provider such as Anthropic or OpenAI under that provider's policies.Read 15 Oct 2026 · querystreams.com
- API connectors
- REST services including Stripe, HubSpot, Shopify, Google Ads, Google Analytics 4, ShipStation, Search Console and iTick are exposed as SQL-queryable tables.Read 15 Oct 2026 · querystreams.com
- API handling
- The API Connector handles authentication, pagination, retries, rate-limit backoff and an AES-256 encrypted local cache.Read 15 Oct 2026 · querystreams.com
- Automation
- Queries can be scheduled to Airtable, Smartsheet, Baserow and SeaTable, with alert delivery through channels such as Slack, Google Chat, Discord, Telegram and email depending on tier.Read 15 Oct 2026 · querystreams.com
- Company headquarters
- LinkedIn lists the headquarters as Memphis, Tennessee, United States.Read 15 Oct 2026 · linkedin.com
- Company type
- LinkedIn lists Query Streams as a privately held Data Infrastructure and Analytics company with 2–10 employees.Read 15 Oct 2026 · linkedin.com
- Connectors
- The connector directory lists 53 sources, including 11 database engines, 27 hosted or managed services, 8 business APIs, and 7 file and folder types.Read 29 Sep 2026 · querystreams.com
- Database coverage
- Documented database connectors include SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Access, Oracle, Snowflake, BigQuery and DuckDB.Read 15 Oct 2026 · querystreams.com
- Deployment options
- The Agent runs on Windows, Linux and macOS and can be deployed on-premises or on cloud VMs such as AWS, Azure and Google Cloud.Read 15 Oct 2026 · querystreams.com
- Documentation depth
- The documentation includes step-by-step Windows, macOS and Linux installation, troubleshooting, connector setup and MCP connection guides.Read 15 Oct 2026 · querystreams.com
- Excel rating
- Microsoft AppSource rating is 5.0 out of 5 from 3 reviews.Read 15 Oct 2026 · querystreams.com
- Federated queries
- Federated SQL can join data from multiple connected databases without first exporting or copying the source data.Read 15 Oct 2026 · querystreams.com
- Google Sheets rating
- Google Workspace Marketplace rating is 5.0 out of 5 from 12 reviews.Read 15 Oct 2026 · querystreams.com
- Independent review score
- Open-Launch scored Query Streams 5/5 for ease of implementation and security, 4.5/5 for features, 4/5 for performance, compatibility and value.Read 15 Oct 2026 · startupscrolls.com
- Independent review setup
- Open-Launch's September 2025 review described a web dashboard, locally installed Network Agent and spreadsheet add-on, and reported a quick SQLite test setup.Read 15 Oct 2026 · open-launch.com
- Limit: advanced analytics
- Open-Launch said the product is less suitable for teams needing advanced analytics.Read 15 Oct 2026 · startupscrolls.com
- Limit: API roadmap
- The integration documentation says additional API connectors are on the roadmap, so current API coverage is narrower than database coverage.Read 15 Oct 2026 · querystreams.com
- Limit: not an ETL replacement
- The maker's integration documentation says Query Streams is not intended for consolidating terabytes across many sources into a warehouse with complex transformations.Read 15 Oct 2026 · querystreams.com
- Limit: Windows-free environments
- Open-Launch said the product is less suited to Windows-free shops, reflecting its review-era focus on a Windows Agent.Read 15 Oct 2026 · startupscrolls.com
- Linux requirements
- Linux installation supports Ubuntu 20.04+, Debian 11+, RHEL 8+, CentOS Stream 8+, Fedora 36+ and Amazon Linux 2 on x86-64 systems, with outbound HTTPS on port 443.Read 15 Oct 2026 · querystreams.com
- MCP
- The hosted MCP connector lets Claude, ChatGPT, Cursor and Grok query agent-served sources read-only, with OAuth or revocable keys.Read 15 Oct 2026 · querystreams.com
- Network architecture
- Its Network Agent makes outbound-only connections from inside the customer network, so the service says no VPN, inbound ports or firewall changes are required.Read 15 Oct 2026 · querystreams.com
- Notable news
- Query Streams announced a macOS Agent supporting Apple Silicon and Intel Macs with signed, notarized and automatically updated installation.Read 15 Oct 2026 · linkedin.com
- Nova AI
- Nova AI converts plain-English requests into validated read-only SQL, explains or fixes queries, and can show inline results and charts.Read 15 Oct 2026 · querystreams.com
- Praise: ease of use
- Open-Launch praised the minimalist spreadsheet interface and straightforward setup, while Startup Scrolls reported that deployment and first-query workflows were easy to follow.Read 15 Oct 2026 · open-launch.com
- Praise: live refresh
- Independent reviews highlighted on-demand fresh spreadsheet data as the product's main practical benefit over emailed exports and stale files.Read 15 Oct 2026 · open-launch.com
- Praise: security
- Independent reviewers repeatedly praised the outbound agent model because shared users can retrieve live results without receiving database credentials or SQL.Read 15 Oct 2026 · startupscrolls.com
- Query builder
- The web Query Builder provides schema-aware SQL editing, autocomplete, saved-query folders, revision history, filters, run history and sharing panels.Read 15 Oct 2026 · querystreams.com
- REST API
- A saved query can be published as a read-only REST endpoint with recipient-specific revocable keys.Read 15 Oct 2026 · querystreams.com
- Security data handling
- Query results are transmitted during active requests and are not stored except where the privacy policy specifically describes retention; API and MCP keys are stored hashed.Read 15 Oct 2026 · querystreams.com
- Spreadsheet integration
- Saved query objects can be shared to Excel and Google Sheets while hiding SQL, schemas and credentials from recipients.Read 15 Oct 2026 · querystreams.com
- Spreadsheet integrations
- Excel and Google Sheets add-ins run shared saved queries and stream live results into spreadsheet cells without exposing the SQL to recipients.Read 29 Sep 2026 · querystreams.com
- Usage enforcement
- The terms allow Query Streams to apply overage charges, rate or row limits, throttling, feature suspension or mandatory upgrades when allowances are exceeded.Read 15 Oct 2026 · querystreams.com
- Usage limits
- Usage is measured by megabytes of data processed rather than row count; the Free tier includes 5 MB per month and caps API and federated calls at 250 rows per call.Read 29 Sep 2026 · querystreams.com
Plans and prices
Strong points and limits
Strong points
- Joins multiple databases and APIs in federated queries.
- Streams saved query results into spreadsheet cells.
- Network Agent needs no inbound ports or VPN.
- Database credentials stay on the user's network.
- 30-day trial requires no credit card.
Limits
- Free tier includes 5 MB/month query traffic.
- Free tier allows one data source.
- Free API and federated calls are capped at 250 rows per call.
Who it suits
Query Streams suits teams that need to share database or API results with spreadsheets, AI clients, or applications while limiting query types and keeping credentials on their network. The trial provides access to every feature before accounts move to Free.
Query Streams in depth
Read the full write-up
Overview
Query Streams brings SQL access to databases and APIs into spreadsheets, AI clients, apps, and scheduled syncs. It suits teams that need to deliver data through familiar tools while keeping database credentials on their own network. Its governed access is a strong fit for controlled data sharing, but the Free tier’s traffic and row caps leave little room for sustained use.
Key features
The Network Agent initiates an encrypted outbound connection, needs no inbound ports or VPN, and keeps database credentials on the user’s network. Its SELECT, WITH, and EXPLAIN-only rule limits the kinds of queries that can be run, making it a useful control for read-oriented access. It does not replace decisions about which users or integrations should receive access.
Nova AI interprets plain-English questions, reads the database schema, and generates and runs read-only SQL, returning metrics, tables, and charts. That can help people get answers without writing SQL, but Nova is included with Business Core rather than the less expensive paid tiers.
The hosted MCP server connects databases and APIs 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. These are practical routes for teams already using those AI clients or spreadsheets; Query Streams is less compelling if the goal is a standalone analysis environment.
Federated queries can join data from multiple databases and API sources in a single SQL statement, returning one table. The connector directory spans database engines, hosted services, business APIs, and file and folder types. Scheduled SQL results can be pushed to Smartsheet, Airtable, Google Sheets, SeaTable, Baserow, and Anvil as often as every five minutes, which supports recurring delivery without requiring a manual export.
Usage is measured in megabytes processed, not rows. That makes the Free tier’s 5 MB monthly allowance the key constraint for query-heavy use; API and federated calls also cap at 250 rows per call. Free adds one source, scheduled pushes capped at 125 rows, one MCP key with 30 requests per minute, and one daily in-app alert.
Pricing
New accounts get 30 days with every feature unlocked, no credit card required, then move to Free. Free costs nothing. Its single source and tight traffic, push, and call limits make it suitable for evaluating a small workflow, not broad deployment.
Personal Core costs $15 a month and raises the allowance to 25 MB per month and three sources. It adds Query Manager, five times the Free API rate, and larger federated results. This is the entry point for users who outgrow Free’s call and source limits, though the listed quota remains modest for regular data processing.
Personal Plus costs $30 a month, with 90 MCP requests per minute, two Network Agents, five sources, dynamic filters, and query sharing. It is the better personal tier when multiple agents or shared, filtered queries matter; it does not include Nova AI.
Business Core costs $50 a month and includes Nova AI with monthly Nova credits. It is the clearest fit for organizations that want natural-language database queries, though the credit allowance is not quantified. The plan details provided do not state seat counts or renewal terms, so those should be confirmed before committing.
Platforms
Query Streams supports API, Linux, macOS, self-hosted, web, and Windows. SQL, REST API, and MCP access give it several routes into applications and client tools. Its hybrid deployment model and outbound agent suit environments where databases should remain on the user’s network.
Who it's for
Choose Query Streams when database and API results need to reach spreadsheets, supported AI clients, or scheduled destinations under read-only query controls. It is less suited to workloads that routinely process large volumes on a tight budget, or to teams that need Nova AI without moving to Business Core.
Pros and cons
Pros: Outbound-only encrypted access avoids inbound ports and VPN, while credentials stay on the user’s network.
Pros: Spreadsheet add-ins, MCP connections, federation, and scheduled pushes cover several distinct ways to deliver query results.
Cons: Free’s 5 MB monthly traffic allowance and 250-row API and federated call caps limit meaningful ongoing use.
Cons: Nova AI is confined to the $50 a month Business Core plan, making natural-language querying a substantial step up from entry-level paid pricing.
Alternatives
For a broader comparison, see Data Virtualization Software.
Denodo Platform is worth considering when its free Developer plan’s single server, four cores, 50 data products, and 2.5 TB per year better match a data-product deployment. Teradata VantageCloud is an alternative for readers seeking Teradata Database and ClearScape Analytics with Open Analytics Framework.
Starburst Galaxy may suit teams whose priority is ad hoc querying across up to three free clusters, with a paid Pro tier starting at $0.50 per contact. Virtuoso Universal Server is another option, with a Personal plan priced at $99.99 as a one-time purchase for two concurrent users and a workstation on Linux, Windows, or macOS.
Stardog offers a free renewable one-year license capped at one million stored edges and three databases. Enterprise Enabler is an alternative for readers comparing paid data integration software.
Spice.ai OSS is a free, self-hostable option distributed under Apache 2.0. Apache Drill is a free downloadable Apache 2.0 option for embedded or cluster deployment.
Verdict
Query Streams is a strong choice for teams that need governed, read-only access to databases and APIs through spreadsheets, AI clients, or scheduled syncs, especially when keeping credentials on their own network is important. Its range of delivery paths is the main reason to choose it; the main reason to look elsewhere is the limited Free allowance and the jump to Business Core for Nova AI.
Verdict
Query Streams combines governed data access with spreadsheet add-ins, AI connections, and scheduled syncs. The Free tier has specific traffic, source, and row limits; paid plans start at $15 a month.
Where Specifiction places it
- Data Virtualization Software#1 of 259.1