What is a DB3 file?

.db3 is the file extension associated with the relational database management system (RDBMS) SQLite, a popular choice for embedded database. SQLite also uses other extensions including .sqlite, .db, .db4

How to open DB3 file?

So a file with .db3 extension is an SQLite database file. To open and edit it, you need an SQLite client. For users on Mac and Windows, you can use TablePlus app. It’s a native, lightweight SQL client that allows you to manage your SQLite database.

TablePlus is free to download for macOS here, and Windows here.

If you need a quick edit on the go, Download TablePlus for iOS.

To open a DB3 file:

  • Launch TablePlus
  • From the welcome screen, choose Create a new connection…
  • Select SQLite from the driver list and click Continue
  • Enter the path to the db3 file on your computer, or click Select file… to navigate to the file location.
  • Click Connect to open the SQLite database.

New connection

How to edit DB3 file?

That’s now you’re connected to the SQLite database, you can make any changes you want via the GUI.

Edit data inline with the grid view.

Edit inline

And to work with table structure.

Edit structure

Open anything to quickly find and open any searchable database objects: database, table, view, function, etc. It uses fuzzy matching so you don’t even have to remember the exact name.

Open Anything

Advanced filters to save you a lot of time writing complex queries with lots of conditions.

Filters

Safemode & Code preview. Every change will be pending for review until you actually commit it to the server, or you can choose to discard the changes.

Code review

Or query and edit data using the Query Editor with these built-in features:

  • Instant autocomplete
  • Highlight syntax
  • Query beautifier
  • Favourite & history
  • Async loading and streaming results that get you to see the results faster.

Query Editor