FROM sales
WHERE region = ‘West’
Run SQL Queries
Directly in Excel
Write SQL against any database and stream live results into your spreadsheet — no ODBC drivers, no VBA macros, no connection string headaches. Just SQL in Excel, the way it should work.
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 you run SQL queries in Excel against any database — without installing ODBC drivers, writing VBA macros, or configuring connection strings on every machine. Learn more at QueryStreams.com and sign up for free to start running SQL queries from your spreadsheets.
Running SQL in Excel is one of the most searched-for capabilities among data professionals, analysts, and business users who live in spreadsheets but need access to live database information. Whether you want to pull a sales report from SQL Server, query a PostgreSQL analytics warehouse, or aggregate MySQL transaction data — the goal is the same: get database results into Excel cells without manual exports, stale CSV files, or copy-paste workflows.
This guide covers three ways to run an Excel SQL query, explains why the traditional approaches create friction, and shows how Query Streams eliminates every barrier between your SQL and your spreadsheet.
3 Ways to Run SQL in Excel
There are three main approaches to running SQL queries in Excel. Each has a different setup complexity, different limitations, and different levels of ongoing maintenance. Here’s a side-by-side breakdown.
Excel’s native data connection tool. Uses ODBC or OLE DB drivers to connect to databases through the Data tab. Supports basic SQL via the “Advanced Editor” but requires driver installation on every machine.
- Built into Excel (no add-in needed)
- Supports SQL via Advanced Editor
- Requires ODBC/OLE DB drivers per machine
- 32-bit vs 64-bit driver conflicts
- Direct TCP connection to database needed
- No query sharing or interactive filters
Write Visual Basic for Applications macros that open ADODB connections using ODBC connection strings. Gives full SQL control but requires programming skills and embeds credentials in VBA code.
- Full SQL control and automation
- Can build custom UIs with UserForms
- Requires VBA programming knowledge
- Credentials stored in macro code
- Still needs ODBC drivers installed
- Macros blocked by many IT security policies
Install a lightweight Agent on your database server. Write SQL in the web portal or let Nova AI generate it. Run queries from the Excel add-in with live results streamed directly into cells.
- No drivers on client machines
- No VBA, no macros, no connection strings
- Outbound-only connection (no firewall changes)
- Share queries with interactive filters
- Works with Excel, Google Sheets, and Excel Online
- Nova AI writes SQL from plain English
Why Traditional Methods Fall Short
Both Power Query and VBA/ODBC approaches share the same foundational problem: they require a direct connection from the user’s workstation to the database server. This creates cascading issues that grow worse as your team scales.
ODBC Driver Installation and Maintenance
Every user who needs to run an SQL query in Excel must install the correct ODBC driver on their machine. If your organization uses SQL Server, PostgreSQL, and MySQL, that’s three separate drivers per workstation. Each driver has its own version cadence and compatibility requirements. The infamous 32-bit versus 64-bit driver mismatch remains one of the most common ODBC troubleshooting issues, often taking hours to diagnose.
Connection String Complexity
Whether you use Power Query’s Data Source settings or VBA’s ADODB connection objects, every user needs the server hostname, port, database name, authentication method, and often SSL/TLS parameters. This configuration is per-machine and not portable. Moving to a new laptop means rebuilding every connection from scratch. Sharing a working connection with a colleague means sending them a block of configuration text and hoping they paste it correctly.
Credential Exposure
With VBA, database credentials live inside the macro code. With Power Query, they’re stored in Windows Credential Manager on each machine. Either way, credentials are distributed across every workstation that needs database access. When an employee leaves or a laptop is lost, each of those credentials becomes a potential breach point. Microsoft’s own security best practices advise centralizing credential management — but ODBC-based workflows push in the opposite direction.
No Built-In Query Sharing
You wrote a complex SQL query that produces the perfect quarterly revenue report. Your colleague wants the same data filtered by their region. With ODBC, sharing that query means sharing the SQL code, the connection details, and the credentials — then hoping they have the right drivers installed. There is no built-in mechanism to share the capability to run a query without also sharing everything needed to access the database directly.
How Query Streams Runs SQL in Excel
Query Streams takes a fundamentally different approach. Instead of pushing database drivers and credentials to every user machine, you install a single lightweight Agent on your database server (or any machine that can reach the database). The Agent handles all database communication and streams results to users through a secure, outbound-only WebSocket connection. Here’s how it works in four steps.
Install the Agent
Download and install the Query Streams Agent on your database server or any machine with database access. Available for Windows, macOS, and Linux.
Add Your Database
Open the Agent’s local UI and add your database connection. Credentials are stored locally on the Agent — they never leave your server.
Write SQL or Ask Nova
Use the Query Streams web portal to write SQL queries directly, or describe what you need in plain English and let Nova AI generate the SQL for you. Save queries with optional interactive filters.
Run From Excel
Open the Excel add-in, select your saved query, adjust any filters, and run. Live results stream directly into your spreadsheet cells on demand.
SQL in Excel Features
Query Streams doesn’t just replace ODBC — it adds capabilities that Power Query and VBA were never designed for. Here’s what you get when running SQL in Excel with Query Streams.
Interactive Filters
Query Streams auto-detects parameters and static values in your SQL, turning them into dropdown menus and date pickers that end users can adjust before running.
Secure Query Sharing
Share the ability to run a query without exposing SQL code or database credentials. Recipients select from their query list, adjust filters, and get live results.
Parallel Execution
Launch multiple saved queries simultaneously — five queries into five different worksheet tabs. The Agent streams each concurrently regardless of result size.
Nova AI SQL Assistant
Describe what data you need in plain English and Nova generates the SQL query for you. Works with every supported database dialect.
On-Demand Live Data
No scheduled refreshes or stale exports. Run your SQL query in Excel any time and get live data from the database in seconds.
Google Sheets Too
The same Agent and saved queries work with the Google Sheets add-on. One platform serves both spreadsheet ecosystems.
Supported Databases for Excel SQL Queries
Query Streams supports all major relational databases and cloud data platforms. One Agent installation handles every database type — no separate driver for each.
| Database | Versions / Platforms | Guide |
|---|---|---|
| Microsoft SQL Server | Express, Standard, Enterprise, Azure SQL, AWS RDS | SQL Server to Excel |
| PostgreSQL | All versions, AWS RDS, Azure Database, Supabase, Neon | PostgreSQL to Excel |
| MySQL | 5.7+, Amazon RDS, Azure Database, Google Cloud SQL | MySQL to Excel |
| MariaDB | 10.x and 11.x, SkySQL, all cloud variants | MariaDB to Excel |
| SQLite | Local .db files on the Agent machine | SQLite to Excel |
| Microsoft Access | .accdb and .mdb files | Access to Excel |
| Oracle | 11g+, Oracle Cloud, Autonomous Database | Oracle to Excel |
| Snowflake | All editions across AWS, Azure, and GCP | Snowflake to Excel |
| Google BigQuery | All project types and regions | BigQuery to Excel |
| DuckDB | Local analytical databases, Parquet/CSV file queries | DuckDB to Excel |
Google Sheets guides are also available for every database listed. Deploy multiple Agents (based on your subscription tier) across your infrastructure — on-premise, AWS EC2, Azure VMs, Google Cloud, or any environment globally. All agents self-maintain with automatic updates and present their data sources as a unified dropdown list, so users simply select from available data sources without needing to know which agent or server hosts them.
Security: SQL Without the Risk
This architecture is the opposite of the ODBC model, where every client machine stores credentials locally. With Query Streams, revoking access means removing a user from the portal — not tracking down DSN entries across dozens of laptops. For a deeper comparison, see our ODBC Alternative for Excel guide.
Frequently Asked Questions
Can I run SQL directly in Excel? +
Do I need ODBC drivers to run SQL queries in Excel? +
What databases work with SQL in Excel through Query Streams? +
Can I share SQL queries with other Excel users? +
Does this work with Excel Online? +
Can Nova AI write SQL for me? +
How large can result sets be? +
Is Query Streams free to try? +
Get Started
Run Your First SQL Query in Excel Today
Sign up free, install the Agent on your database server, and run live SQL queries from Excel in under 10 minutes. No drivers. No VBA. No connection strings.
Related guides: SQL Server to Excel | PostgreSQL to Excel | ODBC Alternative for Excel | Databases in Microsoft Excel
Category: Articles
Tags: sql-in-excel, excel-sql-query, database-excel, odbc-alternative, power-query, live-data, no-code, query-sharing
Meta Description: Run SQL queries in Excel without ODBC drivers or VBA. Stream live database results into spreadsheets.
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish