1776 votes
DB File - What is a .db file and how do I open it?
Learn about .DB files and view a list of programs that open them.
Languages
Overview
What is a DB file? Mobile devices, such as Android and iOS mobile phones, store a variety of information in DB database files. For example, a DB file may contain your contacts, your SMS information, or other device or application data. DB files are commonly saved in a SQLite database format, but they are also commonly locked or encrypted , so you cannot access or edit their data.
More Information One example DB file is sms.db , an iOS support file that stores your text messages. It is located in a device's /private/var/mobile/Library/SMS/ directory. Another example is consolidated.db , an iOS file that contains your tracked location information.
Document Icon
Breadcrumbs
Previous / Next
In-Depth
.DB File Extension
6 file types use the .db file extension.
Mobile Device Database
| Developer | N/A |
| Popularity |
4.0 | 1776 Votes |
What is a DB file?
Mobile devices, such as Android and iOS mobile phones, store a variety of information in DB database files. For example, a DB file may contain your contacts, your SMS information, or other device or application data. DB files are commonly saved in a SQLite database format, but they are also commonly locked or encrypted , so you cannot access or edit their data.
More Information
One example DB file is sms.db , an iOS support file that stores your text messages. It is located in a device's /private/var/mobile/Library/SMS/ directory. Another example is consolidated.db , an iOS file that contains your tracked location information.
How to open a DB file
DB files stored on a mobile device are generally not meant to be opened or edited, since they are support files used by the device or an application.
Open over 400 file formats with File Viewer Plus . Free Download
Programs that open or reference DB files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
SQLite
Free
Mac
SQLite
Free
Linux
SQLite
Free
iOS
Apple iOS
Included with OS
Android
Google Android
Included with OS
Category: Database Files
Updated: April 19, 2022
Database File
| Developer | N/A |
| Popularity |
3.9 | 690 Votes |
A DB file may also be a generic database file. It stores data in a structured format, usually comprised of a set of tables, table fields, field data types, and field values. Many applications create and use different, application-specific types of DB files.
More Information
Applications that need to store and retrieve information from structured databases often save that information in a DB file, for easy access. These files are typically not meant to be opened by users. For this reason, some DB files are encrypted .
While different applications use differently-formatted DB files, many DB files are saved in the SQLite database format (also used by .SQLITE files). In some applications, users can export the data the app's DB files contain as a .CSV file, to view the data more easily.
How to open a DB file
Many types of DB files are not meant to be opened by users. However, if your DB file is a SQLite database, you can open it and view the data it contains with SQLite Database Browser. Keep in mind that, if your DB file is encrypted, you will not be able to open it unless you know the encryption password.
Programs that open or reference DB files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Microsoft Access 365
Free Trial
LibreOffice
Free
Synopsys Design Compiler Graphical
Paid
SQLite
Free
SQLite Database Browser
Free
Aryson SQLite Database Recovery
Free Trial
Mac
SQLite
Free
SQLite Database Browser
Free
LibreOffice
Free
Linux
SQLite
Free
SQLite Database Browser
Free
LibreOffice
Free
Android
SQLite Database Editor
Free +
Category: Database Files
Updated: May 4, 2022
Windows Thumbnail Cache
| Developer | Microsoft |
| Popularity |
3.9 | 226 Votes |
Thumbs.db is a cache file used to load thumbnail images. Windows creates a Thumbs.db file in folders that contain images, so it can load thumbnails of those images more quickly. Windows shows Thumbs.db files only if you have chosen to show hidden files .
More Information
You can delete Thumbs.db files, but unless you modify Windows' settings, it will automatically recreate them. For more information about Thumbs.db files, including how to stop Windows from creating them, refer to this article .
Common DB Filenames
Thumbs.db - The default name assigned to Windows thumbnail cache files. Typically, these files are hidden.
How to open a DB file
Thumbs.db files are not meant to be opened.
Programs that open or reference DB files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Microsoft Windows
Paid
Category: Misc Files
Updated: April 19, 2022
QQ Account Database
| Developer | Tencent |
| Popularity |
3.8 | 195 Votes |
A DB file may also be an account database used by Tencent QQ, a Chinese online messaging program. It may store a user's contact list or a log of their messaging sessions. QQ files are used to store application data locally and load it without connecting to the Internet.
More Information
Tencent QQ is a popular, multiplatform messaging application that allows users to chat with and call each other. Local installs of Tencent QQ save a variety of user-specific information in DB files. In the Windows version of QQ, DB files are saved in the ~/Program Files/Tencent/QQ/Account number] directory. Some example DB files include user.db and MsgEx.db .
Common DB Filenames
user.db - Contains a user's contact list.
MsgEx.db - Contains a user's message history.
How to open a DB file
DB files used by Tencent QQ are encrypted and not meant to be opened.
Programs that open or reference DB files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Tencent QQ
Free
Mac
Tencent QQ
Free
iOS
Tencent QQ
Free
Android
Tencent QQ
Free
Category: Data Files
Updated: April 27, 2022
Skype Chat and Call History
| Developer | Skype |
| Popularity |
3.5 | 201 Votes |
A DB file used by Skype contains a user's chat and call history. This includes all the user's sent and received chat messages and the user's call details. Skype DB files may be named main.db , skype.db , or database.db .
More Information
Skype is a video call and text chat application available for Windows, macOS, Linux, and mobile devices. The application saves a record of users' chat and call history both locally and online. The local copy is stored in a DB file.
Different versions of Skype use differently-named DB files. They also store DB files in different locations. For example, later Windows 10 versions of Skype use a DB file named skype.db , which is stored in a Skype-specific subdirectory of the %localappdata%/Packages directory.
How to open a DB file
Skype DB files are SQLite databases. As such, you can open them and view the data they contain using SQLite Database Browser.
If you want to transfer your Skype chat history to another device, replace the DB file on that device with the DB file that contains the chat history you want to save. (DB files created by different versions of Skype may not be cross-compatible.)
Programs that open or reference DB files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
Microsoft Skype
Free
SQLite Database Browser
Free
NirSoft SkypeLogView
Free
Mac
Microsoft Skype
Free
SQLite Database Browser
Free
Linux
Microsoft Skype
Free
SQLite Database Browser
Free
Category: Data Files
Updated: May 3, 2022
X-Ray Engine Database
| Developer | GSC Game World |
| Popularity |
3.6 | 141 Votes |
A DB file may also be a database used by a video game developed using the X-Ray Engine, such as S.T.A.L.K.E.R.: Shadow of Chernobyl, S.T.A.L.K.E.R.: Clear Sky, and S.T.A.LK.E.R.: Call of Pripyat. It contains data used to show in-game objects and other information. DB files are similar to the GCF files used by Valve-based games.
More Information
GSC Game World used the X-Ray Engine to develop the first three games in the S.T.A.L.K.E.R. series. These games all use DB database files. Some of these files use slightly altered file extensions, such as .db0 , .db1 , .dba , .dbb , and so on.
Later games in the S.T.A.L.K.E.R. series were not developed using the X-Ray Engine. While these games also use DB files, they are not formatted the same as X-Ray Engine DB files.
How to open a DB file
Modders can use the S.T.A.L.K.E.R. Data Unpacker (Windows) to extract files from or add files to X-Ray Engine DB files.
Programs that open or reference DB files
Sort
Pricing
Program Name
Platform
Reset
X
Windows
S.T.A.L.K.E.R. Data Unpacker
Free
Category: Game Files
Updated: April 27, 2022