Gluesync Module

Query Forge

A secure federated SQL gateway on Core Hub. Run cross-database JOINs across isolated agents with zero raw data movement.

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 ↗

Query Forge
Query Forge federated SQL architecture diagram

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.

Federated query from PostgreSQL, Oracle, MongoDB and MySQL

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 ↗

Unified JDBC gateway

One connection string. Many agents. Warehouse-style querying flexibility without storage overhead or continuous extraction latency.

SQL clients and BI tools sharing one Gluesync JDBC connection string into Core Hub, which pushes queries down to four agents

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 ↗

Resources

Guides, roadmap and support

Roadmap

Public Roadmap

What we're building next. Submit feature requests.

View roadmap ↗
Support

Support

Access technical support and operational assistance.

Get support ↗
Status

Service Status

Real-time platform availability and incident history.

Check status ↗

Federated SQL without the warehouse tax

Request a free trial or talk with the MOLO17 team about deploying Query Forge on your Core Hub.