Best database admin software for mac?

Question

What's the best database admin software for OSX?

• maintain database schema and data
• run queries
• convert schema from one database type to another
• datapump to move data around
• schema diff tools, ideally able build a script to update a schema
• easy to use

Databases I'm interested in are

• MSSQL
• PostgreSQL
• MySQL
• Firebird
• (SQLite)

Prefer one tool for all the databases, rather than one for each database.

Answer 1

For MySql, use http://www.sequelpro.com/ (foss) or http://www.araelium.com/querious/ (paid)

Answer 2

I use Aqua Data studio 6 at work on a daily basis, with SQL Server, Sybase IQ and Netezza. It's convenient not having to switch tools all the time. It also has a handy SQL prettier that helps keep my blood pressure low when people send me mangled SQL to look at. Netezza is unsupported but works fine with generic ODBC/JDBC.

While it is a java app the only time I really run into problems is when I run a query that returns to many rows (over 100k). You can set the limits and or play with memory but every once in a while I shoot myself in the foot and bang on my keyboard.

I run windows but linux and mac are also supported.

Nice just noticed that version 7 has built in pivot tables. That will save me from cutting and pasting datasets to excel!

Answer 3

I've used SQuirreL SQL in the past. It's written in Java, so it works on any platform with a decent JVM and any database with a decent JDBC driver. I think it'll do most, if not all of what you are asking for.

Answer 4

For just postgres, pgAdmin3 has gotten better in the last few releases and works fine in OS X. I've also used SQuirrel, which works on jdbc compliant db's, but it's been a while.

Answer 5

For MySQL, you could try:

1. MySQL Admin
2. PHP Mysql Admin (if you don't mind installing a PHP web app)
3. Oracle's SQLDeveloper (works with MySQL also with a little bit of config)