Sequel Pro: Everything you need in a Mac MySQL interface
March 08, 2017
Sequel Pro: Everything you need in a Mac MySQL interface
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Sequel Pro
Sequel Pro is almost indispensable in our organization. It strikes the perfect balance of intuitive UX and powerful capabilities. We use it internally to query from several databases containing ad-performance data. It is useful for everything from simple exploratory data work to query optimization for BI visualization tools. Sequel Pro's ability to view/create/change database structure and relations make dealing with API or data structure changes a breeze.
- A favorite Sequel Pro feature is the UI for Table/Database creation. APIs and data structures change often so having an intuitive way to make quick updates is a lifesaver.
- Sequel Pro makes it easy to manage and connect to multiple databases with tabbed windows. It's great to have multiple databases open with their specific queries stored and ready to go.
- As the database admin for my team I also value the ability to manage users and database privileges. As our teams change in size or different clients and applications need access I can easily create and provision credentials.
- Wish it could handle more database types. As of now it can't connect to disparate datasources.
- Wish it could autoformat.
- Error messages aren't typically verbose enough to really debug a query without resorting to EXPLAIN queries.
- Simplifies Ad-Hoc reporting requiring less analyst hours for quick turn around tasks.
- Helped tune database for B.I. application speed.
- Reduced reliance on bad visual query builders on some B.I. visualization tools.
Amazingly full-featured for a free MySQL client. Met all the requirements for our team. Free & for Mac OS X.