SQLite frontend for OS X?

Question

I am looking for a preferably free SQLite frontend to use under OS X.

Something similar to MySQL Workbench will do. Put separate suggestions in separate answers.

Answer 1

SQLite Database Browser

SQLite Database browser is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.

Answer 2

It's a far cry from the other graphical tools mentioned here, but I've found that I prefer interacting with my SQLite databases with the built-in command line tool, sqlite3:

$ sqlite3 test.db
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table test (a, b);
sqlite> insert into test values (2, 3);
sqlite> insert into test values (4, 3);
sqlite> insert into test values (4, 5);
sqlite> select * from test where a<b;
2|3
4|5
sqlite> .schema
CREATE TABLE test (a, b);

The best part is that it's built into Mac OS X and is completely, 100% free. (No seriously, the code is in the public domain)

Answer 3

SQLite Manager Firefox Add-on

Not native OS X app, but it will do the work!

Answer 4

Base ($32.99 USD / £19.99)

Native OSX app for interacting with SQLite databases. Base isn't free, but I've found it to be useful. You can buy it through the Mac App Store.

Answer 5

SQLite Professional is another SQLLite editor for OS X. It is no longer free, however if you follow the instructions here, you can get a free promo code.

Features Include:

• Version integration. Mucked your database? Rollback to a previous version.
• Automatic reloading if the database gets modified outside of the app.
• Column reordering.
• Export (or import) data with csv, mysql, xml or json.
• Backwards compatibility with SQLite 2.
• Fullscreen support.
• Inline filters allowing you to customize the way your data is displayed.
• Semiautomatic dependency resolution.

Answer 6

There are also the Navicat brand of SQL editors, including Navicat for SQLite, which are available in the Mac App Store (http://itunes.apple.com/us/app/navicat-for-sqlite/id424161923?mt=12).

I've not used their SQLite tool, but have used their MySQL product, and found it to work well for most tasks.

Answer 7

Navicat SQLite ($49/$99)

Navicat for SQLite is a powerful Database administration and development tool for SQLite. It works with SQLite version 2 and 3 and supports most of the SQLite features including Trigger, Index, View, and so on.

It's a good product but IMHO expensive.

Answer 8

You can try Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of SQLite, as well as, MySQL, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.