Have questions about images on the web? Tweet your questions to @ChromiumDev with #AskChrome and we'll answer the top questions in our next #AskChrome episode on YouTube.

View Web SQL Data With Chrome DevTools

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

View Web SQL Data

  1. Click the Sources tab to open the Sources panel. The Manifest pane usually opens by default.

    The Manifest pane.
    Figure 1. The Manifest pane.

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

    The Web SQL pane.
    Figure 2. The Web SQL pane.

  3. Click a table to view that table's data.

    Viewing the data of a Web SQL table.
    Figure 3. Viewing the data of the rooms Web SQL table.

Edit Web SQL data

You can't edit Web SQL data when viewing a Web SQL table, such as in Figure 3 above. 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.

    Using the Web SQL Console to delete a row from a table.
    Figure 4. Using the Web SQL Console to delete a row from the rooms table.

Refresh a Web SQL table

DevTools does not update tables in real-time. To update the data in a table:

  1. View a Web SQL table's data.
  2. Click Refresh Refresh.

Filter out columns in a Web SQL table

  1. View a Web SQL table's data.
  2. Use the Visible columns text box to specify what columns you want to show. Provide the column names as a CSV list.

    Using the Visible Columns text box to reduce the number of columns shown.
    Figure 5. Using the Visible Columns text box to only show the room_name and last_updated columns.

Delete all Web SQL data

  1. Open the Clear Storage pane.
  2. Make sure that the Web SQL checkbox is enabled.

    The Web SQL checkbox.
    Figure 6. The Web SQL checkbox.

  3. Click Clear site data.

    The Clear Site Data button.
    Figure 7. The Clear Site Data button.

Feedback

Was this page helpful?
Yes
What was the best thing about this page?
It helped me complete my goal(s)
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
It had the information I needed
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
It had accurate information
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
It was easy to read
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
Something else
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
No
What was the worst thing about this page?
It didn't help me complete my goal(s)
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
It was missing information I needed
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
It had inaccurate information
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
It was hard to read
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.
Something else
Thank you for the feedback. If you have specific ideas on how to improve this page, please create an issue.