Tell me more ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Is there a database program for the Mac that makes it easy to import a CSV file into a table and then query and manipulate the data using ad-hoc SQL queries?

(A Windows example of a similar product would be Microsoft Access ... it also has forms and reports, which are not as important, but I would not mind a Mac solution that has those too.)

share|improve this question

3 Answers

up vote 2 down vote accepted

Base by Menial is a fantastic SQLite editor that can do what you're looking for. You can buy it from their website or from the Mac App Store.

share|improve this answer

Sequel Pro is a really nice GUI for working with MySQL databases. You can even connect to remote databases like you would connect to a server via ftp/ssh

http://www.sequelpro.com/

share|improve this answer
I use this on a daily basis. Fantastic software, plus it's FREE and the source code is available! – macaco Jan 13 '12 at 8:43

Bento by Filemaker may be able to do this.

share|improve this answer
I can't find any sign that Bento allows SQL queries ... it looks like you have to use FileMaker Pro to get that. – user4074 Apr 26 '11 at 1:17

Your Answer

 
discard

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