Easy and simple SQLite database GUI?

Question

I'm looking for a really simple GUI that interfaces with an SQLite database to facilitate editing/searching a single table, which includes:

• Editing the table in tabular format, like a spreadsheet (not requiring the extra clicks to edit individual fields)

• "live search" filtering of the table

I currently use the SQLite Manager Firefox add-on but it doesn't provide either feature.

Answer 1

SQLite Database Browser

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. 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

Download: V1.3 - or - v2.0 beta1

Answer 2

sqlite-gui is the most simplest GUI for Windows. I'm the author.

Features

• Syntax highlighting and code completion
• Edit multiple tables at the same time
• Colorized data grid
• Store an execution history and user scripts
• Export/Import data
• Database diagram
• Database comparison
• Search text in the whole database
• Quick data references
• Terminal mode
• Charts
• Query parameters
• Data generator
• SQLite extension pack

... and more

Answer 3

There is a related question on StackOverflow.

• SQLite Administrator is easy to use:

  

• SQLite Manager is a little less user-friendly, but offers a web interface:

  

• phpSQLiteAdmin is another web-interface that is relatively easy to use:

  

Answer 4

There are online tools to query SQLite databases:

• ExtendsClass: https://extendsclass.com/sqlite-browser.html This website allows to open SQLite file directly in the browser, without installation. You can open SQLite file, and view the contents of tables (just click on the name of the table).
• SQLiteOnline: https://sqliteonline.com/ It is like the previous website, it is easy to use.

Answer 5

I love DbVisualizer and Squirrel SQL -- both are great tools, and are compatible with sqlite.

Check out this page for info about DbVis's graphical table editing features.

Answer 6

Check out TablePlus, it's a native app with sleek UI that works well with SQLite.

Also, check out the simple guide to using TablePlus

Answer 7

SQLite Studio - cross platform free software (GPL license).