---
title: Explore Your Data with AI-Assisted SQL Editor
summary: Learn how to use AI-assisted SQL Editor in the TiDB Cloud console, to maximize your data value.
---

# Explore Your Data with AI-Assisted SQL Editor

You can use the built-in AI-assisted SQL Editor in the [TiDB Cloud console](https://tidbcloud.com/) to maximize your data value.

In SQL Editor, you can either write SQL queries manually or simply press <kbd>⌘</kbd> + <kbd>I</kbd> on macOS (or <kbd>Control</kbd> + <kbd>I</kbd> on Windows or Linux) to instruct [Chat2Query (beta)](/tidb-cloud/tidb-cloud-glossary.md#chat2query) to generate SQL queries automatically. This enables you to run SQL queries against databases without a local SQL client. You can intuitively view the query results in tables or charts and easily check the query logs.

## Use cases

The recommended use cases of SQL Editor are as follows:

- Utilize the AI capabilities of Chat2Query to generate, debug, or rewrite complex SQL queries instantly.
- Quickly test the MySQL compatibility of TiDB.
- Easily explore the SQL features in TiDB using your own datasets.

## Limitations

- SQL queries generated by the AI might not be 100% accurate, and you might need to refine them.
- SQL Editor is only supported for TiDB clusters that are v6.5.0 or later and hosted on AWS.
- SQL Editor is available only for [TiDB Cloud Starter](/tidb-cloud/select-cluster-tier.md#starter) clusters hosted on AWS. To use SQL Editor and Chat2Query on [TiDB Cloud Dedicated](/tidb-cloud/select-cluster-tier.md#tidb-cloud-dedicated) clusters, contact [TiDB Cloud support](/tidb-cloud/tidb-cloud-support.md).

## Access SQL Editor

1. Go to the [**Clusters**](https://tidbcloud.com/project/clusters) page of your project.

    > **Tip:**
    >
    > You can use the combo box in the upper-left corner to switch between organizations, projects, and clusters.

2. Click your cluster name, and then click **SQL Editor** in the left navigation pane.

    > **Note:**
    >
    > In the following cases, the **SQL Editor** entry is displayed in gray and not clickable.
    >
    > - Your TiDB Cloud Dedicated cluster is earlier than v6.5.0. To use SQL Editor, you need to contract [TiDB Cloud support](/tidb-cloud/tidb-cloud-support.md) to upgrade your clusters.
    > - Your TiDB Cloud Dedicated cluster is just created and the running environment for SQL Editor is still in preparation. In this case, wait for a few minutes and Chat2Query will be available.
    > - Your TiDB Cloud Dedicated cluster is [paused](/tidb-cloud/pause-or-resume-tidb-cluster.md).

## Enable or disable AI to generate SQL queries

PingCAP takes the privacy and security of users' data as a top priority. The AI capacity of Chat2Query in SQL Editor only needs to access database schemas to generate SQL queries, not your data itself. For more information, see [Chat2Query Privacy FAQ](https://www.pingcap.com/privacy-policy/privacy-chat2query).

When you access Chat2Query for the first time, you will be prompted with a dialog about whether to allow PingCAP and Amazon Bedrock to use your code snippets to research and improve the services.

- To enable the AI to generate SQL queries, select the checkbox and click **Save and Get Started**.
- To disable the AI to generate SQL queries, close this dialog directly.

After the first-time access, you can still change the AI setting as follows:

- To enable AI, click **Enable AI power for data exploration** in the upper-right corner of Chat2Query.
- To disable AI, click <MDSvgIcon name="icon-top-account-settings" /> in the lower-left corner of the [TiDB Cloud console](https://tidbcloud.com/), click **Account Settings**, click the **AI & Privacy** tab, and then disable the **AI-powered Data Exploration** option.

## Write and run SQL queries

In SQL Editor, you can write and run SQL queries using your own dataset.

1. Write SQL queries.

    <SimpleTab>
    <div label="macOS">

    For macOS:

    - If AI is enabled, simply press **⌘ + I** followed by your instructions and press **Enter** to let AI generate SQL queries automatically.

        For a SQL query generated by Chat2Query, click **Accept** to accept the query and continue editing. If the query does not meet your requirements, click **Discard** to reject it. Alternatively, click **Regenerate** to request a new query from Chat2Query.

    - If AI is disabled, write SQL queries manually.

    </div>

    <div label="Windows/Linux">

    For Windows or Linux:

    - If AI is enabled, simply press **Ctrl + I** followed by your instructions and press **Enter** to let AI generate SQL queries automatically.

        For a SQL query generated by Chat2Query, click **Accept** to accept the query and continue editing. If the query does not meet your requirements, click **Discard** to reject it. Alternatively, click **Regenerate** to request a new query from Chat2Query.

    - If AI is disabled, write SQL queries manually.

    </div>
    </SimpleTab>

2. Run SQL queries.

    <SimpleTab>
    <div label="macOS">

    For macOS:

    - If you have only one query in the editor, to run it, press **⌘ + Enter** or click <svg width="1rem" height="1rem" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M6.70001 20.7756C6.01949 20.3926 6.00029 19.5259 6.00034 19.0422L6.00034 12.1205L6 5.33028C6 4.75247 6.00052 3.92317 6.38613 3.44138C6.83044 2.88625 7.62614 2.98501 7.95335 3.05489C8.05144 3.07584 8.14194 3.12086 8.22438 3.17798L19.2865 10.8426C19.2955 10.8489 19.304 10.8549 19.3126 10.8617C19.4069 10.9362 20 11.4314 20 12.1205C20 12.7913 19.438 13.2784 19.3212 13.3725C19.307 13.3839 19.2983 13.3902 19.2831 13.4002C18.8096 13.7133 8.57995 20.4771 8.10002 20.7756C7.60871 21.0812 7.22013 21.0683 6.70001 20.7756Z" fill="currentColor"></path></svg>**Run**.

    - If you have multiple queries in the editor, to run one or several of them sequentially, select the lines of the target queries with your cursor, and then press **⌘ + Enter** or click **Run**.

    - To run all queries in the editor sequentially, press **⇧ + ⌘ + Enter**, or select the lines of all queries with your cursor and click **Run**.

    </div>

    <div label="Windows/Linux">

    For Windows or Linux:

    - If you have only one query in the editor, to run it, press **Ctrl + Enter** or click <svg width="1rem" height="1rem" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M6.70001 20.7756C6.01949 20.3926 6.00029 19.5259 6.00034 19.0422L6.00034 12.1205L6 5.33028C6 4.75247 6.00052 3.92317 6.38613 3.44138C6.83044 2.88625 7.62614 2.98501 7.95335 3.05489C8.05144 3.07584 8.14194 3.12086 8.22438 3.17798L19.2865 10.8426C19.2955 10.8489 19.304 10.8549 19.3126 10.8617C19.4069 10.9362 20 11.4314 20 12.1205C20 12.7913 19.438 13.2784 19.3212 13.3725C19.307 13.3839 19.2983 13.3902 19.2831 13.4002C18.8096 13.7133 8.57995 20.4771 8.10002 20.7756C7.60871 21.0812 7.22013 21.0683 6.70001 20.7756Z" fill="currentColor"></path></svg>**Run**.

    - If you have multiple queries in the editor, to run one or several of them sequentially, select the lines of the target queries with your cursor, and then press **Ctrl + Enter** or click **Run**.

    - To run all queries in the editor sequentially, press **Shift + Ctrl + Enter**, or select the lines of all queries with your cursor and click **Run**.

    </div>
    </SimpleTab>

After running the queries, you can see the query logs and results immediately at the bottom of the page.

> **Note:**
>
> The returned result has a size limit of 8 MiB.

## Rewrite SQL queries using Chat2Query

In SQL Editor, you can use Chat2Query to rewrite existing SQL queries to optimize performance, fix errors, or meet other specific requirements.

1. Select the lines of SQL queries you want to rewrite with your cursor.

2. Invoke Chat2Query for rewriting by using the keyboard shortcut for your operating system:

    - <kbd>⌘</kbd> + <kbd>I</kbd> on macOS
    - <kbd>Control</kbd> + <kbd>I</kbd> on Windows or Linux

    Press **Enter** after providing your instructions to let AI handle the rewrite.

3. After invoking Chat2Query, you can see the suggested rewrite and the following options:

    - **Accept**: click this to accept the suggested rewrite and continue editing.
    - **Discard**: click this if the suggested rewrite does not meet your expectations.
    - **Regenerate**: click this to request another rewrite from Chat2Query based on your feedback or additional instructions.

> **Note:**
> 
> Chat2Query uses AI algorithms to suggest optimizations and corrections. It is recommended that you review these suggestions carefully before finalizing the queries.

## Manage SQL files

In SQL Editor, you can save your SQL queries in different SQL files and manage SQL files as follows:

- To add a SQL file, click **+** on the **SQL Files** tab.
- To rename a SQL file, move your cursor on the filename, click **...** next to the filename, and then select **Rename**.
- To delete a SQL file, move your cursor on the filename, click **...** next to the filename, and then select **Delete**. Note that when there is only one SQL file on the **SQL Files** tab, you cannot delete it.

## Access Chat2Query via API

In addition to accessing Chat2Query via UI, you can also access Chat2Query via API. To do so, you need to create a Chat2Query Data App first.

In Chat2Query, you can access or create a Chat2Query Data App as follows:

1. Click **...** in the upper-right corner, and then click **Access Chat2Query via API**.
2. In the displayed dialog, do one of the following:

    - To create a new Chat2Query Data App, click **New Chat2Query Data App**.
    - To access an existing Chat2Query Data App, click the name of target Data App.

For more information, see [Get started with Chat2Query API](/tidb-cloud/use-chat2query-api.md).

## Generate an endpoint from a SQL file

For TiDB clusters, TiDB Cloud provides a [Data Service (beta)](/tidb-cloud/data-service-overview.md) feature that enables you to access TiDB Cloud data via an HTTPS request using a custom API endpoint. In SQL Editor, you can generate an endpoint of Data Service (beta) from a SQL file by taking the following steps:

1. Move your cursor on the filename, click **...** next to the filename, and then select **Generate endpoint**.
2. In the **Generate endpoint** dialog box, select the Data App you want to generate the endpoint for and enter the endpoint name.
3. Click **Generate**. The endpoint is generated and its details page is displayed.

For more information, see [Manage an endpoint](/tidb-cloud/data-service-manage-endpoint.md).

## Manage SQL Editor settings

In SQL Editor, you can change the following settings:

- The maximum number of rows in query results
- Whether to show system database schemas on the **Schemas** tab

To change the settings, take the following steps:

1. In the upper-right corner of **SQL Editor**, click **...** and select **Settings**.
2. Change the settings according to your need.
3. Click **Save**.