Open and browse SQLite database files in Chrome

SQLite Explorer opens a database file in a browser tab, lists its tables and lets you filter, sort and export rows without writing SQL.

• Left panel with every table and its row count, plus views
• Grid with a filter box under each column and sorting by clicking the header
• Foreign key values work as links to the row they point to
• Read-only SQL console: run a query with Ctrl+Enter and stop a long one
• CSV export of filtered rows, a whole table or a query result
• Schema tab with CREATE statements, indexes and triggers, plus a diagram of declared relations

1. Open the explorer from its toolbar icon, or with Alt+Shift+D; it gets a tab of its own.
2. Drop your .db, .sqlite3 or .db3 file on that tab, or pick it with Open file. If you want a trial run first, the start screen offers a sample database. While a file loads, you see a real percentage, and if it cannot be read, a message tells you why.
3. Choose what to look at from the sidebar, which lists the tables, each with its row count, and the views.
4. Type into the box under a column name to filter, and click a header to sort. Long text, JSON and BLOB values open in a row panel, where JSON is formatted and a BLOB can be shown in hex or saved as a file.
5. Click a foreign key value to jump to the row it points to.

• Read-only: you can view and export data, but not edit it.
• Encrypted databases (SQLCipher, SEE) cannot be opened.
• Files larger than 1 GB are not supported.
• Reads SQLite files only; MySQL or PostgreSQL servers and .sql dumps are out of scope.
• Foreign key links and diagram lines appear only for relations declared in the file.
• When the database is in WAL mode, the explorer warns you that recent changes may be missing.

Does not read or change any web page on its own.

storage

Keeps the draft of your SQL console query and the state of the rating question; file names, paths and database contents are not stored.

• How to see a table's schema in SQLite (the DESCRIBE equivalent)

  SQLite has no DESCRIBE. Use .schema for the CREATE statement or PRAGMA table_info for the columns, and see what each one leaves out.

  Oct 17, 2026 · 7 min read
• How to list all tables in a SQLite database

  List the tables in a SQLite database with .tables, a sqlite_schema query, PRAGMA table_list or Python, and see why each method returns a different list.

  Oct 17, 2026 · 7 min read
• How to export a SQLite table or query to CSV and Excel

  Export a SQLite table or query to CSV with one sqlite3 command, open it in Excel with .excel, and avoid the 300-character cut we saw in SQLite 3.53 and 3.54.

  Oct 17, 2026 · 7 min read
• What is a .db file, and how do you open one?

  A .db file is often a SQLite database, but not always. How to check yours, open it on Windows, Mac or in Chrome, and what to do if it is encrypted.

  Oct 17, 2026 · 7 min read