With this free app you can create and edit SQlite databases

DB Browser for SQLite (64-bit)

DB Browser for SQLite (64-bit)

  -  18.9 MB  -  Open Source
DB Browser for SQLite (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 for SQLite 64 bit 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 a 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.

This program is not a visual shell for the SQLite command-line tool and does not require familiarity with SQL commands. It is a tool to be used by both developers and end-users and must remain as simple to use as possible in order to achieve these goals.

Also Available: DB Browser for SQLite (32-bit), Download DB Browser SQLite for Mac and DB Browser for SQLite Portable

  • DB Browser for SQLite 3.13.0 (64-bit) Screenshots

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

    DB Browser for SQLite 3.13.0 (64-bit) Screenshot 1
  • DB Browser for SQLite 3.13.0 (64-bit) Screenshot 2
  • DB Browser for SQLite 3.13.0 (64-bit) Screenshot 3

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