sqlitebrowser

Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

What is sqlitebrowser?

Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

Overview of sqlitebrowser

What it is

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It uses a familiar spreadsheet-like interface, so complicated SQL commands do not have to be learned. Controls and wizards are available for users to perform various database operations.

Key features

  • Create and compact database files - Create, define, modify, and delete tables and indexes - Browse, edit, add, delete, and search records - Import and export records as text, tables from/to CSV files, and 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

Use cases

  • Creating and editing SQLite database files for personal or project use - Browsing, searching, and modifying records without writing SQL - Importing data from CSV or SQL dump files into a database - Exporting database tables or entire databases to CSV or SQL dump - Running ad-hoc SQL queries and viewing results - Visualizing data through simple graphs

Getting started

Installation commands for some platforms (see the repository README for full instructions): bash # Windows (using Chocolatey) choco install sqlitebrowser # macOS (using Homebrew Cask) brew install --cask db-browser-for-sqlite # Ubuntu (using PPA) sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser sudo apt-get update sudo apt-get install sqlitebrowser # Snap (cross-platform) snap install sqlitebrowser

License and pricing

The license is not stated in the repository metadata (NOASSERTION). The software is open source and free to use.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/sqlitebrowsersqlitebrowser.svg)](https://yunodb.com/tools/sqlitebrowsersqlitebrowser?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/sqlitebrowsersqlitebrowser?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/sqlitebrowsersqlitebrowser.svg" alt="Featured on YunoDB" height="20"></a>