Data Copilot (New)

DMS Data Copilot builds prompts from metadata. Due to model limitations, Copilot samples only a portion of metadata (tables and fields) in large databases, which may reduce accuracy.

Copilot performs better on smaller databases.

Prerequisites

• Enable security hosting for the instance.

• You have query permissions on the required database. View Your Permissions.

Procedure

1. Log in to DMS 5.0.

2. Move the pointer over the icon in the upper-left corner of the DMS console and choose All Features > SQL Console > SQL Console.

   Note

   If you use the DMS console in normal mode, choose SQL Console > SQL Console in the top navigation bar.

3. In the Please select the database first dialog box, enter a keyword to search for a database, select the database instance from the search results, and then click Confirm.

4. Click

   Copilot searches all tables in the current database.

Generate SQL

-- Find which city Xiao Ming bought a phone in, and display the phone model.
SELECT
  city,
  item_id AS phone_model
FROM
  orders_test
WHERE
  buyer_name = 'Xiao Ming'
  AND item_id LIKE '%phone%';

NL2SQL

NL2SQL provides thinking templates that show how Copilot generates SQL. Add or edit templates in the knowledge base to improve query accuracy and interpretability.

Example of an AI thought process:

For example, ask In which city did Xiao Hong buy a phone?. The AI identifies associated tables, analyzes the query by measure, dimension, and summary, then generates the SQL.

Database and table Q&A

This feature uses Meta Agent to help you explore and understand data assets in Data Copilot.

For example, enter Introduce this database. Copilot displays the database name, table count, column details, comments, common SQL templates, and predicted usage scenarios.

SQL Repair

When an SQL statement returns an error, use SQL Repair. Copilot analyzes the error and provides a corrected SQL statement.

SQL Result Set Analysis

You can further filter data based on the SQL result set.

SQL Autocompletion

Enter partial keywords to receive SQL completion suggestions. You can also select a code template for autocompletion.

Report Recommendation

After executing a SELECT statement, click Chart on the left side of the result area to visualize the data. You can also:

• Download: Click Download Image in the upper-right corner of the chart.

• Switch chart type: Click Change in the upper-right corner. Selecting a recommended chart clears the current configuration.

• Apply the chart to a dashboard.