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.
v0.9 [Apr 22, 2010]
New Features
Add support for naming relations
Support fullscreen in Mac OS X 10.7 Lion
Add support for abbreviated MySQL timezone definitions
Sequel Pro has the OS X Lion Application Category of “Developer Tools”. (Convenient when sorting by Application Category in Finder.app and when creating folders in LaunchPad.app)
Up-to-date German and Russian translations, including Russian translation of the credits file
Support regex within the table filter list to match tables, falling back to plain text matching; thanks to Emma Persky for the original patch
Lion compatibility improvements
Update tab colours under 10.7 to match system styles
Fix issues dragging tabs out of windows and into other tab bars
Fix QuickLook issues under 10.7, including windows which couldn't be closed, fullscreened, and crashes
Use overlay scrollers where possible
Fix Bundle Editor Group names not showing up in Lion
Fix crashes when custom query errors occur when running multiple queries on Lion
Usability Tweaks
New Index sheet improvements
SSH reconnection dialog defaults to NO if SSH key not recognised
Tweaks to export window's Filename field
Add option to the Export window for including AUTOINCREMENT values, defaulting to off
Disable the 'include drop syntax option' when the structure option is not enabled in the Export Window
Prevent error bell when using the enter key to initiate a connection when keyboard focus is on the favourites outline view
Don't initiate a connection when the currently selected favourite is clicked again slowly
Increase speed of connection by combining initial version check/timezone check/encoding check.
Improve connection timeout handling to significantly improve connection stability on certain servers
When moving a field in the structure view, only use the default value if it actually has one
Improve editable row checks in views and custom query results to make more results editable
Fixes sorting of integer time values in server process list
Prevent undo from working across tabs, keeping undo within the current tab
UI Tweaks
Visual tweaks to Connection Error Dialog & New Index Sheet
(Localisation) Foreign Key tweaks for localised languages.
(Localisation) Duplicate DB Sheet
Fix layout issues of main window (including issue with connect screen)
Bug Fixes
Fix startup encoding detection when connection to servers with an init_connection option set, fixing errors viewing tables and display of NULLs for data
Various New Index Sheet fixes
Fix an issue when cancelling the User Manager
Fix exceptions editing non-unique-keyed views or custom query results containing some types of binary data
Correctly use the user-specified NULL string in the CSV exporter
Use the CLIENT_INTERACTIVE mode for MySQL connections to improve timeout behaviour
Fix an issue when removing the only content filter
Crashes when using “Use monospaced fonts” or “Display vertical grid lines” preferences after closing at least one window
Fix crashes on cancelling the CSV import field mapper
Fix issues with autocomplete behaviour
Fix exceptions in the bundle controller when using tab switching keys
(Regression) Re-add default new table's id field to AUTO_INCREMENT
Misc
Add Sparkle to credits
Various code base tidy ups and fixes
Attempt to fix SSH master use
