How does a saved-query endpoint differ from a generated database API?

Query Streams publishes the result of a saved, read-only query. Recipients use their own keys and receive the permitted results without the SQL or source login. CData API Server, DreamFactory, PostgREST and Hasura provide broader API building blocks, including access controls and, when permitted, writes. They can be a better fit for an application backend. Your database can remain private with either approach when deployed appropriately; the differences are the endpoint model, deployment work and controls you need.

Query Streams vs the alternatives.

Compare Skyvia, Coefficient, CData, Supermetrics, Power BI and API platforms. Find the right fit for SQL results in spreadsheets, AI tools and apps.

Compare the products Get the free plan

Product and pricing sources checked 24 October 2026.

Start with the job you need to do.

Your sources + Network AgentSave the query. Reuse the result.

Spreadsheet results

A partner or app

An AI question

People need rows they can work with.

Run one saved query in Excel or Google Sheets. The result becomes ordinary cells for formulas, charts and pivots.

Compare the spreadsheet workflow, the source types and how access is shared.

Compare spreadsheet and SQL tools

Excel or Google SheetsRead-only query results

Open invoices Illustrative result

Customer	Amount	Status
Halden Logistics	12,480.00	Open
Castellan Foods	28,900.00	Overdue
Northgate Clinics	17,320.80	Overdue

Ordinary cells, ready for your next calculation.

Illustrative Query Streams workflows and sample data. These show what you can do, not a speed benchmark or a score for other products.

Where Query Streams fits.

Connect a source through a Network Agent, save a query, then use its results in Excel, Google Sheets, your AI tools, the Data Viewer or the Database REST API. Grant someone permission to run that query with the filters you allow. They get results; the SQL and source login stay hidden.

One saved query, several destinations

Use the same result workflow across spreadsheets, AI and your apps.

Run access you control

Share permission to receive results, then revoke access when it is no longer needed. Sharing starts on paid plans.

Private database connection

The agent connects outward. Source credentials stay on your machine; only requested results travel.

An outbound agent, live SQL and MCP are not exclusive to Query Streams. Skyvia and CData offer overlapping capabilities. The comparisons below show how the workflows and pricing differ.

Spreadsheets, SQL and AI: compare the workflow.

Skyvia, Coefficient, CData Connect AI, Mixed Analytics and Apipheny overlap with different parts of Query Streams. Here is what each product puts at the center.

All comparison details are available.

Spreadsheets, SQL and AI: compare the workflow.
What matters	Query Streams	Skyvia	Coefficient	CData Connect AI	Mixed Analytics	Apipheny
Main job	Saved SQL results across spreadsheets, AI and apps	Integration suite plus Query and Connect products	Import, refresh and export business data in spreadsheets	Enterprise data connectivity for AI and analytics	HTTP API requests into Google Sheets	HTTP API requests into Google Sheets
Spreadsheet workflow	Excel and Google Sheets add-ins	Excel and Google Sheets add-ins via Query	Excel and Google Sheets extensions	Spreadsheet and analytics integrations	Google Sheets add-on	Google Sheets add-on
Database and SaaS data	SQL databases; SaaS APIs synced to local relational tables	SQL through Query and Connect; integration pipelines also available	SQL and SaaS connectors; supported exports can write back	SQL interface over connected systems; cross-source views	Use the source’s HTTP API	Use the source’s HTTP API
AI access	MCP on every plan; Nova from Business Core	MCP endpoints in Connect	Spreadsheet AI functions and builders	MCP plus governed tools and data access	API-to-Sheets is the documented product workflow	API-to-Sheets is the documented product workflow
Private-source connection	Outbound Network Agent; credentials stay on your machine	Local Agent for on-premises sources	Follow the selected database connector’s network requirements	Outbound Connect Gateway available	Reach the source through an HTTP API	Reach the source through an HTTP API
Sharing model	Grant access to run a saved query; recipients receive results with SQL and source login hidden	Connect endpoints with configured access controls	Shared connections, import templates and sheets	User and tool governance over connected data	Share the resulting Google Sheet; Team plan adds users	Share the resulting Google Sheet
What drives the bill	Organization plan and resource allowances	Product choice, records or endpoint traffic	Users, source tier and refresh allowances	Users, sources and usage allowances	API requests and users included in the plan	Seats and API-call allowance

Query StreamsSkyvia

Main job: Query StreamsSaved SQL results across spreadsheets, AI and apps; SkyviaIntegration suite plus Query and Connect products
Spreadsheet workflow: Query StreamsExcel and Google Sheets add-ins; SkyviaExcel and Google Sheets add-ins via Query
Database and SaaS data: Query StreamsSQL databases; SaaS APIs synced to local relational tables; SkyviaSQL through Query and Connect; integration pipelines also available
AI access: Query StreamsMCP on every plan; Nova from Business Core; SkyviaMCP endpoints in Connect
Private-source connection: Query StreamsOutbound Network Agent; credentials stay on your machine; SkyviaLocal Agent for on-premises sources
Sharing model: Query StreamsGrant access to run a saved query; recipients receive results with SQL and source login hidden; SkyviaConnect endpoints with configured access controls
What drives the bill: Query StreamsOrganization plan and resource allowances; SkyviaProduct choice, records or endpoint traffic

Query StreamsCoefficient

Main job: Query StreamsSaved SQL results across spreadsheets, AI and apps; CoefficientImport, refresh and export business data in spreadsheets
Spreadsheet workflow: Query StreamsExcel and Google Sheets add-ins; CoefficientExcel and Google Sheets extensions
Database and SaaS data: Query StreamsSQL databases; SaaS APIs synced to local relational tables; CoefficientSQL and SaaS connectors; supported exports can write back
AI access: Query StreamsMCP on every plan; Nova from Business Core; CoefficientSpreadsheet AI functions and builders
Private-source connection: Query StreamsOutbound Network Agent; credentials stay on your machine; CoefficientFollow the selected database connector’s network requirements
Sharing model: Query StreamsGrant access to run a saved query; recipients receive results with SQL and source login hidden; CoefficientShared connections, import templates and sheets
What drives the bill: Query StreamsOrganization plan and resource allowances; CoefficientUsers, source tier and refresh allowances

Query StreamsCData Connect AI

Main job: Query StreamsSaved SQL results across spreadsheets, AI and apps; CData Connect AIEnterprise data connectivity for AI and analytics
Spreadsheet workflow: Query StreamsExcel and Google Sheets add-ins; CData Connect AISpreadsheet and analytics integrations
Database and SaaS data: Query StreamsSQL databases; SaaS APIs synced to local relational tables; CData Connect AISQL interface over connected systems; cross-source views
AI access: Query StreamsMCP on every plan; Nova from Business Core; CData Connect AIMCP plus governed tools and data access
Private-source connection: Query StreamsOutbound Network Agent; credentials stay on your machine; CData Connect AIOutbound Connect Gateway available
Sharing model: Query StreamsGrant access to run a saved query; recipients receive results with SQL and source login hidden; CData Connect AIUser and tool governance over connected data
What drives the bill: Query StreamsOrganization plan and resource allowances; CData Connect AIUsers, sources and usage allowances

Query StreamsMixed Analytics

Main job: Query StreamsSaved SQL results across spreadsheets, AI and apps; Mixed AnalyticsHTTP API requests into Google Sheets
Spreadsheet workflow: Query StreamsExcel and Google Sheets add-ins; Mixed AnalyticsGoogle Sheets add-on
Database and SaaS data: Query StreamsSQL databases; SaaS APIs synced to local relational tables; Mixed AnalyticsUse the source’s HTTP API
AI access: Query StreamsMCP on every plan; Nova from Business Core; Mixed AnalyticsAPI-to-Sheets is the documented product workflow
Private-source connection: Query StreamsOutbound Network Agent; credentials stay on your machine; Mixed AnalyticsReach the source through an HTTP API
Sharing model: Query StreamsGrant access to run a saved query; recipients receive results with SQL and source login hidden; Mixed AnalyticsShare the resulting Google Sheet; Team plan adds users
What drives the bill: Query StreamsOrganization plan and resource allowances; Mixed AnalyticsAPI requests and users included in the plan

Query StreamsApipheny

Main job: Query StreamsSaved SQL results across spreadsheets, AI and apps; ApiphenyHTTP API requests into Google Sheets
Spreadsheet workflow: Query StreamsExcel and Google Sheets add-ins; ApiphenyGoogle Sheets add-on
Database and SaaS data: Query StreamsSQL databases; SaaS APIs synced to local relational tables; ApiphenyUse the source’s HTTP API
AI access: Query StreamsMCP on every plan; Nova from Business Core; ApiphenyAPI-to-Sheets is the documented product workflow
Private-source connection: Query StreamsOutbound Network Agent; credentials stay on your machine; ApiphenyReach the source through an HTTP API
Sharing model: Query StreamsGrant access to run a saved query; recipients receive results with SQL and source login hidden; ApiphenyShare the resulting Google Sheet
What drives the bill: Query StreamsOrganization plan and resource allowances; ApiphenySeats and API-call allowance

Sources checked 24 October 2026. These describe the named products and editions; a feature omitted from a source is not proof it cannot exist.

Which product fits your job?

A useful comparison includes reasons to choose the other product. Open the alternative you are considering.

Query Streams as a Skyvia alternative

Integration, SQL access and APIs

Choose Query Streams when

You want one saved-query workflow across spreadsheets, your own AI tools, a phone and a REST endpoint, with result access you can grant and revoke.

Choose Skyvia when

You need a wider integration suite: replication, synchronization, backup, or OData and SQL connectivity alongside MCP.

Skyvia is more than ETL. Query and Connect offer live access, and its Agent supports private sources. Compare the specific products and their combined allowances.

Skyvia product source · Pricing · Documentation

Query Streams vs Coefficient

Spreadsheet imports, exports and automation

Choose Query Streams when

You want read-only source queries, controlled result sharing outside the sheet, and the same saved query available through MCP and REST.

Choose Coefficient when

You want spreadsheet-centered data imports, scheduled refreshes, shared import templates, or write-back to supported business systems.

Coefficient supports manual refresh, both spreadsheet apps and SQL connections. Its documented export workflow can also write changes back; Query Streams source queries are read-only.

Coefficient product source · Documentation

Query Streams vs CData Connect AI

Broad enterprise data and MCP connectivity

Choose Query Streams when

You want saved SQL results in everyday tools, query-level sharing for colleagues or partners, and published organization plans that do not add a per-recipient seat fee.

Choose CData Connect AI when

You need a broad enterprise connector library, governed MCP tools, multiple data-access protocols and reusable cross-source views.

CData also provides live SQL access, MCP, multi-source views and an outbound Connect Gateway. Those capabilities are real alternatives, not gaps to mark as missing.

CData Connect AI product source · Documentation

Query Streams vs Mixed Analytics API Connector

API requests inside Google Sheets

Choose Query Streams when

Your starting point is SQL databases or local files, and you want the same saved query in Excel, Google Sheets, AI tools and your application.

Choose Mixed Analytics when

You already have an HTTP API and want to configure requests, pagination and scheduled imports directly in Google Sheets.

Its Team plan includes five users. It is not accurately described as charging a separate full-price subscription for every member of a five-person team.

Mixed Analytics product source · Pricing

Query Streams vs Apipheny

API requests and scheduled Google Sheets imports

Choose Query Streams when

You want SQL over connected databases, SaaS tables and file folders, then controlled results in several endpoints.

Choose Apipheny when

You want a Google Sheets interface for an existing API, including saved requests, cell references and scheduled runs.

Apipheny supports multiple HTTP methods. That can suit API actions and updates; Query Streams keeps database query execution read-only.

Apipheny product source

Query Streams as a Supermetrics alternative

Marketing data, reporting and AI

Choose Query Streams when

You need operational SQL across your own databases, SaaS data and local files, with saved results people can run in their preferred tool.

Choose Supermetrics when

Your priority is marketing-channel data, campaign reporting, connector coverage and a marketing-focused reporting workflow.

Supermetrics supports Excel, Google Sheets and MCP, plus custom connectors. Choose on the data and workflow you need, rather than assuming it has no AI access.

Supermetrics product source · Pricing · Documentation

Query Streams vs Power BI

Dashboards, models and managed report distribution

Choose Query Streams when

People need query results as spreadsheet cells, a phone-friendly grid or an app response, without building a dashboard first.

Choose Power BI when

You need a BI reporting environment with interactive visualizations, shared models and managed report distribution.

The two can work together. Query Streams also offers Power BI access through the Database REST API; it is not a replacement for every BI reporting task.

Power BI product source · Pricing

Database REST APIs: a query result or an application backend?

Compare Query Streams with CData API Server, DreamFactory, PostgREST and Hasura GraphQL Engine. They can all serve data; the API you want to build determines the fit.

All comparison details are available.

Database REST APIs: a query result or an application backend?
What matters	Query Streams	CData API Server	DreamFactory	PostgREST	Hasura GraphQL Engine
What becomes an endpoint	The result of a saved, read-only SQL query	Configured data resources and operations	Generated database APIs, with scripting and policies	PostgreSQL tables, views and functions allowed by database permissions	A GraphQL data API; REST endpoints can wrap saved GraphQL operations
Read or write	Read-only query results	Operations depend on API configuration and permissions	Read/write APIs with role-based controls	Reads and writes governed by PostgreSQL roles	Queries and mutations governed by configured permissions
Access control	Recipient keys, revocation and endpoint lifetimes	Server-managed users, authentication and access rules	Roles and API-key management are built in	JWT authentication and database roles	Authentication and permission configuration
What you operate	A Network Agent; Query Streams provides the managed result endpoint	An API Server deployment	A self-hosted API platform	A standalone server beside PostgreSQL	Managed deployment options or your own GraphQL Engine
Data scope	Connected databases, SaaS tables, files and logs	Sources supported by the selected edition	Connectors supported by the selected edition	PostgreSQL	Supported databases and connected APIs
Strongest fit	Give a colleague, partner or app controlled access to one query result	Publish configurable APIs over varied sources	Operate a programmable API platform with built-in governance	Build a PostgreSQL-centered REST backend	Build an application around a GraphQL data layer

Query StreamsCData API Server

What becomes an endpoint: Query StreamsThe result of a saved, read-only SQL query; CData API ServerConfigured data resources and operations
Read or write: Query StreamsRead-only query results; CData API ServerOperations depend on API configuration and permissions
Access control: Query StreamsRecipient keys, revocation and endpoint lifetimes; CData API ServerServer-managed users, authentication and access rules
What you operate: Query StreamsA Network Agent; Query Streams provides the managed result endpoint; CData API ServerAn API Server deployment
Data scope: Query StreamsConnected databases, SaaS tables, files and logs; CData API ServerSources supported by the selected edition
Strongest fit: Query StreamsGive a colleague, partner or app controlled access to one query result; CData API ServerPublish configurable APIs over varied sources

Query StreamsDreamFactory

What becomes an endpoint: Query StreamsThe result of a saved, read-only SQL query; DreamFactoryGenerated database APIs, with scripting and policies
Read or write: Query StreamsRead-only query results; DreamFactoryRead/write APIs with role-based controls
Access control: Query StreamsRecipient keys, revocation and endpoint lifetimes; DreamFactoryRoles and API-key management are built in
What you operate: Query StreamsA Network Agent; Query Streams provides the managed result endpoint; DreamFactoryA self-hosted API platform
Data scope: Query StreamsConnected databases, SaaS tables, files and logs; DreamFactoryConnectors supported by the selected edition
Strongest fit: Query StreamsGive a colleague, partner or app controlled access to one query result; DreamFactoryOperate a programmable API platform with built-in governance

Query StreamsPostgREST

What becomes an endpoint: Query StreamsThe result of a saved, read-only SQL query; PostgRESTPostgreSQL tables, views and functions allowed by database permissions
Read or write: Query StreamsRead-only query results; PostgRESTReads and writes governed by PostgreSQL roles
Access control: Query StreamsRecipient keys, revocation and endpoint lifetimes; PostgRESTJWT authentication and database roles
What you operate: Query StreamsA Network Agent; Query Streams provides the managed result endpoint; PostgRESTA standalone server beside PostgreSQL
Data scope: Query StreamsConnected databases, SaaS tables, files and logs; PostgRESTPostgreSQL
Strongest fit: Query StreamsGive a colleague, partner or app controlled access to one query result; PostgRESTBuild a PostgreSQL-centered REST backend

Query StreamsHasura GraphQL Engine

What becomes an endpoint: Query StreamsThe result of a saved, read-only SQL query; Hasura GraphQL EngineA GraphQL data API; REST endpoints can wrap saved GraphQL operations
Read or write: Query StreamsRead-only query results; Hasura GraphQL EngineQueries and mutations governed by configured permissions
Access control: Query StreamsRecipient keys, revocation and endpoint lifetimes; Hasura GraphQL EngineAuthentication and permission configuration
What you operate: Query StreamsA Network Agent; Query Streams provides the managed result endpoint; Hasura GraphQL EngineManaged deployment options or your own GraphQL Engine
Data scope: Query StreamsConnected databases, SaaS tables, files and logs; Hasura GraphQL EngineSupported databases and connected APIs
Strongest fit: Query StreamsGive a colleague, partner or app controlled access to one query result; Hasura GraphQL EngineBuild an application around a GraphQL data layer

Sources checked 24 October 2026. These describe the named products and editions; a feature omitted from a source is not proof it cannot exist.

Compare the bill, including its meter.

A seat, a source, a request and a processed record are different allowances. Compare the workflow and limits you need before multiplying a headline price.

Query Streams

Free; paid plans from $15/month

Per organization. Paid sharing starts at Personal Plus ($30/month); Business Core ($50/month) includes Nova. Source, agent, creator and sharing allowances still apply.

Published pricing

Skyvia

Data Integration Basic $99/month; Connect Basic $19/month

Separate products. Data Integration meters processed records; Connect tiers meter traffic. Both have limited free plans.

Published pricing

Coefficient

Starter $59/month; Pro $119/user/month

Monthly billing. Annual equivalents are $49 and $99. Pro supports up to five users; larger teams and premium sources may need Enterprise.

Published pricing

CData Connect AI

Standard $99/month; Growth $199/month

Monthly base prices. Annual equivalents are $79 and $159. User/source add-ons and plan limits change the total. Business plans are quoted.

Published pricing

Mixed Analytics API Connector

Starter $15/month; Business $29/month; Team $58/month

Monthly billing. Team includes five users and a request allowance; annual billing is lower.

Published pricing

Apipheny

Hobby $10; Pro $15; Business $29 per seat/month

A free plan is available. Paid tiers differ in API calls and features.

Published pricing

Supermetrics

Starter from €49/month, billed monthly

The checked price view is in EUR. Destination, sources, accounts, users and extras affect the package. Annual billing is lower.

Published pricing

Power BI

Pro $14/user/month; Premium Per User $24/user/month

USD, paid yearly. Free authoring and capacity-based licensing also exist; some Microsoft 365 subscriptions include Pro.

Published pricing

CData API Server

Commercial editions: request a quote

The free Community edition is limited to non-commercial use and two connections.

Published pricing

DreamFactory

Linux Lite $1,500/month, billed annually

A free PostgreSQL open-source edition exists. Commercial editions differ in connectors, deployment and features; hosting/support may add cost.

Published pricing

PostgREST / Hasura GraphQL Engine

Open-source software options

Include infrastructure, deployment, security and maintenance in your budget. Managed Hasura offerings have separate terms.

Published pricing / software

What happens when five people need access?

Five Coefficient Pro seats at the checked monthly rate total $595/month. Mixed Analytics’ $58/month Team plan includes five users. Query Streams charges for its organization plan and allowances, so adding a result recipient does not create a per-seat line item. Check the sharing slots and creator allowance your team needs.

These illustrate billing models, not equivalent feature bundles. We do not multiply capped plans to invent prices for 25 or 100 users, or compare an annual commitment with a monthly subscription without saying so.

USD unless marked EUR. Published figures checked 24 October 2026; taxes, discounts, add-ons, contracts and later changes may affect your price. Each vendor link above is the source for its row.

A folder is a data source too.

Query Streams reads CSV, Excel, Parquet, JSONL, SQLite and log folders where they live. Query the combined tables, trace rows back to their source files, and inspect the file inventory and change trail.

The cache stays on the Network Agent. Source files are read-only; requested query results can travel to your tools.

Explore the file and folder connectors

A database, Network Agent and work screens connected by a mint data line inside an office — Keep the source connection inside your network. Deliver the results where they are needed.

Several saved queries, one run.

Run multiple saved queries from the spreadsheet add-in together. Each returns its own result, ready for formulas, charts and analysis. Actual completion times depend on the queries, source systems and plan allowances.

Five saved queries, ready to run together

Profit and lossRun together

BalanceRun together

Cash flowRun together

KPIsRun together

TrendsRun together

Illustrative workflow, not a benchmark or a measured speed comparison with another product.

See the Excel and Google Sheets add-ins

Questions people ask when comparing

Is an outbound agent unique to Query Streams?

No. Skyvia supports a local Agent for private sources, and CData Connect AI offers an outbound Connect Gateway. Query Streams uses an outbound Network Agent with read-only query enforcement and source credentials kept on the agent machine. Compare access scope and the workflow you need, as well as the connection architecture.

Skyvia source · CData source

Is Query Streams a Skyvia replacement?

It depends on the job. Query Streams is built around saved SQL results used across spreadsheets, AI tools and apps. Skyvia also offers live Query and Connect products, alongside integration, replication, synchronization and backup. Compare the particular Skyvia products and allowances you use rather than treating all of Skyvia as scheduled ETL.

Skyvia Connect · Skyvia pricing

Can Query Streams replace Power BI or Supermetrics?

Query Streams can fit ad-hoc SQL results and controlled result delivery. Power BI is a stronger fit when you need its reporting and modeling environment; Supermetrics is focused on marketing data and reporting, including AI and MCP workflows. Query Streams can also supply Power BI through its REST API, so the products can complement each other.

Power BI · Supermetrics

Is there a free plan?

Yes. Free is a plan with no expiry. It includes live queries in Excel and Google Sheets, the MCP server for the AI tools you already use, one Database REST API address and federated queries across two sources, each with its own row limit. Paid plans raise the limits. Nova, the AI analyst, starts on Business Core.

Try your own query on Free.

Every connector type, Excel and Google Sheets, MCP and the Database REST API are included. Free allows 2 data sources and 1 agent. Sharing and advanced capabilities have paid-plan requirements.

Get the free plan Compare plan allowances