Home·File extensions

.db

Data · application/vnd.sqlite3

Opens with

DB Browser for SQLiteDBeaver

Tables and records. These are what you use to move values between programs.

MIME typeapplication/vnd.sqlite3
CategoryData
Opens in a browserNo
Plain textNo
Registered typeYes

The same file, another name

These share a MIME type. Renaming between them usually just works.

How to read this

  • An extension is a label, not the contents. Rename a file to .png and if the bytes inside are JPEG, it is still a JPEG.
  • A MIME type is how the internet names a file kind. Browsers look at that value, not the extension, to decide whether to display or download.
  • A MIME type starting with x- was never registered as a standard. Plenty are in wide use, but they are not official names.
  • Video extensions name a container. The same .mp4 may play on one device and not another, depending on the codec inside.

Frequently asked questions

Q. What is a .db file?

It belongs to the data category and its MIME type is application/vnd.sqlite3. The contents are binary, so opening it in a text editor shows garbage.

Q. What opens a .db file?

DB Browser for SQLite, DBeaver all handle it. In a browser it does not display — the browser downloads it instead.

Q. What is the MIME type of .db?

application/vnd.sqlite3. The first half, application, names the broad kind; the second half, vnd.sqlite3, names the exact format. It is a registered standard name.

Q. Is any other extension the same format as .db?

.sqlite share the very same MIME type. Renaming between them usually just works.

Q. My .db file will not open.

First check that DB Browser for SQLite is installed. If it still fails, the download may have been cut short, or the file may only be named .db while holding a different format inside.

Same group