DB Browser for SQLite – Free, open-source and cross-platform SQLite viewer & editor

This article along with all titles and tags are the original content of AppNee. All rights reserved. To repost or reproduce, you must add an explicit footnote along with the URL to this article!
Any manual or automated whole-website collecting/crawling behaviors are strictly prohibited.
Any resources shared on AppNee are limited to personal study and research only, any form of commercial behaviors are strictly prohibited. Otherwise, you may receive a variety of copyright complaints and have to deal with them by yourself.
Before using (especially downloading) any resources shared by AppNee, please first go to read our F.A.Q. page more or less. Otherwise, please bear all the consequences by yourself.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

DB Browser for SQLite (formerly called SQLite Database Browser and Database Browser for SQLite, DB4S for short) is a free, open-source and cross-platform (Windows/Linux/Mac) SQLite database visual viewer and editor, originally developed by Mauricio Piacentini from Brazil.

As a lightweight and foolprool database editor, DB Browser for SQLite allows user to efficiently view, create, edit, and operate SQLite database files in a simple, intuitive way. But its most important feature is to use the tabular database creation and editing mode. That’s to say, you can easily utilize this tool for various database editing operations even if you didn’t learn about the SQL statements. For example, create a new database, open an existing database, check the database structure (including tables, indexes, views, triggers, etc.), browse and edit table data (including SQL query, modification, inserting new data, deleting data, etc.), export database as CSV or SQL format of file.

For software developers, DB Browser for SQLite enables you to directly open, browse and edit SQLite format of database files on Windows, without having to install any special database development software, or connect to the database in the IDE first. BTW, the common extension name of SQLite database file includes: .db, .db3 and .s3db. But in fact, as long as the content of any file is stored in the text format of SQLite, then its extension name can be arbitrary actually. However, to open them in the DB Browser for SQLite, you need to manually change its extension name to any supported format first.

// Key Features //

  • Create and compact database files
  • Create, define, modify and delete tables
  • Create, define and delete indexes
  • Browse, edit, add and delete records
  • Search records
  • Import and export records as text
  • Import and export tables from/to CSV files
  • Import and export databases from/to SQL dump files
  • Issue SQL queries and inspect the results
  • Examine a log of all SQL commands issued by the application
  • Plot simple graphs based on table or query data

// Download URLs //

License Version Stable Releases Nightly Builds
Freeware Latest

(Homepage | GitHub)

If some download link is missing, and you do need it, just please send an email (along with post link and missing link) to remind us to reupload the missing file for you. And, give us some time to respond.
If there is a password for an archive, it should be "appnee.com".
Most of the reserved downloads (including the 32-bit version) can be requested to reupload via email.