Sequel Pro

Sequel Pro is an application that allows Mac users to conveniently manage their MySQL databases. The utility has a modern interface design and offers a wide range of features for both experienced as well as novice SQL developers.

You can connect to either remote or local databases via standard, socket or SSH protocols. The application is distributed under an open-source license, making it completely free.

Once connected to a database, Sequel Pro provides simple and convenient access to its structure, content, relations between the tables and associated information. The application makes it easy to create queries; this is due to SQL syntax highlighting as well as code completion features for keywords, tables and field names. If you find yourself using the same query multiple times, simply mark it as a favorite and reuse it without typing the code again.

With Sequel Pro, users can export MySQL databases to SQL and CSV formats. The utility supports the addition of bundles (plugins) that may further extend Sequel Pro's functionality.

All in all, the application offers a powerful alternative to standard database managers (such as PHPMyAdmin). It works for both local and remote connections, and supports the latest MySQL versions (5.5). Even more so, it is free to use which should make it even more appealing. The utility lacks the ability to synchronize between two databases from different locations (local or remote); it can however import both SQL and CSV types of files.