With this free app you can create and edit SQlite databases

DB Browser SQLite for Mac

DB Browser SQLite for Mac

  -  43.4 MB  -  Open Source
DB Browser SQLite for Mac (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases. Database Browser SQLite for macOS uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned.

Controls and wizards are available for users to:
  • 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
This program was developed originally by Mauricio Piacentini from Tabuleiro Producoes, as the Arca Database Browser. The original version was used as a free companion tool to the Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions to handle compressed and binary data.

Also Available: Download DB Browser for SQLite for Windows

  • DB Browser for SQLite 3.13.0 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    DB Browser for SQLite 3.13.0 Screenshot 1

What's new in this version:

Highlights on user-visible changes:
SQLite update and improved support:
- SQLite version updated to 3.46.0 in Windows binary distributions

SQLCipher updated to versions:
- macOS and Windows: version 4.6.0 (based on SQLite 3.45.3)
- Linux AppImage: version 3.4.1 (based on SQLite 3.15.2)
- Support for the STRICT tables
- Support for the RETURNING
- Support for the new math functions
- Support for IS (NOT) DISTINCT FROM expressions
- Attach database by URI