Query Streams

Query Streams is a data streaming tool designed for business teams, data analysts, and IT professionals who need seamless live SQL data access within Excel and Google Sheets. It addresses the common challenge of exporting static CSV files by enabling direct, live queries from databases like SQL Server, PostgreSQL, MySQL, and Snowflake into spreadsheet interfaces.

What Makes Query Streams Stand Out

• Live SQL Data Refresh: Users can refresh data with one click to get the latest query results without rerunning manual exports or scheduled syncs.
• Secure Outbound-Only Agent: Query execution happens inside your network via a Windows agent that uses outbound connections only, minimizing security risks and avoiding VPN or firewall changes.
• Data Sharing Without Credential Exposure: Instead of sharing database credentials, users share parameterized queries. Recipients can interact with filters without accessing SQL code or sensitive connection details.
• Multi-Platform Spreadsheet Integration: Supports both Microsoft Excel (including Office 365) and Google Sheets, allowing teams to use familiar tools while accessing live data.
• Compatibility with Popular Databases: Works with a variety of data sources such as SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, and Access.

Use Cases

• Finance teams needing live access to up-to-date invoice and operational data without relying on IT or manual exports.
• Distributed sales or analytics teams who require instant global database querying via spreadsheets without VPN or direct database connection.
• Vendors or remote partners who need restricted, parameter-driven access to query results but should not see underlying SQL or credentials.

Frequently Asked Questions

What is Query Streams?

Query Streams is a data integration tool that allows live SQL queries to run directly inside Excel and Google Sheets. It replaces traditional data export workflows by providing on-demand access to fresh database results via spreadsheets.

How does Query Streams handle security?

It uses an outbound-only network agent installed on your database network, eliminating the need for inbound ports or VPN access. This design keeps database credentials secure and ensures that sensitive connection details are never exposed outside your infrastructure.

Can Query Streams handle large datasets?

Yes, Query Streams supports parallel queries and efficient data streaming, optimized for large result sets. This approach reduces delays commonly encountered in manual exports or scheduled sync solutions.

What alternatives does Query Streams compete with?

It serves as a modern alternative to traditional ODBC connectors, Microsoft Power Query, and scheduled data sync tools by providing live query capabilities inside spreadsheets.

Are there any limitations to Query Streams?

Currently, the network agent is Windows-only, which may limit deployment options for certain environments. Users should also consider that it focuses on live query streaming rather than caching or replicating data, which might not suit offline scenarios.