How to Install the Query Streams Agent on Windows

7 min read

Windows Network Agent

Install Query Streams on Windows

Run the outbound-only Query Streams Network Agent on a Windows desktop, workstation, or server. Use the local Agent dashboard at http://localhost:1823 to register the Agent and manage data connectors, then build saved queries in the Query Streams portal for Excel, Google Sheets, automation, REST APIs, MCP, and Nova AI.

Local connector setup No inbound firewall ports Your credentials stay local

Install on WindowsWindows 10 / 11 or Windows Server 2019+

Outbound-only connectionNo inbound ports, no VPN, no public database exposure

Manage connectors locallyAdd, edit, test, and delete in the Agent at localhost:1823

Build saved queries nextPublish reusable queries to Excel, Sheets, MCP, APIs, and automations

Installing on a different OS?

Linux

macOS

See everything Query Streams can do after the Windows Agent is online Get Started Free

Connectors

+ APIs

Live Data

Run saved SQL directly from spreadsheets

Excel Sheets

BI & AI Analytics

Ask Nova questions over connected data

Meet Nova

Database REST API

Turn saved queries into secure endpoints

Build an API

+more

Automation

Schedule syncs and push live results

Explore

+more

API to SQL

Query SaaS APIs with SQL

Explore

AI Database MCP

Let AI tools query connectors directly

Connect AI

Query Streams is a secure, real-time data access platform that connects your databases and SaaS APIs to Excel, Google Sheets, automations, MCP-compatible AI tools, and partner-ready REST APIs. Learn more at QueryStreams.com and sign up for free to install your first Windows Agent.

This guide replaces the older sample-database setup flow. Query Streams no longer requires a bundled example database. Install the Agent, sign in with your organization key, add your data connectors inside the local Agent dashboard, and then use the Query Streams portal to build your first saved query.

Before You Start

Supported Windows versions

Windows 10, Windows 11, and Windows Server 2019 or newer are supported. Use a machine that can reach the databases you want to expose through Query Streams.

Administrator access

You may need administrator permission to complete installation, allow the local dashboard, and run the Agent as a background service.

Outbound HTTPS

The Agent needs outbound HTTPS access on port 443 to Query Streams cloud services. No inbound firewall rule is required.

Database network access

Install the Agent on a Windows machine in the same network, VPN, VPC, or routable environment as your database or API source.

Step 1: Download the Windows Agent

Sign in to my.querystreams.com/download.
Choose Windows from the Agent download options.
Download the latest Windows installer.
Copy your organization authentication key from the same download page. You will use it when the local Agent dashboard opens.

Step 2: Run the Installer

Open the downloaded installer from your browser downloads folder.
If Windows asks for confirmation, choose Yes to allow the installer to run.
Follow the installer prompts.
When installation finishes, open the local Agent dashboard at http://localhost:1823.

The local dashboard runs on your Windows machine at http://localhost:1823. It is used to enter your authentication key and manage local data connectors. Your database credentials stay on the Agent machine and are not sent to Query Streams cloud.

Step 3: Connect the Agent to Your Account

In the local Agent dashboard at http://localhost:1823, paste your Query Streams authentication key.
Save the key and wait for the Agent to register with your organization.
When setup completes, the Agent shows an online or connected status.
Select Add Data Sources to open the local connection wizard.

Step 4: Add Your First Data Source in the Local Agent

Do not add or edit connectors from the Query Streams portal. Connector setup is done in the local Network Agent dashboard at http://localhost:1823. This is where you add, edit, test, and delete database or API connectors such as Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, BigQuery, DuckDB, Stripe, HubSpot, Shopify, Google Analytics 4, Google Ads, Google Search Console, ShipStation, or iTick.

Open a browser on the Windows Agent machine and go to http://localhost:1823.
Click Add Data Sources or open the Agent connection area.
Choose your database or API connector type.
Enter connection details that are valid from the Windows Agent machine.
Select a data realm if prompted.
Test the connection, then save it.
For supported database connectors, leave Schema Intelligence enabled so Query Builder, Nova AI, and MCP clients get richer table and column context.

SQL ServerServer, database, username, password

PostgreSQLHost, port, database, SSL

MySQL / MariaDBHost, port, database, SSL

Local filesSQLite, DuckDB, Access

API connectorsCredentials, sync schedule, data realm

MCP-readyAI clients can query connectors directly

Network model

Connector management Local Agent dashboard: http://localhost:1823 Windows Agent Stores credentials locally and connects outbound Your database/API Private network connection from the Agent Query Streams cloud Receives connector metadata and routes query requests

Step 5: Build and Save Your First Query

After the connector and database are configured in the Agent, open the Query Streams portal and use Query Builder to create your first saved query. The saved query is what Excel, Google Sheets, Power Automate-style automations, secure REST API endpoints, and shared users can run without seeing your raw SQL or database credentials.

Open Query Builder in the Query Streams portal.
Select the data connector and database that you configured in the local Agent.
Write or generate a SQL query and run a preview.
Save the query with a clear name and any filters you want users to adjust.
Run the saved query from Microsoft Excel, Google Sheets, automations, REST APIs, or shared dashboards.

Local Agent

Add, edit, test, and delete connectors at localhost:1823.

Query Builder

Select the connector, choose the database, write SQL, preview, and save.

MCP access

MCP clients can also see available connectors and query the database directly through the Agent.

Troubleshooting

The Agent does not appear online +

Confirm the Windows machine has outbound HTTPS access on port 443, then reopen the local Agent dashboard and verify the authentication key was saved correctly. If your company uses an outbound proxy, allow Query Streams cloud traffic through that proxy.

A database connection test fails +

Test from the Windows machine where the Agent is installed. The Agent must be able to reach the database host and port directly. Also confirm the database username has read access to the tables or views you plan to query.

Do I need to open inbound firewall ports? +

No. The Agent creates an outbound encrypted connection to Query Streams. Query requests travel through that connection, so you do not expose SQL Server, PostgreSQL, MySQL, or any other database to the public internet.

Where are database credentials stored? +

Database credentials are stored on the Agent machine. Query Streams cloud does not need your raw database password to route query requests through the Agent.

Where do I add, edit, or delete connectors? +

Use the Network Agent’s local dashboard at http://localhost:1823. The Query Streams portal is where you build saved queries and share access after the Agent has the connector configured.

Can I install more than one Agent? +

Yes. Install Agents wherever your databases live: on-premise Windows Server, AWS EC2, Azure VMs, Google Cloud, or branch-office machines. Query Streams presents available sources in one account, even when different Agents host different connectors.

What should I do after installation? +

Create a saved query in the Query Streams portal, then run it from Microsoft Excel, Google Sheets, Nova AI, an MCP client such as Claude or Cursor, a scheduled automation, or a secure REST API endpoint.

Where is the sample database? +

The old sample database setup has been retired. Query Streams now guides you to connect your own live database or API source directly through the Agent.

Get Started

Install the Windows Agent and connect your first data source

Download the Agent, configure connectors locally at localhost:1823, then save reusable queries for Excel, Google Sheets, automations, MCP, REST APIs, and Nova AI.

Download Agent

Category: Setup

Tags: Windows, Query Streams Agent, Network Agent, Setup, Database Connector

Meta Description: Install the Query Streams Agent on Windows and connect live databases securely.

Updated on July 2, 2026

What are your Feelings

Happy
Normal
Sad