Query Any Database.
Directly from Your Spreadsheet.
Write SQL in the portal (or let AI generate it), run queries live from Excel or Google Sheets, and share results with anyone — without exposing SQL code or database credentials.
Ask Nova, get SQL + charts
Meet Nova
One key per partner. No credentials shared.
Build an API
+more
Scheduled sync to 6+ platforms
Explore
+more
Query APIs with SQL, no code
Explore
+more
Claude, Cursor, ChatGPT & Grok talk to your data
Connect AIQuery Streams is a secure, real-time database integration platform that lets data analysts write SQL once and run queries live from Microsoft Excel or Google Sheets. Learn more at QueryStreams.com and sign up for free to start querying your databases directly from your spreadsheet.
Why SQL for Data Analysts Is Still Harder Than It Should Be
Data analysts who write SQL face a paradox: the query itself takes minutes, but everything around it — connecting to the database, exporting results, sharing with stakeholders, keeping data current — takes hours. Most analyst teams lose more time to workflow friction than to actual analysis.
The typical data analyst SQL workflow looks like this: open a SQL client (SSMS, pgAdmin, DBeaver), connect through a VPN, write and test the query, export results to CSV, open Excel or Google Sheets, import the data, format it, email the file, and repeat tomorrow when the numbers change. According to Harvard Business Review, data professionals spend up to 80% of their time on data preparation and delivery rather than actual analysis.
This cycle creates four persistent problems that most analyst teams recognize immediately.
Copy-Paste Fatigue
Every report requires the same ritual: run the query in a SQL client, export to CSV, import into a spreadsheet, format, and distribute. Multiply that across dozens of queries and the overhead becomes the job.
Stale Data
Exported CSV files are outdated the moment they leave the database. Stakeholders make decisions on yesterday’s numbers because refreshing means re-running the entire export cycle.
Sharing Bottleneck
When colleagues or partners need updated data, they come to you. You re-run the query, adjust the filters, re-export, and re-send. Every request becomes an interruption.
VPN and Access Friction
Running a query requires VPN access, database credentials, and a SQL client. Working from home, traveling, or onboarding a new team member all add layers of IT overhead.
How Query Streams Streamlines the Data Analyst SQL Workflow
Query Streams eliminates the gap between writing SQL and getting results into a spreadsheet. Instead of exporting CSV files and emailing them around, you write SQL queries for data analysis in the web portal, save them, and run them directly from the Excel add-in or Google Sheets add-on. Anyone you share a query with can run it independently — with their own filter values — without ever seeing the SQL code or needing database credentials.
Install the Agent
Deploy the Network Agent on any machine that can reach your databases. Windows or Linux, on-premise or cloud. Outbound connections only — no firewall rules needed.
Write SQL in the Portal
Use the query builder to write and test SQL against your live database. Or let Nova AI generate the query from a plain English description.
Run from Excel or Sheets
Open the Excel add-in or Google Sheets add-on, select your saved query, set any filter values, and run. Live data streams directly into your worksheet.
Share with Stakeholders
Share any query by name. Recipients run it from their own spreadsheet, adjust filters independently, and get live results without seeing SQL.
Step 1: Install the Agent. Download the Query Streams Agent and install it on any machine that can reach your databases — an on-premise server, an AWS EC2 instance, an Azure VM, or a Google Cloud machine. The Agent makes outbound-only connections to the Query Streams relay, so no inbound ports or firewall changes are required. Deploy multiple Agents across your infrastructure based on your subscription tier; each agent self-maintains with automatic updates.
Step 2: Write SQL in the Portal. Log in to my.querystreams.com, select a data source from the unified dropdown (all connected Agents present their databases in one list), and write your SQL query. The portal supports all standard SQL for data analysis — joins, subqueries, window functions, CTEs — against your live database. Save the query with a descriptive name.
Step 3: Run from Excel or Google Sheets. Open the Query Streams add-in in Microsoft Excel or the add-on in Google Sheets. Your saved queries appear in a list. Select one, optionally adjust any interactive filter values, and click run. Live data streams directly into your worksheet cells. No CSV files, no copy-pasting, no stale data.
Step 4: Share with stakeholders. Share any saved query with colleagues, managers, or external partners. Recipients see the query by name in their own Excel add-in or Google Sheets add-on, select it, adjust filter values independently, and run to get live results on-demand. They never see the SQL code, never connect to the database directly, and never need to ask you to re-run anything.
Let Nova AI Write SQL for You
Not every query deserves the effort of writing it by hand. For ad-hoc requests, quick data pulls, or unfamiliar schemas, Nova AI generates dialect-correct SQL from plain English questions. Nova uses Schema Intelligence to pre-load your actual table names, column names, data types, and relationships before generating anything — so the SQL it produces references your real schema, not generic placeholders.
Nova supports 10 database dialects: T-SQL for Microsoft SQL Server, PL/pgSQL for PostgreSQL, MySQL, MariaDB, SQLite, Access SQL, Oracle PL/SQL, Snowflake SQL, BigQuery Standard SQL, and DuckDB. Every generated query passes through a multi-layer validation pipeline — syntax check, table verification, column validation with fuzzy correction, and structural analysis — before execution.
SQL queries for data analysis generated by Nova can be saved, edited, and shared just like manually written queries. The AI complements your SQL skills rather than replacing them: write complex queries yourself, use Nova for quick lookups, or let it draft a starting point that you refine in the portal.
Run Multiple Queries in Parallel
Query Streams supports parallel query execution: launch five saved queries into five different worksheet tabs simultaneously, and the Agent streams each result set concurrently regardless of size. There is no need to wait for one query to finish before starting the next. This is transformative for data analysts who prepare multi-tab reports — revenue by region in one tab, customer churn in another, inventory levels in a third — all updated in a single action.
Because data is live and on-demand rather than scheduled, analysts always work with current numbers. There are no stale overnight exports. Need to refresh a 50,000-row dataset before a meeting? Click run and the data streams in. Need to check a number from your phone? Open Google Sheets and run the query. The data is always live, always fresh, always accessible from any device with a browser.
Share Live SQL Queries Without Exposing Code
One of the most persistent challenges for data analysts is distribution: how do you give non-technical stakeholders access to live data without exposing SQL code, database credentials, or your time? Query Streams solves this by separating the query from the execution.
When you share a query, the recipient gets the ability to run it — not the ability to see it. They open their Excel add-in or Google Sheets add-on, select the shared query from a dropdown, adjust any available interactive filters (date range, region, product category), and click run. The SQL code stays hidden. The database credentials stay inside the Agent on your network. The stakeholder gets a live, filterable data feed without any technical knowledge.
Interactive filters are created automatically. Query Streams detects explicit SQL variables (e.g., @region, @start_date) and also auto-detects static values in WHERE clauses (e.g., WHERE brand = 'Acme'). Enable the Config switch for any detected filter in the query’s Properties tab, and end users get dropdown or input controls in the spreadsheet add-in without any additional development.
The Data Analyst Workflow: Before vs. After
Traditional SQL Workflow vs. Query Streams
Supported Databases and Data Sources
Query Streams connects to virtually every database a data analyst encounters. Deploy multiple Agents across your infrastructure and all data sources appear in a single unified dropdown — analysts simply select from available databases without needing to know which Agent or server hosts them.
Relational databases: Microsoft SQL Server (T-SQL), PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, and BigQuery.
Analytical engines: DuckDB for high-performance local analytics and as the storage engine for API connector data.
API connectors: Stripe, HubSpot, Shopify, Google Analytics, Google Search Console, and ShipStation. API data is cached locally in DuckDB and queryable with standard SQL.
Frequently Asked Questions
What SQL skills do data analysts need to use Query Streams? +
Can I use my existing SQL queries with Query Streams? +
How does Query Streams compare to exporting CSV files from a SQL client? +
Does Query Streams support parameterized queries with variables? +
Can non-technical users run my SQL queries from Excel or Google Sheets? +
Which databases does Query Streams support for data analysts? +
Is my database secure when running SQL from a spreadsheet? +
Get Started
Ready to streamline your data analyst SQL workflow?
Sign up for free, install the Agent, and run your first SQL query from Excel or Google Sheets in minutes. Write your own SQL or let Nova AI generate it — either way, your results go straight to your spreadsheet.
Related guides: Text to SQL | AI Data Analytics | Databases in Microsoft Excel | Databases in Google Sheets
Category: Articles
Tags: sql for data analysts, data analyst sql, sql queries for data analysis, Excel, Google Sheets, live data, database to spreadsheet, query sharing, parallel query execution, Nova AI
Meta Description: SQL for data analysts: query any database live from Excel or Google Sheets with Query Streams.
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish