All Products
Search

This Product

    Data Management:Data Copilot

    Document Center

    Data Management:Data Copilot

    Last Updated:Aug 28, 2026

    DMS Data Copilot is an AI-powered data assistant built on DMS and the Alibaba Cloud LLM. It combines DMS data management with natural language to help you query, analyze, and manage data efficiently.

    Important Notes

    • Data Copilot is currently in public preview. Model resources are free during the public preview.

    • Copilot requires instance metadata (not actual data) to generate accurate answers. Enable security hosting for the instance.

    • Copilot supports Qwen-Plus, Qwen-Coder, Qwen-A22, and Qwen-Max model resources.

    Limits

    • 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.

    • Data Copilot analyzes table and column names and comments to understand databases. Standardized naming and comprehensive comments improve result accuracy.

    Use Copilot in the SQL Window

    Prerequisites

    • The instance's control mode is Security Collaboration.

    • 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 2023-01-28_15-57-17.png 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.

    Copilot Feature Demo

    Generate SQL

    Generate SQL from inline comments

    Enter a comment in SQL Console and press Enter to trigger the intelligent miniapp, which generates an SQL statement.

    Note

    • The comment format is: two hyphens (-), followed by a space and natural language (which can include text and symbols).

    • Press Tab to accept the generated SQL statement.

    Generate SQL in the Copilot Dialog Box

    1. Enter natural language queries.

      1. Copilot selects tables needed to answer your question based on table comments and associations.

      2. When Copilot identifies tables with high confidence, it automatically generates SQL.

        Note

        If the selected tables do not meet your needs, manually adjust tables to add appropriate ones.

    2. Optional: View table details.

      In the associated tables area, click View to see table data, database, row count, permissions, columns, and indexes.

    3. Copilot generates SQL.

      • If the SQL is correct, copy it to SQL Console or Notebook to execute.

      • If the SQL needs changes, provide feedback. Copilot revises the SQL and extracts implicit business knowledge from your feedback.

    SQL Result Set Analysis

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

    Manage Similar SQL

    Copilot references historical queries to generate SQL. The Agent uses only verified knowledge.

    • Generate alternate queries

      Click the Like button in the lower-right corner to save the query. Copilot references saved queries to improve SQL generation for similar future questions.

    • Delete saved queries

      Double-click a table name to open Table Details, then delete the query from the History tab.

    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.

    Related Operations

    • Use Data Q&A Agent

      After configuring Copilot with data queries, knowledge base entries, and NL2SQL tuning, use Q&A Agent to let product managers, operations staff, and other stakeholders query data through natural language without writing SQL.

    • Building ChatBI with Dify and NL2SQL

      Dify on DMS and NL2SQL provides a ChatBI solution. Ask a question in natural language, and DMS converts it to SQL, executes the query, and displays results as visualization charts.

    • Edit the knowledge base

      In the SQL window, click My SQL > Knowledge Base, then click Edit next to the target entry.

      Knowledge base entries help Copilot understand context, answer questions, and make automated decisions.

    FAQ

    Q: Why should I like the SQL generated by Copilot?

    A: Liking saves the SQL query, which improves Copilot's accuracy for similar future questions.