Data file
What is a .db file?
A .db file is a database — often SQLite — used by an app to store its data locally. It's for the program, not for reading by hand.
This extension has been used by more than one format
7 different formats have claimed .db over the years, so two files with the same extension aren't necessarily the same kind of thing.
How to open a .db file
- WindowsDB Browser for SQLite (free)
- WindowsThe app that created it
- MacDB Browser for SQLite
- MacTablePlus
- Linux`sqlite3 file.db`
How to convert a .db file
- Export tables to .csv from DB Browser if you want them in a spreadsheet.
MIME type
When a .db file travels over the web, servers label it with one of these MIME types:
application/vnd.microsoft.windows.thumbnail-cacheapplication/x-sqlite3The technical record
For archivists, developers and the merely curious: these are the PRONOM registry entries for .db.
| Format name | Version | MIME type | PUID |
|---|---|---|---|
| Paradox Database Table | 7 | — | x-fmt/147 |
| Paradox Database Table | 3.0 | — | fmt/350 |
| Paradox Database Table | 4.0 | — | fmt/351 |
| Paradox Database Table | 5.0 | — | fmt/352 |
| Thumbs DB file | XP | application/vnd.microsoft.windows.thumbnail-cache | fmt/682 |
| SQLite Database File Format | 3 | application/x-sqlite3 | fmt/729 |
| SQLite Database File Format | 2 | — | fmt/1135 |