View Web SQL data with Microsoft Edge DevTools

Warning

The Web SQL specification is not being maintained.

This guide shows you how to use Microsoft Edge DevTools to inspect Web SQL data.

View Web SQL Data

  1. Choose the Sources tool to open the Sources 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. Choose a table to view the data for that table.

    View the data of a Web SQL table

Edit Web SQL data

You are not able to edit Web SQL data when viewing a Web SQL table, such as in previous above. But you may run statements from the Web SQL Console that edit or delete tables. Navigate to Run Web SQL queries.

Run Web SQL queries

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

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

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

Refresh a Web SQL table

DevTools does not update tables in real-time. To update the data in a table, complete the following actions.

  1. View the data in a Web SQL table.
  2. Choose 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. Choose Clear site data.

    The Clear Site Data button

Getting in touch with the Microsoft Edge DevTools team

Use the following options to discuss the new features and changes in the post, or anything else related to DevTools.

  • Send your feedback using the Send Feedback icon or select Alt+Shift+I (Windows, Linux) or Option+Shift+I (macOS) in DevTools.
  • Tweet at @EdgeDevTools.
  • Submit a suggestion to The Web We Want.
  • To file bugs about this article, use the following Feedback section.

The Send Feedback icon in the Microsoft Edge DevTools

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.