Canonical: https://molo17.com/blog/gluesync-query-studio-embedded-sql-workbench/ Markdown mirror: https://molo17.com/blog/gluesync-query-studio-embedded-sql-workbench/index.md Title: Gluesync Query Studio: Embedded SQL Workbenches for CDC Description: Explore Gluesync Query Studio, an embedded SQL Workbenches built into the control plane with isolated connection pools and read-only safeguards. [← All articles](/blog/) Article # Inside Gluesync Query Studio: embedded SQL for real-time data validation 1 Jul 2026 [Gluesync integrates](/blog/?category=gluesync-integrates) 2 min read Gluesync Query Studio: Embedded SQL Workbenches for CDC  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**](https://molo17.com/blog/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**](https://docs.molo17.com/gluesync/latest/release-notes/release-notes.html).  [Request a free 30-day trial](http://www.molo17.com/get-gluesync/) now. [← Older article Gluesync 2.2.9: Query Studio, Universal File Store Agent, Filed Functions and more](/blog/gluesync-2-2-9/) [Newer article → Data masking and transformation at the edge: introducing Gluesync field functions](/blog/data-masking-transformation-edge-gluesync-field-functions/) ## Keep reading 1. [Mentioned in this article Query Forge: cross-database federated SQL querying without data movement Query Forge turns Gluesync Core Hub into a secure federated SQL gateway. Run cross-database JOINs across remote agents using a dedicated JDBC driver with zero data movement. 5 Aug 2026](/blog/query-forge-federated-sql-querying/) 2. [Mentioned in this article Gluesync 2.2.9: Query Studio, Universal File Store Agent, Filed Functions and more 2.2.9 introduces Query Studio, new Control Plane UI, native DB2 LUW log-based CDC, Field Functions and the iOS/Android mobile companion app. 30 Jun 2026](/blog/gluesync-2-2-9/) 3. [Gluesync integrates YugabyteDB agent for Gluesync: unlock real-time data integration with distributed SQL The YugabyteDB agent for Gluesync is now available, offering seamless integration with YugabyteDB distributed SQL databases. This new agent supports bidirectional integration with full Change Data Capture (CDC) capabilities, \[…\] 8 May 2025](/blog/yugabytedb-agent-for-gluesync/) [Back to all articles](/blog/) [More in Gluesync integrates →](/blog/?category=gluesync-integrates)