Skip to main content

AI Conversation

NineData offers AI Conversation (Intelligent SQL) functionality, which allows you to quickly convert natural language expressions into SQL query statements. This document will guide you on how to use Intelligent SQL.

Feature Description​

  • Natural Language Query: Utilizing advanced semantic parsing technology, it can understand your query intentions and translate them into the correct SQL query statements, thereby improving query efficiency and accuracy. You only need to input your query requests in natural language, without the need to be familiar with SQL language.
  • Multiple Operation Methods: Supports a variety of operations, including add, delete, modify, and query.
  • Database Structure Automatic Recognition: It can automatically recognize the database structure and table names you want to query, without the need for manual input, thus reducing the possibility of input errors and query time. You just need to select the target database in the data source.
  • Efficient Data Processing: Supports large-scale data processing and efficient queries, capable of handling large datasets containing millions of rows of data. At the same time, Intelligent SQL also provides functionality, helping you quickly optimize SQL statements, thus more efficiently querying and processing data.

Use Cases​

  • Users without SQL programming experience: Intelligent SQL can help users without SQL programming experience to query and analyze data. These users may be business personnel, marketing personnel, customer service representatives, etc., who need to query data to make business decisions, but do not have professional skills to handle data.

  • Large data volume: When the amount of data to be processed is very large, manually writing SQL query statements becomes difficult and time-consuming, and slow SQL that may occur is also threatening the performance of the server. Intelligent SQL can help users quickly write complex query statements and optimize them according to needs, while quickly finding the required information and avoiding the occurrence of slow SQL.

  • Complex queries: For those who need to perform complex queries, Intelligent SQL can provide more efficient and accurate query results. For example, when performing complex queries such as multi-table joins, nested queries, conditional aggregation, etc., Intelligent SQL can help users quickly generate query statements and return the correct results.

Prerequisites​

  • The type of data source used must be one of the following: MySQL, SQL Server, PostgreSQL, TiDB, openGauss, GreatSQL, ClickHouse, Doris, SelectDB, StarRocks, SingleStore.

  • In the commercial versions (, ), please ensure that your monthly/yearly subscription is not expired, as it may result in the inability to use the Database DevOpsservice. You can quickly check the remaining quota and expiration date at the top right corner of the NineData console page.

    check_quota

Notes​

After the AI conversation box is closed, the chat records will be cleared. Please manually save useful information before closing the AI or browser window.

Operation Steps​

  1. Log in to the NineData Console.

  2. Click on in the left navigation bar.

  3. Depending on your previous operations on the SQL Console, the situation will be different:

    • If you have previously logged in to the data source and have not closed it, you will automatically enter the data source page. In this case, click the + on the right side of the SQL Console tab, in the page, click the checkbox, select the target test data source, and click to open a new SQL Console.

    • If you have not logged in to the data source before or have completely closed the data source, click the checkbox below , and a list of data sources you have added will pop up. Select the target data source and click to jump to the SQL Console.

  4. Click the ai icon on the right side of the SQL Console, and in the pop-up window, select the database name you need to operate on, then click .

  5. Enter the content you want to query in the text box, press the ↵ key or click the send icon on the right side of the text box to send. AI will analyze your needs and respond accordingly.

    tip

    • AI will automatically determine your intentions based on the text you enter and provide feedback:

      • Database operation related content: Automatically generate the corresponding SQL statements and execute them. You can , , , manually the generated statements. The execution results of the statements can be viewed in the area at the bottom of the page.

      • Non-database operation content: Answer your various questions.

    • Click the in the upper right corner of the dialog box to clear the current chat records with AI.

Last updated on