Skip to main content

AI dialogue

NineData offers AI dialogue (intelligent SQL) capabilities that can quickly convert natural language expressions into SQL queries. This document will guide you through how to use intelligent SQL.

Functionality​

  • Natural Language Query: Advanced semantic parsing technology allows for understanding of query intent, which can be transformed into the correct SQL query statement, 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 Operations: Supports multiple operations, including insert, delete, update, and select.
  • Automatic Database Structure Recognition: Can automatically recognize the database structure and table names you want to query, reducing the possibility of input errors and query time. You only need to select the target database in the data source.
  • Efficient Data Processing: Supports large-scale data processing and efficient queries, and can handle large datasets containing millions of rows of data. In addition, Intelligent SQL also provides the function to help you optimize SQL statements quickly and efficiently for better data querying and processing.

Limitations​

  • After closing the AI dialogue box, the chat history will be cleared. Please manually save any useful information before closing the AI or browser window.

  • 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

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. They need to query data to make business decisions, but lack the professional skills to handle data.
  • Large amount of data: When the amount of data that needs to be processed is very large, manual SQL query writing becomes difficult and time-consuming, and slow SQL may also threaten server performance. Intelligent SQL can help users quickly write complex query statements and optimize them according to their needs. While quickly finding the required information, it avoids 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, and conditional aggregation, intelligent SQL can help users quickly generate query statements and return correct results.

Steps​

  1. Log in to the NineData Console.

  2. Click > on the left navigation bar.

  3. Depending on your previous operations on the SQL console, the situation may be different:

    • If you have previously logged in to the data source and have not closed it, you will be automatically directed to the data source page. In this case, click the + on the SQL console tab on the right, select the target test data source in the page, and click to open a new SQL console.
    • If you have never logged in to the data source or have completely closed the data source, click the checkbox below , and the data sources you have added will pop up. Select the targeta source, and click to jump to the SQL console.

  4. Click on the right side of the SQL console, select the name of the library you want to operate on in the pop-up window, and then click .

    tip

    For Redis data sources, simply click on without selecting a database.

  5. Enter the content you want to query in the text box, and press Enter or click the send icon on the right side of the text box to send it. AI will analyze your request and make the corresponding response.

    tip

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

      • For database-related content: automatically generate corresponding SQL statements and execute them. You can expand with , compress with , copy with , or manually generate statements and run them with . The execution results of the statements can be viewed in the area at the bottom of the page.

      • For database-related content: answer various questions for you.

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

:::

Last updated on