This is a user-friendly open-source tool that allows you to create, search, and edit SQLite database files. It provides a familiar spreadsheet-like interface and supports full SQL query functionality. It is compatible with various operating systems, including Windows, macOS, Linux, and Unix. Documentation for the program is available on a wiki. Key features of DB Browser for SQLite: creation and compaction of database files, table management including creation, definition, modification, and deletion, index management including creation and deletion, record handling such as viewing, editing, adding, and deleting, sorting and searching records, importing and exporting data in text format, importing and exporting tables to/from CSV files, importing and exporting databases to/from SQL dump files, executing SQL queries and viewing results, viewing a log of all SQL commands issued by the application, and building simple charts based on table or query data. Overall, DB Browser for SQLite is a convenient and functional tool for working with SQLite databases, suitable for both beginners and advanced users.
×
❮
❯