Canonical: https://molo17.com/query-forge/ Markdown mirror: https://molo17.com/query-forge/index.md Title: Query Forge · Gluesync · MOLO17 Description: A secure federated SQL gateway on Core Hub. Run cross-database JOINs across isolated agents with zero raw data movement. Gluesync Module # Query Forge A secure federated SQL gateway on Core Hub. Run cross-database JOINs across isolated agents with zero raw data movement. [Explore Query Forge](#features) [Talk to our team](/contacts/?topic=gluesync-platform)  Why Query Forge ## Cross-database answers without warehouse tax 01 / Costly pipelines ### ETL just to ask a question Teams stand up warehouses and extraction jobs so BI and DBAs can join data that already lives behind Gluesync agents. 02 / Manual stitching ### Isolated client queries Without federation, analysts run separate queries in different tools and reconcile results in spreadsheets — slow and error-prone. 03 / The platform outcome ### Zero-copy federation Query Forge turns Core Hub into a JDBC gateway so one SQL statement can join remote schemas without copying raw datasets. Capabilities ## Federated SQL on the infrastructure you already run Built on Query Studio infrastructure, Query Forge exposes each SQL-capable agent as a schema and plans joins centrally with intelligent pushdown. Federated architecture ### How Query Forge works #### Plan centrally, push filters down, join in memory Instead of new data movement pipelines, Core Hub receives the SQL statement, pushes projections and filters to remote agents, then evaluates joins with Apache Calcite. - Central query planning across relevant agents - Pushdown for projections and filters (=, <>, <, >, LIKE, IS NULL, AND/OR/NOT) - Only filtered rows travel the wire for central join evaluation - Bridges relational engines and NoSQL stores behind agents [View Query Forge docs ↗](https://docs.molo17.com/gluesync/latest/gs-modules/query-forge.html) Query Forge  ### Multi-source querying without data movement Query across relational, legacy, and NoSQL environments from a single developer or BI connection. Gluesync resolves schemas and returns results transparently.  Standard connectivity ### Dedicated JDBC driver #### Connect DBeaver, DataGrip, Tableau, and custom scripts A branded JDBC endpoint (jdbc:gluesync://host:port) makes Core Hub feel like a single SQL system to external clients. - Personal API Token authentication (gsp\_…) or local account credentials - No shared service credentials - Predictable schema naming for single- and multi-agent pipelines - Works with standard BI and SQL tooling [View Query Forge docs ↗](https://docs.molo17.com/gluesync/latest/gs-modules/query-forge.html) ### Unified JDBC gateway One connection string. Many agents. Warehouse-style querying flexibility without storage overhead or continuous extraction latency.  Enterprise safety ### Read-only security model #### Per-user scope with zero write risk to production Every federated query runs under the caller’s identity through the read-only execution path, with permissions scoped to pipelines and agents. - Strict read-only execution path - Users only discover schemas and tables they are allowed to see - Fine-grained permission scoping at pipeline and agent level - Zero-copy operations — no warehouse mirror required [View Security docs ↗](https://docs.molo17.com/gluesync/latest/gs-modules/query-forge.html) Explore the platform ## Continue exploring Gluesync Query Forge extends Query Studio into a federated gateway. Explore the workbench, Knowledge querying, or the full Gluesync platform. [ ### Query Studio Embedded SQL workbench in the Control Plane for schema browsing and live validation. Explore Query Studio →](/query-studio/) [ ### Schedules and events Chronos schedules, chained workflows, webhooks, and Core Hub event triggers. Explore Schedules and events →](/schedules-and-events/) [ ### Gluesync Real-time CDC plus federated querying under one Core Hub operational interface. Explore Gluesync →](/gluesync/) Resources ## Guides, roadmap and support Documentation  ### Documentation Technical guides, API reference, deployment tutorials. [Read documentation ↗](https://docs.molo17.com) Roadmap  ### Public Roadmap What we're building next. Submit feature requests. [View roadmap ↗](https://roadmap.molo17.com) Support  ### Support Access technical support and operational assistance. [Get support ↗](https://support.molo17.com) Status  ### Service Status Real-time platform availability and incident history. [Check status ↗](https://status.molo17.com) ## Federated SQL without the warehouse tax Request a free trial or talk with the MOLO17 team about deploying Query Forge on your Core Hub. [Request a free trial](/get-gluesync/) [Talk to our team](/contacts/?topic=gluesync-platform)