How to Connect MariaDB to Excel – Stream Live Database Data

CONNECTOR GUIDE

MariaDB ➤ Microsoft Excel

MariaDB

Query Streams

Microsoft Excel

No VPN Required

Live Data

MySQL Fork

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

This guide shows you how to establish a secure, real-time connection between your MariaDB database and Excel. MariaDB, a MySQL fork built for high performance and compatibility, works seamlessly with Query Streams 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 MariaDB – On-premise or cloud-hosted databases
• Execute MariaDB 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 MariaDB 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 MariaDB as Your Connection Type

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

Step 3: Configure Your MariaDB Connection Details

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

Required Connection Details:

1. Connection Name (required) – A friendly name like “Production MariaDB” or “Development DB”
2. Server (required) – Hostname or IP address. Examples: 192.168.1.100, mariadb.example.com, localhost
3. Port (required) – Default is 3306. Change only if using a custom port.
4. Database (required) – Specific database name (e.g., employees, inventory)
5. Username (required) – MariaDB 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 MariaDB is accessible with the credentials provided.

1. Automatic testing: The agent attempts to connect to your MariaDB
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 MariaDB connection

Your MariaDB 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 MariaDB connection from the Data Source dropdown
3. Choose the database from the Database dropdown
4. Write your MariaDB 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 MariaDB 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