Your Team Needs Data.
Not Another Ticket.
Deploy a secure network agent, build read-only queries once, and let business users self-serve live data in Excel and Google Sheets — no VPNs, no shared credentials, no bottleneck.
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 IT teams and DBAs eliminate the data request bottleneck by enabling controlled, self-service access to live database data. Learn more at QueryStreams.com and sign up for free to start deploying secure database automation for your organization.
The IT Data Request Bottleneck
If you manage databases for a living, you know the pattern. A sales manager needs last quarter’s revenue by region. A finance analyst wants an updated vendor spend report. A product lead asks for user engagement numbers. Each request becomes a ticket, and each ticket lands on your desk. According to Gartner, IT teams spend up to 40% of their time responding to ad-hoc data requests rather than strategic projects. The alternative — giving business users direct database access — introduces unacceptable security risks. Database automation tools like Query Streams break this cycle entirely by letting you build controlled, read-only queries that non-technical users can execute themselves from Microsoft Excel or Google Sheets.
Ticket Overload
Every “can you pull this data?” request becomes another ticket eating into your strategic project time.
Direct Access Risk
Giving users database credentials exposes production systems to accidental writes, schema changes, or data leaks.
VPN Dependency
Traditional database access requires VPN connections, adding complexity for remote workers and external partners.
Credential Sprawl
Managing shared database passwords across teams leads to credential sprawl and audit nightmares.
These pain points compound over time. Your team becomes a human middleware layer between databases and the people who need data. SQL automation and self-service data access are the only scalable paths forward — but they have to be done securely.
How Query Streams Enables Secure Self-Service Data Access
Query Streams flips the traditional data access model. Instead of users connecting directly to your database, a lightweight Query Streams Agent runs on your server (or any machine with database access) and makes an outbound-only connection to the Query Streams cloud relay. You build queries in the web portal, control who can access them, and business users run those pre-approved queries from the Microsoft Excel add-in or Google Sheets add-on whenever they need fresh data. The SQL is never exposed to end users — they only see the results.
Deploy the Agent
Install the Query Streams Agent on any Windows or Linux server with database access. No inbound firewall rules needed.
Build Read-Only Queries
Write SQL in the web portal with optional interactive filters. Query Streams auto-detects filterable values or supports explicit variables.
Share with Users
Grant per-user or per-team access to specific queries. Users never see the SQL, connection strings, or credentials.
Self-Serve from Spreadsheets
Business users open the Excel or Sheets add-on, pick a query, set filters, and pull live data on demand — without IT involvement.
This model transforms your role from “person who runs reports” to “person who defines the data access layer.” You set it up once, and the system handles every subsequent request automatically. Users can even run multiple saved queries in parallel — five queries into five different worksheet tabs simultaneously — with the Agent streaming each result concurrently regardless of result size.
Security Architecture: No Inbound Firewall Rules Required
Security is the first concern for any DBA or IT administrator evaluating database automation tools. Query Streams was designed from the ground up for zero-trust environments. The Agent never accepts inbound connections — it only initiates outbound WebSocket connections to the cloud relay, which means there are no open ports, no inbound firewall rules, and no VPN tunnels to manage. This is fundamentally different from solutions that require you to expose your database to the internet or configure port forwarding.
Outbound-Only Connections
The Agent initiates all connections outward. No inbound firewall rules, no open ports, no attack surface.
Read-Only Query Execution
All queries executed through Query Streams are read-only. No INSERT, UPDATE, DELETE, or DDL operations reach your database.
SQL Hidden from Users
End users never see the underlying SQL code, table names, or schema structure. They only interact with named queries and filters.
Per-User Access Controls
Share specific queries with specific users or teams. Each person only sees the queries they have been granted access to.
Zero Credential Sharing
Database credentials stay on your server with the Agent. No passwords are shared with users, stored in spreadsheets, or transmitted to the cloud.
Execution Audit Trail
Every query execution is logged with timestamps, user identity, and parameters. Full visibility for compliance and internal audits.
Cross-Platform Agent Deployment
The Query Streams Agent runs on every major platform your infrastructure uses. Whether your databases live on bare-metal Windows servers in a data center, Ubuntu instances on AWS EC2, macOS development machines, or Azure VMs running Linux, the Agent installs in minutes and connects immediately. Multiple agents can be deployed per account — across different networks, regions, and cloud providers — and all their data sources appear as a unified dropdown in the query builder.
| Platform | Environment | Installation |
|---|---|---|
| Windows Server | On-premises, Azure VMs, AWS EC2, Google Cloud | Windows installer (.exe) |
| Ubuntu / Debian Linux | On-premises, AWS EC2, Google Cloud, Azure VMs | DEB package |
| Linux (Generic) | Any Linux distribution | Tar.gz archive |
| macOS (Intel & Apple Silicon) | Development, local databases | Tar.gz archive |
All agents self-maintain with automatic updates. When a new version is released, agents download and apply the update without any intervention from your team. You can monitor agent status, connected data sources, and execution history from the Query Streams web portal. The Agent supports connections to SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, BigQuery, DuckDB, and more — from a single installation.
DBA Benefits: Control Without Being the Bottleneck
For database administrators specifically, Query Streams solves a fundamental tension: you need to protect your databases, but you also need to serve the people who depend on that data. Traditional approaches force you to choose between security (lock everything down, every request goes through you) and convenience (hand out credentials and hope for the best). Query Streams lets you have both.
-
Manual report generation
Every data request requires you to write and run a query, then export results to CSV or email.
-
Shared database credentials
Multiple teams share a single read-only account, with no way to trace who ran what query.
-
VPN-only access
Remote users and partners cannot access data without a VPN connection, creating friction and support tickets.
-
No audit trail
You have no visibility into which users accessed what data, when, or how often.
-
One-time query setup
Build a query once with interactive filters, and any authorized user can run it on demand from Excel or Sheets.
-
Zero credential exposure
Database passwords never leave your server. Users authenticate through the Query Streams portal with their own accounts.
-
Access from anywhere
No VPN required. The outbound-only Agent handles secure connectivity, so users can pull data from any location.
-
Full execution logging
Every query run is logged with user identity, timestamp, and filter parameters for complete audit compliance.
Query Streams also supports interactive filters that you can configure from the query’s Properties tab. You can create filters from explicit SQL variables (e.g., @region, @start_date) or let Query Streams auto-detect static values in your WHERE clauses (e.g., WHERE department = 'Sales'). End users see a clean dropdown or date picker — they adjust the filter and run the query without understanding the SQL behind it.
Nova AI: Eliminate “Write Me a Query” Tickets
Beyond pre-built saved queries, Query Streams includes Nova AI — a natural-language-to-SQL engine that is schema-aware and dialect-correct. Nova connects to your actual database schema and generates SQL that matches your tables, columns, and relationships. For the queries your business users need that do not already exist as saved queries, Nova lets them ask in plain English and get results directly — without filing a ticket for you to write the SQL.
- Schema-aware generation: Nova reads your actual table structure, so generated queries reference real columns and relationships — not hallucinated schema.
- Dialect-correct SQL: Whether your database is PostgreSQL, SQL Server, MySQL, Oracle, Snowflake, or BigQuery, Nova generates syntax that matches the target dialect exactly.
- Auto-generated charts: Nova produces visualizations alongside query results, so users get answers and charts without needing a separate BI tool.
- Reduced IT workload: Users who would normally submit “write me a query” tickets can now ask Nova directly, freeing your team for infrastructure and security work.
Supported Databases and Integrations
Query Streams connects to the databases your organization already runs. A single Agent installation can serve connections to multiple database engines simultaneously, and all data sources are presented as a unified list in the query builder. Supported databases include Microsoft SQL Server (including Azure SQL Database), PostgreSQL (including AWS RDS and Google Cloud SQL), MySQL, MariaDB, SQLite, Microsoft Access, Oracle, Snowflake, Google BigQuery, and DuckDB — with more integrations coming soon.
On the output side, users access data through the Microsoft Excel add-in, the Google Sheets add-on, or the Query Streams web portal. Excel and Sheets support parallel query execution — users can launch multiple saved queries simultaneously into different worksheet tabs, and the Agent streams each result concurrently. This means a finance team can refresh five different reports at once without waiting for each to complete sequentially.
Frequently Asked Questions
What is database automation for IT teams? +
How does Query Streams handle security without requiring VPN access? +
Can I deploy agents on both Windows and Linux servers? +
How do I control which queries specific users can run? +
Does Query Streams work with cloud databases like AWS RDS and Azure SQL? +
What is Nova AI and how does it reduce IT support tickets? +
How do agents receive updates? +
Can I deploy multiple agents across different networks and regions? +
Get Started
Stop Being the Data Bottleneck
Deploy a secure Query Streams Agent in minutes, build your first self-service query, and free your team from ad-hoc data requests. No credit card required for the free tier.
Related guides: Download the Query Streams Agent | Databases in Microsoft Excel | Databases in Google Sheets | AI Data Analytics with Nova | Text to SQL
Category: Articles
Tags: database automation tools, sql automation, self-service data access, DBA tools, IT data management, secure database access, database security, query automation, read-only database access, spreadsheet database connector
Meta Description: Secure database automation for IT teams and DBAs. Self-service data access via Excel and Sheets.
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish