For teams that live in spreadsheets, getting live data from internal databases is usually a pain — VPNs, fragile ODBC/SQL drivers, endless CSV exports.
QueryStreams uses a lightweight Windows Agent to pipe queries directly into Excel or Google Sheets. No VPN, no firewall tweaks, and reusable queries with dynamic filters. Setup is surprisingly quick if you have at least basic SQL knowledge.
Has anyone tried similar approaches for keeping spreadsheets live with production data? How do you handle security and refresh reliability?