Anvil Database Connector - Build Apps with Live SQL Data

Skip to content

Home
Features
Connectors
Pricing
- vs Alternatives
Support
- Contact
- Docs

Home
Features
Connectors
Pricing
- vs Alternatives
Support
- Contact
- Docs

Isometric desktop monitor, for Setup

Setup

6

Is the Agent Online? What Offline Means and How to Fix It
How to Install the Query Streams Agent on Windows
How to Install the Query Streams Agent on Linux
How to Install the Query Streams Agent on macOS
Query Streams Access Level Permissions: Complete User Role Management Guide
How to Install the Query Streams Google Sheets Addon

Isometric speech-bubble block, for Nova AI

Nova AI

8

Nova Concierge Mode: A Personal Data Analyst for Every User
Nova Taught Knowledge: How Verified Learning Works
How Nova AI Learns Your Database Schema Automatically
AI Data Analytics: Query Any Database Without a BI Tool
BI and Data Analytics Without Tableau or Power BI
Text to SQL: How Nova AI Turns Questions Into Database Queries
AI Powered Analytics: Ask Questions, Get SQL + Charts
Natural Language to SQL: How Nova AI Turns Questions Into Database Queries

Isometric cubby with a parcel sliding in, for API to SQL Connector Setup

API to SQL Connector Setup

14

How to Connect iTick to Google Sheets — Live Stocks, Crypto, and Forex Data
How to Connect iTick to Microsoft Excel — Live Stocks, Crypto, and Forex Data
How to Connect Google Analytics to Google Sheets – Query Web Analytics with SQL
How to Connect Google Analytics to Excel – Query Web Analytics with SQL
How to Connect Google Search Console to Google Sheets – Query SEO Data with SQL
How to Connect Google Search Console to Excel – Query SEO Data with SQL
How to Connect HubSpot to Google Sheets – Query CRM Data with SQL
How to Connect HubSpot to Excel – Query CRM Data with SQL
How to Connect ShipStation to Excel – Query Shipping Data with SQL
How to Connect ShipStation to Google Sheets – Query Shipping Data with SQL
How to Connect Shopify to Google Sheets – Query E-Commerce Data with SQL
How to Connect Shopify to Excel – Query E-Commerce Data with SQL
How to Connect Stripe to Google Sheets – Query Payment Data with SQL
How to Connect Stripe to Excel – Query Payment Data with SQL

Isometric plug standing upright, for Data Connector Setup

Data Connector Setup

26

Set up the PostgreSQL connector
Set Up the Microsoft SQL Server Connector: Server Name, SQL Express, Logins and Cloud
Open a Firewall Port on Windows for SQL Server, PostgreSQL, MySQL or Oracle
Create a read-only database user for the Agent
Where the Agent Can Read Files From: Drive Letters, Shares, Cloud Folders, Mac and Linux
Set Up the Microsoft Access Connector: Database Engine and File Path
How to Connect BigQuery to Google Sheets – Stream Live Data Warehouse Analytics
How to Connect Oracle to Google Sheets – Stream Live Enterprise Database Data
How to Connect Oracle to Excel – Stream Live Enterprise Database Data
How to Connect BigQuery to Excel – Stream Live Data Warehouse Analytics
How to Connect DuckDB to Google Sheets – Stream Live Analytics Database Data
How to Connect DuckDB to Excel – Stream Live Analytics Database Data
How to Connect Snowflake to Excel – Stream Live Data Warehouse Analytics
How to Connect Snowflake to Google Sheets – Stream Live Data Warehouse Analytics
How to Connect Microsoft Access to Excel – Stream Live Database Data
How to Connect Microsoft Access to Google Sheets – Stream Live Database Data
How to Connect MariaDB to Google Sheets – Stream Live Database Data
How to Connect MariaDB to Excel – Stream Live Database Data
How to Connect MySQL to Google Sheets – Stream Live Database Data
How to Connect MySQL to Excel – Stream Live Database Data
How to Connect SQLite to Google Sheets – Stream Live Lightweight Database Data
How to Connect SQLite to Excel – Stream Live Lightweight Database Data
How to Connect PostgreSQL to Google Sheets – Stream Live Database Data
How to Connect PostgreSQL to Excel – Stream Live Database Data
How to Connect Microsoft SQL Server to Google Sheets – Stream Live Database Data
How to Connect Microsoft SQL Server to Excel – Stream Live Database Data

Isometric closed book standing upright, for Articles

Articles

51

Airtable Automation — Sync Live Database and API Data Automatically
Real-Time Analytics: Live Database Queries and Streaming Data in Spreadsheets
Excel Automation: Automate Live Database Reports Without Macros or VBA
ETL Tools Alternative: Skip the Pipeline, Query Your Database Live
Data Visualization Tools: Create Charts & Dashboards from Live SQL Queries
Data Integration Platform: Connect Any Database to Excel, Sheets & More
Database Analytics: Query, Analyze & Visualize Your Data Without a BI Platform
Data Democratization: Give Every Team Member Access to Database Insights
Data Analytics Platform: SQL-Powered Analytics for Every Database
Business Intelligence Software: Lightweight BI for Teams That Don’t Need Tableau
BI Tools for Spreadsheet Users: Real Analytics Without Leaving Excel or Google Sheets
Smartsheet Database Automation — Sync Live SQL Data Without Zapier
ODBC Alternative for Google Sheets
SeekWell Alternative — SQL to Spreadsheets Without Slack
SQL Server Reporting Without SSRS: Live Reports in Excel and Google Sheets
Oracle Reporting: Live Oracle Data in Excel and Google Sheets
Mixed Analytics Alternative for Google Sheets
Microsoft Access Reports: Build Better Reports from Your Access Database
Flatly Alternative for Google Sheets — Live SQL Without CSV Exports
Database Reporting Tool: SQL Reports Without a BI Platform
Database Automation: Schedule SQL Reports to Excel, Sheets and Airtable
Database Dashboard: Build Live SQL Dashboards in Excel and Google Sheets
Data Query in Excel: Pull Live Database Results into Any Spreadsheet
Connect REST APIs to Excel Without VBA or Power Query
Conversational BI: Query Any Database in Plain English
Airtable Reporting: Sync Live Database Results to Airtable
Connect Cloud Databases to Excel and Google Sheets (AWS RDS, Azure SQL, Google Cloud SQL)
Apipheny Alternative — API to Sheets Without Limits
Build No-Code Database Apps with Live SQL Data
Query Streams vs Coupler.io: Which Data Connector Is Right for You?
Skyvia Alternative 2026: Live Database Queries Without ETL
Google Sheets Reporting: Automate Live Database Reports
How to Import Any Database into Excel
Database vs Spreadsheet: When to Use Each and How to Connect Them
How to Run SQL Queries in Excel
SQL Reporting: Build Live Database Reports Without a BI Tool
Google Sheets Database 2026: Connect Any SQL Database to Sheets
Data Analytics to Increase Sales: Live CRM and Database Reporting in Sheets and Excel
Database Automation for IT Teams and DBAs: Secure Self-Service Data Access
BI Tools for Small Business: Analytics in Excel and Sheets Without Expensive Software
Financial Data Analytics: Live Database Queries in Excel and Google Sheets
SQL for Data Analysts: Live Database Queries in Excel and Google Sheets
Coefficient for Google Sheets: A Smarter Alternative for Database Users
ODBC Driver for Excel: Why You Don’t Need One Anymore
Supermetrics Alternative: SQL Databases + APIs in One Platform
Power BI Alternative: Live SQL in Excel & Google Sheets
Share ERP Data with External Partners Without System Access
Run SQL in Google Sheets Without Apps Script JDBC
SQL Global Database Access Without Drivers or Gateways
Microsoft Excel Power Query Alternative
Power Query for Google Sheets

Isometric round clock, for Automations

Automations

96

Airtable Automation
Anvil.works automation
Baserow Automation
Google sheet Automation
SeaTable Automation
Smartsheet Automation

Isometric database cylinder, for Data

Data

2

Share Live Data, Not Credentials
WordPress MySQL server using Query Streams, hosted on Siteground

Isometric connector block with a short plug, for MCP Server

MCP Server

75

Tuning What Your AI Client Receives
AI-Ready Databases: Semantic Intelligence for Your AI Client
Segments and Statistical Comparison for Your AI Client
Anomalies and Change Detection: Spikes and Level Changes via MCP
Result Diff: What Changed Between Two Held Results
Data Freshness and Changed-Since: Read Only New Rows via MCP
Follow-Up Questions on a Held Result, Without Re-Running the Query
Data-Quality Report: Check Your Data Before Your AI Client Uses It
Profile a Result: Summarise a Million Rows in One MCP Call
Shape First: Row Count and Size Before Your AI Client Reads a Table
Client-Aware Defaults: Result Sizes for Every MCP Client
Column and Cell Shaping: Trim Long Text Before It Reaches Your AI
Token Budget: Results Sized for Your AI Client, Never Cut Silently
Schema That Fits: Navigate Large Databases by Business Area via MCP
Analyse Your Data with Your AI Client: What Your Network Agent Does
Connect Nile to Claude with MCP
Connect Koyeb to Claude with MCP
Connect Prisma Postgres to Claude with MCP
Connect PlanetScale Postgres to Claude with MCP
Connect Timescale Cloud to Claude with MCP
Connect Xata to Claude with MCP
Connect MariaDB SkySQL to Claude with MCP
Connect IBM Cloud Databases for PostgreSQL to Claude with MCP
Connect MySQL HeatWave to Claude with MCP
Connect OCI Database with PostgreSQL to Claude with MCP
Connect Scaleway Managed Databases to Claude with MCP
Connect OVHcloud Managed Databases to Claude with MCP
Connect Vultr Managed Databases to Claude with MCP
Connect Fly.io Postgres to Claude with MCP
Connect Railway to Claude with MCP
Connect Render to Claude with MCP
Connect Heroku Postgres to Claude with MCP
Connect Crunchy Bridge to Claude with MCP
Connect Aiven to Claude with MCP
Connect DigitalOcean Managed Databases to Claude with MCP
Connect Google AlloyDB to Claude with MCP
Connect Google Cloud SQL to Claude with MCP
Connect Azure SQL to Claude with MCP
Connect Azure Database for MySQL to Claude with MCP
Connect Azure Database for PostgreSQL to Claude with MCP
Connect Amazon RDS to Claude with MCP
Connect Neon to Claude with MCP
Connect Any Log File to Claude with MCP
Connect Syslog and journald Logs to Claude with MCP
Connect JSON Application Logs to Claude with MCP
Connect Docker Container Logs to Claude with MCP
Connect Nginx, Apache and IIS Logs to Claude with MCP
Connect CNC and Machine Logs to Claude with MCP
Connect Multi-Record CSV Files to Claude with MCP
Connect a Folder of JSONL Files to Claude with MCP
Connect a Folder of SQLite Databases to Claude with MCP
Connect a Folder of Excel Files to Claude with MCP
Connect a Folder of Parquet Files to Claude with MCP
Connect a Folder of CSV Files to Claude with MCP
Connect Your File System to Claude with MCP
Connect iTick to Claude with MCP
Connect ShipStation to Claude with MCP
Connect Supabase to Claude with MCP
Connect Query Streams to Claude via MCP: Setup, Permissions and Troubleshooting
Connect Stripe to Claude with MCP
Connect Shopify to Claude with MCP
Connect Snowflake to Claude with MCP
Connect HubSpot to Claude with MCP
Connect DuckDB to Claude with MCP
Connect Google BigQuery to Claude with MCP
Connect MySQL to Claude with MCP
Connect Microsoft SQL Server to Claude with MCP
Connect Google Analytics 4 to Claude with MCP
Connect Microsoft Access to Claude with MCP
Connect Oracle to Claude with MCP
Connect Google Ads to Claude with MCP
Connect SQLite to Claude with MCP
Connect MariaDB to Claude with MCP
Connect PostgreSQL to Claude with MCP
Connect Google Search Console to Claude with MCP

Isometric wall with one outward arrow, for Security and Trust

Security & Trust

1

How Query Streams Keeps Your Data Secure

Isometric closed file folder, for File Set Connectors

File Set Connectors

14

Custom Log Analysis with SQL: Parse Any Text Log
Query Linux Syslog Files with SQL
Query Application Logs with SQL (JSON and Text)
Query Docker Container Logs with SQL
Query nginx, Apache and IIS Logs with SQL
CNC Machine Monitoring with SQL from Controller Log Files
Index a File System and Query It with SQL
Query Multi-Record CSV Files with SQL
Query a Folder of Parquet Files with SQL
Combine Multiple SQLite Database Files Into One Table
Turn a Folder of JSON Files Into SQL Tables
Merge Multiple Excel Files Into One Table
Combine Multiple CSV Files Into One Table
How to Query a Folder of Files with SQL

Isometric single slider, for Filter Parameters

Filter Parameters

1

Query Streams SQL Filters and Parameters Overview

Isometric free-standing arch gate, for Database REST API

Database REST API

61

MySQL HeatWave REST API: Turn a SQL Query into an Endpoint
OCI Database with PostgreSQL REST API: Turn a SQL Query into an Endpoint
iTick Data REST API: Turn a SQL Query into an Endpoint
Scaleway Managed Databases REST API: Turn a SQL Query into an Endpoint
ShipStation Data REST API: Turn a SQL Query into an Endpoint
OVHcloud Managed Databases REST API: Turn a SQL Query into an Endpoint
Supabase REST API for Custom SQL Queries
Vultr Managed Databases REST API: Turn a SQL Query into an Endpoint
Custom Logs REST API: Turn a SQL Query into an Endpoint
Fly.io Postgres REST API: Turn a SQL Query into an Endpoint
System Logs REST API: Turn a SQL Query into an Endpoint
Railway REST API: Turn a SQL Query into an Endpoint
Application Logs REST API: Turn a SQL Query into an Endpoint
Render REST API: Turn a SQL Query into an Endpoint
Container Logs REST API: Turn a SQL Query into an Endpoint
Heroku Postgres REST API: Turn a SQL Query into an Endpoint
Web Server Logs REST API: Turn a SQL Query into an Endpoint
Crunchy Bridge REST API: Turn a SQL Query into an Endpoint
Machine Logs REST API: Turn a SQL Query into an Endpoint
Aiven REST API: Turn a SQL Query into an Endpoint
Multi-record CSV REST API: Turn a SQL Query into an Endpoint
DigitalOcean Managed Databases REST API: Turn a SQL Query into an Endpoint
JSONL Folder REST API: Turn a SQL Query into an Endpoint
Google AlloyDB REST API: Turn a SQL Query into an Endpoint
SQLite Folder REST API: Turn a SQL Query into an Endpoint
Google Cloud SQL REST API: Turn a SQL Query into an Endpoint
Excel REST API: Turn a SQL Query over Excel Files into an Endpoint
Azure SQL REST API: Turn a SQL Query into an Endpoint
Parquet Folder REST API: Turn a SQL Query into an Endpoint
CSV to REST API: Turn a SQL Query over CSV Files into an Endpoint
Azure Database for MySQL REST API: Turn a SQL Query into an Endpoint
File System REST API: Turn a SQL Query into an Endpoint
Azure Database for PostgreSQL REST API: Turn a SQL Query into an Endpoint
Nile REST API: Turn a SQL Query into an Endpoint
Amazon RDS REST API: RDS Data API Alternative for Any Engine
Koyeb REST API: Turn a SQL Query into an Endpoint
Neon REST API: Turn a SQL Query into an Endpoint
Prisma Postgres REST API: Turn a SQL Query into an Endpoint
Google Search Console Data REST API: Turn a SQL Query into an Endpoint
PlanetScale Postgres REST API: Turn a SQL Query into an Endpoint
Google Analytics 4 Data REST API: Turn a SQL Query into an Endpoint
Timescale Cloud REST API: Turn a SQL Query into an Endpoint
Google Ads Data REST API: Turn a SQL Query into an Endpoint
Xata REST API: Turn a SQL Query into an Endpoint
HubSpot Data REST API: Turn a SQL Query into an Endpoint
MariaDB SkySQL REST API: Turn a SQL Query into an Endpoint
IBM Cloud Databases for PostgreSQL REST API: Turn a SQL Query into an Endpoint
Shopify Data REST API: Turn a SQL Query into an Endpoint
Power BI REST API: Connect Live SQL Data Without ODBC Drivers
Stripe Data REST API: Turn a SQL Query into an Endpoint
MariaDB REST API: Turn a SQL Query into an Endpoint
Google BigQuery REST API: Turn a SQL Query into an Endpoint
MySQL REST API: Turn a SQL Query into an Endpoint
Microsoft SQL Server REST API: Turn a SQL Query into an Endpoint
Oracle REST API Without ORDS: Turn a SQL Query into an Endpoint
Snowflake REST API: An Alternative to the Snowflake SQL API
Microsoft Access REST API: Turn a SQL Query into an Endpoint
SQLite REST API: Turn a SQL Query into an Endpoint
DuckDB REST API: Turn a SQL Query into an Endpoint
PostgreSQL REST API: PostgREST Alternative for SQL Queries
Database REST API: Turn Any SQL Query into an Endpoint

View Categories

Home
Docs
Automations
Anvil.works automation

Isometric app window with one round button, for Anvil.works Automation

Anvil.works automation

16 Docs

Sync Google Search Console to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Google Analytics 4 to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync ShipStation to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync HubSpot to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Shopify to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Stripe to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Microsoft SQL Server to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync PostgreSQL to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync DuckDB to Anvil.works on a Schedule

Last Updated: October 12, 2026

Sync Google BigQuery to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Snowflake to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Oracle to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync Microsoft Access to Anvil.works on a Schedule

Last Updated: October 12, 2026

Sync SQLite to Anvil.works on a Schedule

Last Updated: October 12, 2026

Sync MariaDB to Anvil.works on a Schedule

Last Updated: September 26, 2026

Sync MySQL to Anvil.works on a Schedule

Last Updated: September 26, 2026

Copyright © 2026 ■ Query Streams - Data Platform

We've detected you might be speaking a different language. Do you want to change to:

English

English

English

Spanish

German

French

Portuguese

Japanese

Korean

Chinese

Italian

Dutch

Indonesian

Polish

Change Language

Close and do not switch language

English

Spanish

German

French

Portuguese

Japanese

Korean

Chinese

Italian

Dutch

Indonesian

Polish