SQLite frontend for OS X?

Solution 1:

DB Browser for SQLite

DB Browser for SQLite 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.

Solution 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)

Solution 3:

You may like my app SQLPro for SQLite (App Store).

Some of the neat features it includes are:

Syntax highlighting & Autocomplete (sometimes called intellisense).
Customizable themes allowing the query editor to be completely customized.
The ability to run multiple queries at one time (and a customizable run query shortcut).
Primary key detection in the query results. When primary keys are detected you can update results & delete rows directly from the grid.
Errors in queries will be underlined.

SQLPro for SQLite screenshot 1

There is a full schema designer. SQLPro for SQLite allows you to add/update/delete:

Tables
Indexes
Foreign Keys and
Triggers

Column designer Foreign key designer In addition:

Tables can be imported & exported from/as CSV, XML or JSON.
A query history browser so that you may see queries run in the past.
Favourite queries can be stored and reused.
The results grid can be searched (either via the Cmd - F keyboard shortcut or by right clicking the results grid and choosing find).

There is a seven day trial available via the website. If you purchase via our webstore, use the promo code STACK25 to save 25%.

Disclaimer: I'm the developer.

Solution 4:

SQLite Manager Firefox Add-on

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

Solution 5:

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.