DB Browser for SQLite
lastmod 2024-07-11created 2017-01-123 edits
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
Features
- A high-quality, visual, open-source tool designed for people who want to create, search, and edit SQLite database files
- DB Browser for SQLite (DB4S) provides a familiar spreadsheet-like interface for databases, along with full SQL query capability
- Works on Windows, macOS, and most versions of Linux and Unix
- DB4S gives access to the full functionality of the underlying SQLite database
- Create and compact database files
- Create, define, modify, and delete tables
- Create, define, and delete indexes
- Browse, edit, add, and delete records
- Sort and search records
- Import and export records as text
- Import and export tables as CSV files
- Import and export databases as SQL dump files
- Issue SQL queries and inspect the results
- Inspect a log of all SQL commands issued by the application
- Plot simple graphs based on table or query data
GN⁺'s summary
- DB Browser for SQLite is a useful tool for managing SQLite databases visually
- Offers a wide range of features, making it easy to create, modify, and manage database files
- Being open source, anyone can use it for free, and it runs on various operating systems
- Will be useful for developers and data analysts who need to manage databases
- Tools with similar features include DBeaver and SQLiteStudio