Inside Gluesync Query Studio: embedded SQL for real-time data validation

When operating modern data replication pipelines, engineers, DBAs, and developers must constantly validate synchronized datasets. Traditionally, this process required switching between the Gluesync Control Plane and external database tools to inspect data, run queries, and troubleshoot issues. However, Gluesync 2.2.9 simplifies this workflow through Query Studio, an embedded SQL workbench integrated directly into the Control Plane.

A unified environment for data

 inspection

 

Query Studio allows users to execute SQL queries and validate live datasets without leaving the Gluesync interface. Built into the Core Hub, it leverages existing configured connections. Therefore, it reduces the need to manually manage external database clients or credentials.

This enables teams to work within a single operational environment for both pipeline monitoring and data exploration.

Built into the Control Plane

Query Studio is fully embedded in the Gluesync Control Plane and provides a structured workspace for interacting with connected data sources.

The interface includes:

• a schema browser for navigating databases, schemas, tables, and columns
• a multi-tab SQL editor for composing and managing queries
• a results console for viewing query outputs, execution logs, and analysis information

This layout is designed to support efficient navigation and query execution across multiple environments.

Query capabilities and developer support

To support a wide range of use cases, Query Studio includes several productivity-focused features:

• dialect-aware autocomplete for supported database engines
• explain plan visualization for analyzing query execution strategies
• query parameter support for dynamic query execution
• saved queries for reuse across sessions and teams
• export options including CSV, JSON, and SQL INSERT formats

These capabilities help streamline both ad-hoc analysis and repeatable validation workflows.

Multi-engine support

Query Studio supports 16 database engines out of the box, covering a broad set of relational and analytical systems. Consequently, teams can interact with heterogeneous environments through a consistent interface inside Gluesync.

Security and governance

Security and operational control remain central to Query Studio’s design. Key governance features include:

• role-based access control (RBAC) for managing user permissions
• read-only mode by default, helping protect production systems
• optional write mode for authorized roles such as SUPER_ADMIN and MANAGER
• query auditing with 90-day retention for traceability and compliance

Ultimately, these controls ensure that Query Studio can be safely used in enterprise environments where data access must be carefully managed.

From monitoring to active data operations

With Query Studio, Gluesync evolves from a replication monitoring platform into a more interactive data operations environment. Specifically, users can now inspect and validate replicated data directly where pipelines are managed, reducing context switching and improving operational efficiency.

Get started with Gluesync 2.2.9

Query Studio is available as part of Gluesync 2.2.9 and can be used across cloud, virtualized, and Kubernetes-based deployments.

To learn more about setup, configuration, and supported database engines, refer to the official Gluesync Documentation.

 Request a free 30-day trial now.