Help Center/ Relational Database Service_RDS for MariaDB/ FAQs/ Database Usage/ How Do I Use DAS to Query SQL Statements?
Updated on 2025-06-24 GMT+08:00

How Do I Use DAS to Query SQL Statements?

DAS is a professional database management tool with a visual interface. You can enable SQL Explorer to query related SQL statements.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, locate the DB instance and click Log In in the Operation column.
  5. On the displayed login page, enter the correct username and password and click Log In.
  6. In the navigation pane, choose Cloud DBA (Intelligent O&M) to go to the Instance Overview page.
  7. Locate the instance you want to view and click Details.
  8. Choose SQL > SQL Explorer to view full SQL details of the instance.
  9. On the SQL Statements tab page, click Enable DAS SQL Explorer. Query the SQL statements executed by the current instance by time range, user, keyword, operation type, or database.

    Figure 1 Enabling SQL Explorer

  10. Filter operation types by referring to Table 1 and click Export to export the corresponding SQL statements.

    Table 1 Common SQL statement types

    Type

    Keyword

    DDL

    CREATE, DROP, ALTER

    DML

    INSERT, UPDATE, DELETE, SELECT

    DCL

    GRANT, REVOKE

    A maximum of 10,000 SQL statements can be displayed. If you need to view more, click Export.

    Up to 100,000 records can be exported.