View Web SQL data

This article shows how to use DevTools to inspect Web SQL data.

Warning

The Web SQL specification is not being maintained.

View Web SQL Data

  1. In DevTools, open the Application tool. The Manifest pane usually opens by default.

    The Manifest pane.

  2. Expand the Web SQL section to view databases and tables. In the following figure, below html5meetup is a database and rooms is a table.

    The Web SQL pane.

  3. Click a table to view the data for that table.

View the data of a Web SQL table.

Edit Web SQL data

You can't edit Web SQL data when viewing a Web SQL table, such as in the previous figure. But you can run statements from the Web SQL Console that edit or delete tables. See Run Web SQL queries.

Run Web SQL queries

  1. Click a database to open a console for that database.

  2. Type a Web SQL statement, then press Enter to run it.

Use the Web SQL Console to delete a row from a table.

Refresh a Web SQL table

DevTools doesn't update tables in real-time. To update the data in a table:

  1. View the data in a Web SQL table.

  2. Click Refresh (Refresh.).

Filter out columns in a Web SQL table

  1. View the data in a Web SQL table.

  2. Use the Visible columns text box to specify what columns you want to show. Provide the column names as a CSV list.

    Use the Visible Columns text box to reduce the number of columns shown.

Delete all Web SQL data

  1. Open the Clear Storage pane.

  2. Make sure that the Web SQL checkbox is turned on.

    The Web SQL checkbox.

  3. Click Clear site data.

    The Clear Site Data button.

Note

Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons Attribution 4.0 International License. The original page is found here and is authored by Kayce Basques (Technical Writer, Chrome DevTools & Lighthouse).

Creative Commons License. This work is licensed under a Creative Commons Attribution 4.0 International License.