Stream Live Database Data
Into Your Spreadsheets
Connect MySQL, PostgreSQL, SQL Server and more – no VPN required
Stream live database data directly into Google Sheets without VPNs or firewall changes. The Query Streams addon connects your spreadsheets to MySQL, PostgreSQL, SQL Server, and more through a secure, outbound-only connection. Sign up free to get started.
No VPN Required
Secure outbound-only connections
Real-Time Data
Live queries, not stale exports
5 Minute Setup
Install and run your first query
Share Queries
Team members run queries independently
Prerequisites
Query Streams Account
Free account at my.querystreams.com with at least one saved query.
Create free account →Google Account
Access to Google Sheets with permission to install addons.
Saved Query (Optional)
The example SQLite database query works great for testing – no setup needed!
Install the Windows Agent →Step 1: Open a New Google Sheet
Open your browser and type sheets.new in the address bar. This creates a new blank spreadsheet instantly. Once loaded, click the sidebar icon on the right (or go to Extensions > Add-ons > Get add-ons), then click the + symbol to open the Google Workspace Marketplace.
Step 2: Install Query Streams Addon
Search for “Query Streams”
In the Google Workspace Marketplace search box, type Query Streams and press Enter.
Click Install
Find the Query Streams addon card and click Install. Confirm the installation when prompted.
Sign in with Google
Select your Google account to link with Query Streams. This uses secure Single Sign-On (SSO).
Step 3: Grant Permissions
Google will ask you to grant permissions. The addon needs:
Step 4: Open the Addon and Select a Query
- Click the QS icon in the Google Sheets sidebar to open the addon
- Allow sheet access when prompted (one-time per spreadsheet)
- Select “Saved Queries” from the menu
- Choose a query from the dropdown – the example “Orders by Date Range” works great for testing
- Adjust filters if available (like date ranges)
- Select your destination sheet – choose “Sheet1” or any tab you prefer
Step 5: Stream Your Data
Click “Stream All Queries” to execute. Query Streams connects to your database through your Network Agent, runs the query, and streams the results directly into your spreadsheet.
Success!
Your live database data is now in Google Sheets. You can refresh anytime by clicking “Stream All Queries” again. Query Streams supports parallel query execution – run multiple queries to different sheets simultaneously!
What You Can Do Now
Analyze Data
Use Google Sheets formulas, pivot tables, and charts on your live database data.
Share with Team
Colleagues can run shared queries independently in their own sheets.
Refresh Anytime
Get the latest data with one click – no re-exporting or manual updates.
Multiple Queries
Run different queries to different sheets simultaneously for parallel data loading.
Frequently Asked Questions
💰 Is the Query Streams addon free? +
Yes! The Google Sheets addon is free to install and use. You need a Query Streams account (free tier available) which includes the example SQLite database for testing.
🔓 What databases are supported? +
Query Streams supports MySQL, PostgreSQL, Microsoft SQL Server, MariaDB, SQLite, Oracle, Microsoft Access, BigQuery, Snowflake, and DuckDB. Cloud databases on AWS RDS, Azure SQL, and Google Cloud SQL are also supported.
🔒 Do I need to open firewall ports? +
No. Query Streams uses a Network Agent that makes outbound-only connections. No firewall changes or VPN setup required – much more secure and easier than traditional methods.
🕑 Can I schedule automatic refreshes? +
The addon supports manual refresh (click to run). For scheduled automation, check out Query Streams Integrations which can automatically sync data to Google Sheets on a schedule.
👥 Can multiple users run the same query? +
Yes! Each user runs shared queries independently in their own Google Sheets. Query Streams supports parallel execution – multiple queries can run simultaneously without blocking.
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish