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

SQLite database file format

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
.schema

Sources: 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.

Sources: SQLite write-ahead logging and companion files

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.