Query Streams vs Teiid
Query Streams
querystreams.comTeiid
teiid.ioSide by side
| Figure | Query Streams | Teiid |
|---|---|---|
| Price from | $15/mo | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 4 | 1 |
| Spec score · Data Virtualization Software | 9.1 (#1) | 8.1 (#10) |
| Connectors | The connector directory lists 53 sources, including 11 database engines, 27 hosted or managed services, 8 business APIs, and 7 file and folder types. | Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files, and custom translators can be created. |
| Federated queries | Federated SQL can join data from multiple connected databases without first exporting or copying the source data. | Teiid can join and union data across dissimilar sources so they appear as one source to an application. |
| License | The service and Agent are proprietary commercial software licensed for internal business use; the terms prohibit copying, modification, reverse engineering and redistribution. | The community page says that starting with Teiid 10.0, the majority of Teiid and related project code is under the Apache License 2.0. |
| Purpose | Query Streams provides governed access to databases and APIs for spreadsheets, AI clients, apps, and scheduled data syncs through an outbound-only Network Agent. | Teiid is a Java data virtualization query engine that integrates data from multiple sources through a uniform API. |
| Security | The Network Agent initiates an encrypted outbound connection, requires no inbound ports or VPN, and enforces SELECT, WITH, and EXPLAIN-only queries; database credentials stay on the user's network. | The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies. |
| Support | The site provides a contact form for questions and links to its documentation archive. | The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers. |
Plans
Query Streams
- FreeFree
- Personal Core$15 a month
- Personal Plus$30 a month
- Business Core$50 a month
In their own words
Query Streams
Query Streams gives spreadsheets, AI clients, apps, and scheduled syncs governed access to databases and APIs through an outbound-only Network Agent. Nova AI accepts plain-English questions, reads a database schema, runs read-only SQL, and returns metrics, tables, and charts. A hosted MCP server connects sources to Claude, Cursor, ChatGPT, and Grok using a revocable key. Excel and Google Sheets add-ins run shared saved queries and stream live results into cells without exposing SQL to recipients. Federated queries join data from multiple databases and API sources in one SQL statement. Scheduled results can be sent to supported services as often as every five minutes. The Network Agent makes an encrypted outbound connection, needs no inbound ports or VPN, restricts queries to SELECT, WITH, and EXPLAIN, and keeps database credentials on the user's network. The Free tier is free and includes 5 MB/month query traffic; paid plans start at $15 a month. New accounts receive a 30-day trial with every feature unlocked and no credit card.
Teiid
Teiid is a free, open-source data virtualization project that gives applications a uniform way to query multiple underlying sources. It works as a gateway rather than storing the data, and virtual databases can present separate sources together so applications can join or union their results. Access is available through JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be made. Its optimizer uses source capability information to send query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift, with Spring Boot noted as less feature-complete than WildFly. Teiid is aimed especially at Java developers integrating enterprise data sources. Connecting to sources commonly requires third-party drivers that are not included. The FAQ cautions that big-data, LDAP-style, and primarily streaming workloads may not be a good fit. Teiid Designer is deprecated, with no further releases expected.