How to Connect MySQL to Excel – Stream Live Database Data

CONNECTOR GUIDE

MySQL ➤ Microsoft Excel

MySQL

Query Streams

Microsoft Excel

No VPN Required

Live Data

Popular

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 enables you to connect MySQL databases directly to Microsoft Excel, streaming live data without VPNs, firewall changes, or complex ODBC configuration. Sign up for free at QueryStreams.com and start pulling live MySQL data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your MySQL database and Microsoft Excel. Whether you’re running on-premise MySQL, AWS RDS for MySQL, Azure Database for MySQL, or Google Cloud SQL, Query Streams provides a simple solution for building live dashboards, automating reporting, and securely sharing database queries with teams worldwide.

What You’ll Accomplish

By the end of this guide, you’ll be able to:

• Connect Excel to MySQL – On-premise, AWS RDS, Azure, or Google Cloud SQL
• Execute MySQL queries in real-time from Excel
• Build live dashboards and reports with auto-refreshing data
• Share secure database access with colleagues globally

Prerequisites

Step 1: Access the Query Streams Agent Interface

With your agent installed and running, configure your MySQL connection through the local agent interface.

1. Open your web browser and navigate to the agent interface: https://localhost:1823
2. Navigate to Data Connections: Click Data Sources in the sidebar, then select Connections
3. Add a new connection: Click the Add Connection button

Step 2: Select MySQL as Your Connection Type

1. Choose MySQL: Click on the MySQL tile (it will highlight with a green border when selected)
2. Alternative – Use search: Type “MySQL” in the search bar to quickly find it
3. Proceed to next step: Once selected, click Next

Step 3: Configure Your MySQL Connection Details

You’re now on Step 2: Configure Connection where you’ll enter your MySQL credentials.

Required Connection Details:

1. Connection Name (required) – A friendly name like “Production MySQL” or “AWS RDS MySQL”
2. Server (required) – Hostname or IP address. Examples: 192.168.1.100, mydb.us-east-1.rds.amazonaws.com, localhost
3. Port (required) – Default is 3306. Change only if using a custom port.
4. Database (required) – Specific database name (e.g., sakila, world)
5. Username (required) – MySQL database user
6. Password (required) – Database password (click eye icon to toggle visibility)
7. Connection Timeout – Default 30 seconds. Increase for slower networks.

Once all fields are completed, click Next to proceed.

Step 4: Select Your Data Realm

A Data Realm determines your query processing capacity – how much data can flow through your queries, measured in MB/GB based on your subscription.

1. Review available realms: You’ll see options based on your subscription tier
2. Select realm: Choose “Default Data Realm” for most use cases
3. Click Next to test the connection

Step 5: Test Your Database Connection

Query Streams will verify your MySQL is accessible with the credentials provided.

1. Automatic testing: The agent attempts to connect to your MySQL
2. Review results: Success shows server version, database name, and connection details
3. Click Next if successful

Step 6: Finish Setup

1. Review configuration: Verify all settings are correct
2. Click Finish to save your MySQL connection

Your MySQL connection is now ready! Next, you’ll install the Excel add-in to start querying.

Step 7: Install Add-In and Run Your First Query

Install the Query Streams add-in from Microsoft AppSource:

After installation, you can access the add-in from the Home ribbon tab in Excel.

1. Click “Stream a Query” to begin creating a new query
2. Select your MySQL connection from the Data Source dropdown
3. Choose the database from the Database dropdown
4. Write your MySQL query in the editor

SELECT 
    customer_id,
    first_name,
    last_name,
    email,
    country
FROM customers
WHERE country = 'USA'
ORDER BY last_name
LIMIT 100;

5. Configure destination: Choose “Create a new tab” for your first query
6. Click the Play button to execute the query

Next Steps: Save and Share Queries

Use the Query Streams web portal to build, save, and manage your MySQL queries:

• Save queries: Store frequently used SQL for easy reuse
• Add parameters: Create dynamic filters users can adjust without seeing SQL
• Share globally: Let colleagues run queries from anywhere in the world
• Access from add-in: Saved queries appear in the “Saved Queries” menu

Frequently Asked Questions

Related Guides