Since DevEco Studio 6.0.2 Beta1, the Database Inspector has been added, allowing you to execute SQL statements directly in DevEco Studio to view and modify your app database. This eliminates the need to export the database locally, improving development and debugging efficiency. It currently supports SQLite and vector databases.
You can also debug databases using the CLI. For detailed instructions, see vector-store Database Debugging Tool Guide and SQLite Debugging Tool.

The functions of each area on the Database Inspector page are as follows: ① device selection; ② app package name selection; ③ database and table information display; ④ SQL execution and data viewing.

Depending on the device's API version, the Database Inspector shows different database paths: for those earlier than API version 22, the database is downloaded to the local computer and its path is displayed; for API version 22 and later, the path shown is the one to the database on the device.

Since version 26.0.0, visual editing of table data is supported (limited to basic data types: strings, numbers, booleans, and more; binary data types are not supported). Double-click a cell, enter data, and press Enter or click another area to submit the changes.

After modifying data, click Refresh Table below the SQL input box to refresh the data on the page.
