FILE FORMAT GUIDE
SQLite File: Open a Database Read-Only
A SQLite file stores a database that can contain tables, indexes and other schema objects. Use a SQLite-aware application to browse it. For inspection, choose read-only access and obtain a consistent copy rather than editing a live application database.
Quick facts
- Extension
- .sqlite
- Format
- SQLite Database
- Category
- data
- MIME type
- application/vnd.sqlite3
- Standard / developer
- SQLite
- Open with
- DB Browser for SQLite
What is SQLITE?
SQLite defines a binary, page-based database format. A .db name can refer to SQLite or another database type, so this guide does not treat every .db file as SQLite. Journal or WAL files may also be needed to represent the current database state.
How to open SQLITE
Obtain a consistent copy with the originating application. A read-only viewer does not make an incomplete copy current or recover missing WAL transactions.
DB Browser for SQLiteWindows / macOS / Linux
Choose Open Database Read Only for a consistent copy, then browse its schema and tables.
Common uses and compatibility
- Browse tables and schema in a SQLite-aware desktop application.
- Move selected table data through CSV import or export workflows.
Things to check
- A WAL can contain committed data not yet in the main file. Do not discard it or copy an active database file in isolation.
- Encrypted extensions and newer SQL features may require the originating application or a compatible SQLite implementation.
Advanced inspection
These developer and command-line workflows inspect structure or metadata. They are not the default way most people open the file.
SQLite shellCommand line; sqlite3 required
Use sqlite3 -readonly "example.sqlite", then .tables or .schema to inspect structure without requesting writes.
Technical details
- Signature
- SQLite 3: 53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00 at offset 0
- Encoding
- Unknown
- Container
- Page-based SQLite database with a database header and schema records
- Compression
- Unknown
Browse without changing the original
In DB Browser for SQLite, choose Open Database Read Only and select a consistent copy. Browse the schema and data before deciding whether an export is needed. Read-only inspection does not decrypt an encrypted database.
Sources: DB Browser for SQLite · DB Browser Open Database Read Only action — official source · application/vnd.sqlite3 — IANA
Inspect tables with the SQLite shell
The sqlite3 shell supports read-only opening and schema commands. Check the path carefully; an ordinary writable open can create an empty database when the named file does not exist.
Open read-only, then list tables and schema
sqlite3 -readonly "example.sqlite"
.tables
.schemaSources: SQLite command-line shell
What should I do with -wal and -shm files?
Keep the database and its associated files together. Obtain a backup or consistent export from the application that owns the database instead of deleting companion files to make a viewer open it. WAL-mode read-only access has additional file and permission requirements.
Why does a file named .db fail to open?
The name alone does not identify its database format. Verify the creator, encryption requirements and format before choosing another application. A missing plain SQLite header does not justify rewriting or repairing the original file.
Sources: SQLite database file format · application/vnd.sqlite3 — IANA
Related formats
- Comma-Separated Values
Export selected table data as CSV when a spreadsheet or importer needs rows rather than a complete database.
- JavaScript Object Notation
JSON is a separate data-exchange representation and does not preserve an entire database schema by renaming.
Sources & review
Sources reviewed 2026-11-15.