data

SQLite Explorer

Search across SQLite databases and inspect record relationships, cell contents, database health, and read-only SQL in the browser.

View on GitHub

Local processing

About your filesFiles and content selected in this tool are processed in your browser and are not uploaded to a Browser Kitty backend.

Operation demo See the basic workflow in a short video.

About this tool

SQLite Explorer is a read-only tool for quickly understanding an unfamiliar SQLite database. In addition to database-level metadata, it can browse tables and views, search values across the database, inspect individual cells, and trace related records from one place.

Defined foreign keys and inferred relationships can be explored in the ER diagram, with Focus Mode narrowing the view to nearby tables. Database Health combines quick_check, foreign_key_check, and structural review signals, while the SQL view supports read-only queries and EXPLAIN QUERY PLAN.

Good for

Find a known value across an SQLite database even when you do not know the table name
Quickly identify JSON, dates, URLs, UUIDs, Base64 candidates, image BLOBs, and other cell content
Investigate an unfamiliar database safely with relationships, ER views, health checks, and read-only SQL

What it can do

Key capabilities available in this tool.

Database-wide search and Data Explorer
Smart Cell Inspector and record relationships
ER diagram, relationship inference, and profiling
Database Health and read-only SQL

How to use

Drop or choose a SQLite database file.
Use Overview to inspect tables, views, indexes, rows, table sizes, and Database Health.
When you only know a value, use database-wide search to locate the relevant table and record.
In Data Explorer, filter, sort, configure visible columns, then use Smart Cell Inspector and record relationships from cells or rows.
Use the ER diagram, Focus Mode, column profiles, read-only SQL, query plans, and CSV/JSON export as needed.

Supported

Input: standard SQLite files such as .db, .sqlite, and .sqlite3.
Exploration: database-wide search, tables/views, row filtering, column sorting, visibility controls, and resizable columns.
Analysis: Smart Cell Inspector, image BLOB preview, Record Relationships, ER diagram / Focus Mode, column profiles, and Database Health.
SQL / export: SELECT, WITH, EXPLAIN, and allowlisted read-only PRAGMAs; save tables or query results as CSV/JSON.

Limitations and notes

Version 1.1.0 is read-only and blocks write statements such as INSERT, UPDATE, DELETE, and CREATE.
Inferred relationships and Smart Cell Inspector type detection are exploration aids and do not guarantee the semantic meaning of data.
For very large databases, database-wide search and profiling are limited by browser memory and device performance.
There is no feature to write changes back to the source SQLite file.

Frequently asked questions

Is my SQLite file uploaded?

No. Loading, database-wide search, analysis, SQL execution, and export run in the browser; the database is not uploaded to Browser Kitty.

Can I find a value without knowing the table name?

Yes. Database-wide search can look across text and numeric columns and take you to matching tables and records.

Can I inspect BLOBs and JSON values?

Smart Cell Inspector detects JSON, dates, URLs, UUIDs, Base64 candidates, BLOBs, and more. Supported PNG, JPEG, GIF, and WebP BLOBs can be previewed in place.

Can I edit the database?

No. It is intentionally read-only for safer inspection of unfamiliar databases, and write statements are blocked.

Offline version and source code

The root-level sqlite-explorer.html on GitHub is an expanded single HTML file with sql.js bundled inside. You can download and open it directly in a browser while keeping SQLite inspection local and read-only.

View source on GitHub