--- title: "SQL Editor" slug: "sqleditor" status: "update" updated: 2025-09-15T06:52:12Z published: 2025-09-15T06:52:12Z canonical: "skthelp.syniti.com/sqleditor" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # SQL Editor ## Overview SQL Editor is a unified interface for creating, executing, and managing SQL commands directly in the Migrate module, eliminating the need for external SQL querying tools while maintaining security through controlled access and permissions on your Datasources. SQL Editor prevents unauthorized database access risks, provides audit trails for all database operations, and ensures compliance with security policies. The integrated AI-powered SQL Assist service enhances productivity by helping users write, debug, explain, and optimize SQL statements through conversational interaction. Refer to [SQL Assist](/v1/docs/sql-assist) for more information. Refer to [Working with SQL Editor](/v1/docs/working-with-sql-editor) for more information on the functionalities and features available in SQL Editor. ## Supported Database Systems Currently, the following database systems are supported for SQL scripting in SQL Editor: - Microsoft SQL Server - PostgreSQL - SAP HANA > [!NOTE] > Note > > To see [Datastores](/v1/docs/datastores) in the Object Explorer panel, they must be registered as [Datasources](/v1/docs/adding-editing-datasources) in Migrate. ## Key Features - **Datastore Object Explorer:** SQL Editor displays a hierarchical tree structure of the database schemas and objects present in your selected datastore, showing available schemas and its objects. The tree structure representation helps you navigate complex datastore structures and reference objects. - **Query Execution with Controlled Permissions:** You can only perform the operations granted to your role in SQL Editor. This security measure prevents unauthorized access risks while providing audit trails and ensuring policy compliance. Refer to the [Roles and Permissions](/v1/docs/sqleditor#roles-and-permissions) section below for more information. - **User-Friendly Querying Panel:** A comprehensive SQL development environment that combines traditional code editing capabilities with modern AI assistance and integrated database management features. - **History and Script Change Tracking:** Monitor all query modifications and execution history. Copy previous queries directly from the History panel to reuse or modify existing SQL statements. - **AI-Powered SQL Assistant:** SQL Assist revolutionizes SQL development through conversational AI interaction, intelligently understanding your datastore structure to provide contextual assistance for database operations. ## Roles and Permissions The following table outlines user roles and their associated permissions, which can be used to assign appropriate access levels and prevent unauthorized access: > [!NOTE] > Note > > You'll receive an error message if you don't have the privilege to run a particular statement. | **Role** | **Permissions** | | --- | --- | | Migrate Read-Only Analyst | Can execute **DQL** statements (SELECT) to view or retrieve data from authorized data objects. | | Migrate Contributor | Has access to **DQL** and **DML** statements (for example, INSERT, UPDATE, and DELETE) on authorized data objects. | | Migrate Developer | Includes all Contributor permissions, plus the ability to execute **DDL** statements (for example, CREATE, ALTER, DROP, and TRUNCATE) on data objects within authorized datastores and schemas. | | Migrate Administrator | Includes all Developer privileges, with additional access to execute queries on **all data objects** across the entire database system in the SKP tenant. | ## Accessing SQL Editor You can access SQL Editor in the following methods: 1. Using the **SQL Editor** link in the Migrate card on the Syniti Knowledge Platform home page. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(817).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A06Z&se=2026-11-17T20%3A25%3A06Z&sr=b&sp=r&sig=0htpubhBKN4Hnik%2FHjYjPrNJbWkTOjW5CeGa82SqZqc%3D) 2. From the *Migrate* menu using the following path: **Administer > Advanced > SQL Editor**. 3. From the *Target Reports* page (accessed via **Migrate > Mappings > Targets panel > Reports column**): 1. In the Actions column, using the **Open in SQL Editor** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(748).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A06Z&se=2026-11-17T20%3A25%3A06Z&sr=b&sp=r&sig=Cc0voQ0Z9E6MAE5%2BSH3ZHwW1Afpg3gpIDkjYmwYxx38%3D) icon for the associated target report. 2. In the Report DDL dialog box, using the **Open in SQL Editor** button when viewing/editing a specific Target Report details. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(749).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A06Z&se=2026-11-17T20%3A25%3A06Z&sr=b&sp=r&sig=lCslf%2FA5KsPwqdkhNaus78OdJeTDp6j3aqSAykPotAM%3D) 4. From the *ETL Tasks* page (accessed via **Migrate > ETL Jobs > Edit an ETL Job** or **Migrate > Mappings > ETL column**): 1. Using the **Open in SQL Editor** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(748).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A06Z&se=2026-11-17T20%3A25%3A06Z&sr=b&sp=r&sig=Cc0voQ0Z9E6MAE5%2BSH3ZHwW1Afpg3gpIDkjYmwYxx38%3D) icon when viewing ETL Task list in an ETL Job. 2. Using the **Open in SQL Editor** button in the Rule DDL tab of the Edit ETL Task dialog box when editing a specific ETL Task’s details. ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(770).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A25%3A06Z&se=2026-11-17T20%3A25%3A06Z&sr=b&sp=r&sig=LlIAeubhkpc58QpDPVIbgaFbJCSh0IrJcO2%2BBvriFig%3D) Methods 3 and 4 opens the SQL Editor page in a new tab with the associated DDL script of the respective report view or ETL rule. Refer to [Working with SQL Editor](/v1/docs/working-with-sql-editor) to read more about functionalities and features available in SQL Editor. ## Related Articles - [Datasources](/v1/docs/datasources) - [Datastores](/v1/docs/datastores) - [SQL Assist](/v1/docs/sql-assist) - [Working with SQL Editor](/v1/docs/working-with-sql-editor)