Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
There is a similar questions on StackOverflow here. You might find some additional answers. – a blue marker Jan 9 '13 at 13:29
up vote 10 down vote accepted

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.

share|improve this answer
I'll second this. I use it and it works as advertised, plus it's free. – user479 Jun 5 '11 at 22:14
The project has moved to GitHub -- the new link is – Gordon Davisson May 17 '15 at 19:09
@GordonDavisson Thanks, I will update the link – nuc May 18 '15 at 20:40

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

share|improve this answer
Facepalm. It took me an hour of searching to find out it was already installed on my machine. – Rob van der Veer Jul 31 '13 at 12:25

SQLPro for SQLite 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.
share|improve this answer
Please have a look at the faq, especially the part about self-promotion. As there is no "best" tool for everybody, could you also add a list of unique features your tool has? – patrix Apr 22 '13 at 13:14
This is a good software, but having just one query window is somewhat limiting... I need different query window for the same db. – Prakash Nadar Feb 28 at 4:26

SQLite Manager Firefox Add-on

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

share|improve this answer
It seems that everything is integrated into Firefox these days. That's a really weird use of a browser, IMO. Completely different from something such as phpSqLite. – Jason Salaz Jun 6 '11 at 7:45
It's free! And I find it is better SQLite Database browser in providing copy/edit usability, colour for readability, and sidebars for quick access. The only downside that it has from SQLite Database browser is that it requires Firefox. – James Feb 12 '14 at 19:46

There are also the Navicat brand of SQL editors, including Navicat for SQLite, which are available in the Mac App Store (

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

share|improve this answer

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.

share|improve this answer

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.

share|improve this answer

You can try Valentina Studio 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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.