Data Integration Platform: Connect Any Database to Excel, Sheets & More

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, real-time data integration platform that connects your databases and API sources to the spreadsheets, platforms, and AI tools your team already uses. Learn more at QueryStreams.com and sign up for free to start integrating your data sources in minutes.

What Is a Data Integration Platform?

A data integration platform is software that connects disparate data sources — databases, APIs, SaaS applications, file systems — and delivers that data to the tools where it gets used. The goal is to eliminate manual exports, copy-paste workflows, and one-off scripts that break when schemas change or credentials rotate.

In practice, most organizations store critical data across multiple systems: sales figures in a SQL Server database, marketing metrics in Google Analytics, customer records in a CRM like HubSpot, and financial transactions in Stripe. Without a data integration platform, accessing this data means logging into each system individually, running exports, reformatting files, and pasting results into spreadsheets. By the time the report is built, the data is already stale.

A well-designed data integration platform solves this by providing a single layer that sits between your data sources and your output destinations. You define what data you need, the platform handles connectivity, security, format translation, and delivery. The result is on-demand or scheduled data access without the fragile patchwork of manual processes.

Types of Data Integration

Data integration is a broad category with several distinct approaches. Each has trade-offs in complexity, latency, cost, and the types of workflows it supports best. Understanding these approaches helps you pick the right tool for your specific use case.

ETL (Extract, Transform, Load) is the traditional enterprise approach. Data is extracted from source systems, transformed (cleaned, mapped, aggregated) in a staging area, and then loaded into a data warehouse like Snowflake, BigQuery, or Redshift. ETL pipelines are powerful for large-scale analytics but require data engineers to build and maintain the transformation logic. Tools like Informatica, Talend, and SSIS dominate this space.

ELT (Extract, Load, Transform) flips the order: raw data is loaded directly into a cloud data warehouse, then transformed in place using SQL. This approach leverages the compute power of modern cloud warehouses and has gained popularity through tools like Fivetran, Airbyte, and dbt. It is faster to set up than traditional ETL but still requires a warehouse and SQL expertise to define transformations.

CDC (Change Data Capture) captures data changes in near real-time by monitoring database transaction logs. Debezium, Kafka Connect, and Oracle GoldenGate are common CDC tools. This approach is ideal for event-driven architectures and streaming analytics, but requires significant infrastructure (message brokers, stream processors) and operational expertise to manage reliably.

API-based / On-demand integration queries data sources directly when requested, without pre-staging or warehousing. The data moves from source to destination at the moment it is needed, keeping results fresh without continuous pipeline overhead. Query Streams uses this model — an Agent installed near your databases handles connectivity and security, while queries execute on-demand or on a schedule.

None of these approaches is universally “best.” ETL and ELT serve data warehousing use cases. CDC serves real-time event streaming. On-demand integration serves teams that need live data in the tools they already use — without building and maintaining a warehouse or pipeline infrastructure. The right choice depends on what you need the data for and where it needs to go.

How Query Streams Approaches Data Integration

Query Streams is built around a straightforward model: install a lightweight Agent near your databases, define your data connections, and then access that data from any supported output destination — Excel, Google Sheets, Airtable, Smartsheet, Baserow, SeaTable, or the Nova AI analytics interface.

There is no data warehouse to provision, no transformation pipeline to configure, and no staging tables to manage. The Agent runs SQL queries directly against your live databases and streams results to the requesting endpoint. For API sources like Stripe and HubSpot, the Agent’s API Bridge syncs data locally into a DuckDB cache, which you then query with standard SQL. The effect is the same: write a query, deliver results to a destination.

This is not an ETL replacement. If you need to consolidate terabytes of data from dozens of sources into a central warehouse for complex transformations, Query Streams is not the right tool. But if your workflow is “I need live data from my database in my spreadsheet, on-demand or on a schedule, shared with my team” — that is exactly the problem Query Streams solves, with minimal setup and no recurring pipeline maintenance.

The Agent runs on Windows, Linux, and macOS. Deploy multiple Agents across your entire infrastructure — on-premise servers, AWS EC2 instances, Azure VMs, Google Cloud, or any environment globally. Each Agent self-maintains with automatic updates, and all data sources from all Agents appear as a unified dropdown list in the query builder. Users select from available data sources without needing to know which Agent or server hosts them.

The Full Connector Matrix

This is the complete integration map: every data source Query Streams can connect to, the Agent that bridges the connection, and every destination where data can be delivered.

Database Connectors

Relational databases form the core of Query Streams’ connectivity. The Agent connects natively to Microsoft SQL Server (using T-SQL), PostgreSQL, MySQL, MariaDB, SQLite, and Microsoft Access. Each connector uses the database’s native protocol, so you get full SQL dialect support including database-specific functions, CTEs, window functions, and stored procedures where applicable.

Enterprise and cloud databases are equally supported. Oracle, Snowflake, and Google BigQuery connectors handle enterprise-scale data sources. DuckDB provides high-performance analytical query capability for local datasets and serves as the storage engine for API Bridge data. Cloud-hosted databases on AWS RDS, Azure SQL Database, and Google Cloud SQL work through the same Agent — deploy it in the same network or region as the database for optimal performance.

API Sources

The Agent’s API Bridge connects to SaaS platforms and syncs their data locally into a DuckDB cache. You then query that data with standard SQL, just like any other database. Currently supported: Stripe (payments, subscriptions, invoices), HubSpot (contacts, deals, companies), Shopify (orders, products, customers), Google Analytics (sessions, pageviews, conversions), Google Search Console (search queries, impressions, CTR), and iTick (live market data, forex, crypto, equities).

Because API data is cached in DuckDB, you can join it with data from other connectors. Run a query that joins Stripe payment data with your PostgreSQL customer table, or cross-reference HubSpot deal stages with your SQL Server ERP data. The Agent handles the connectivity; you just write SQL.

Output Destinations

Spreadsheets are the primary output channel. The Microsoft Excel add-in and Google Sheets add-on let users select a saved query, adjust interactive filters, and run it on-demand to pull live data directly into their spreadsheet. Query Streams supports parallel execution — users can launch five queries into five different worksheet tabs simultaneously and the Agent streams each concurrently, regardless of result size.

Platform integrations extend data delivery beyond spreadsheets. Schedule queries to sync results to Airtable, Smartsheet, Baserow, or SeaTable on a recurring basis. This turns any SQL query into an automated data pipeline — database data arrives in your project management tool, no-code app, or collaboration platform without manual intervention.

Nova AI is the built-in BI and AI analytics interface. Ask questions about your data in plain English and Nova generates validated, dialect-correct SQL, runs it against your live database, and returns results with auto-generated charts and natural-language analysis. Any query Nova generates can be saved and shared through the same Excel and Sheets channels as manually written queries.

How It Works

Getting from zero to live data delivery takes four steps. No warehouse provisioning, no pipeline configuration, and no proprietary training required.

Step 1: Install the Agent. Download the Agent and install it on any machine that can reach your databases — a local server, a cloud VM, or your workstation. The Agent runs on Windows, Linux (Debian/Ubuntu), and macOS (Intel and Apple Silicon). It makes outbound-only connections, so no firewall changes or inbound port openings are needed.

Step 2: Connect your data sources. Add databases and API connectors through the Agent’s local web interface. Provide connection strings for databases or authenticate with OAuth for API sources. The Agent validates each connection and caches the schema metadata for Nova AI and the query builder.

Step 3: Write or generate queries. Use the web-based query builder to write SQL manually, or ask Nova AI to generate queries from plain English. Define interactive filters so end-users can adjust parameters (date ranges, regions, product categories) without modifying the SQL. Query Streams auto-detects filterable values and lets you configure them in the query’s Properties tab.

Step 4: Deliver data to any destination. Run queries on-demand from Excel or Google Sheets, schedule automated syncs to Airtable or Smartsheet, or share queries with teammates and external partners. Recipients run shared queries independently from their own spreadsheet with their own filter selections — without seeing the SQL or database credentials.

Who This Is For

Query Streams is designed for teams and organizations that need to move data from databases to the tools their people actually use. These are the workflows where on-demand data integration delivers the most value.

Who Should Look Elsewhere

Honest positioning matters. Query Streams is a powerful data integration platform for database-to-endpoint workflows, but it is not the right tool for every integration scenario. If your requirements match one of these patterns, a different category of tool will serve you better.

Security and Architecture

Security is not a feature checkbox for data integration — it is the architecture itself. Query Streams was designed from the ground up around the principle that your database credentials should never leave your network, and your firewall should never need to open an inbound port.

The Agent makes only outbound connections to the Query Streams cloud service. No inbound ports, no VPN tunnels, no reverse proxies. Database credentials are stored locally inside the Agent and are never transmitted to Query Streams servers. When a user or scheduled task requests data, the cloud service sends the query to the Agent over the existing outbound connection, the Agent executes it against the local database, and streams the results back. The Agent also enforces read-only access by default — it executes SELECT queries, not modifications.

This architecture means your IT team retains full control over what data is accessible, while business users get self-service access from their spreadsheets and collaboration tools. You can deploy multiple Agents across different network segments, each with its own set of data sources and permissions, all managed from a single Query Streams portal.

Frequently Asked Questions

Get Started

Related guides: Databases in Microsoft Excel | Databases in Google Sheets | BI and AI Data Analytics | Automation and Integration | API to SQL

Category: Articles

Tags: data integration platform, cloud data integration, data connector, database integration, ETL alternative, Excel database connector, Google Sheets database, Airtable integration, Smartsheet data sync, API to SQL, data pipeline, live data, on-demand data, cross-platform agent

Meta Description: Connect 10+ databases and 6+ APIs to Excel, Sheets, Airtable and more with Query Streams.