#1 most frequent
United States of America
71.4%25 installations of 35
What is Sequel Pro?
Sequel Pro is a relational database software solution offered free and open source. It allows users to access any MySQL database through a Mac.
Categories & Use Cases
Videos
Who Buys & Uses Sequel Pro
#2 most frequent
Netherlands
8.6%3 installations of 35
#3 most frequent
India
5.7%2 installations of 35
Great MySQL GUI without the bloat of many other GUIS
Use Cases and Deployment Scope
We use Sequel Pro daily to access our numerous remote MySQL databases. It has saved me a significant amount of time over the years with the easy ability to run queries, view data, import, export, and view processes. I like not having to install something like phpMyAdmin to get to the database, as this is more secure
Pros
- Import/Export.
- Process Lists.
- Search
Cons
- Design is a little dated.
- Support more database types.
- The user dialog is buggy.
Return on Investment
- Reduces the time required to manipulate a database.
- Easy imports and exports are a huge time saver.
Usability
Alternatives Considered
DataGrip
Other Software Used
DataGrip, WebStorm, IntelliJ IDEA, CLion, PhpStorm
Simple and Fast
Pros
- Table filters are simple and easy to use
- I love the ability to install plugins: Export tables to Laravel migrations is one of our most used plugins
- Super easy to connect to local Docker containers, Vagrant and remote DBs through SSH
Cons
- A feature to design the DB would be great
- NoSQL DB management
- It crashes very often and random.
Return on Investment
- Faster time to write and test queries
- Faster time to debug and investigate
- Easier learning curve for new developers
- Easier to connect to remote and local DBs
Other Software Used
Postman, Sublime Text, Microsoft Visual Studio Code, Amazon DynamoDB, Amazon Aurora, Amazon CloudFront, Amazon ElastiCache
Extremely unreliable SQL program that would be great if it just worked
Pros
- Ability to quickly connect to a variety of databases.
- Ability to see the schema and data within the tables so you don't have to go looking for it.
- Theoretically, the ability to have multiple connections open in multiple tabs at the same time (see problems section for why I say "theoretically").
- Ability to write queries and have them execute locally.
- Quickly see relations between tables and rows in tables.
Cons
- It crashes CONSTANTLY. If you have more than one connection tab open and close one of them, it crashes. If you just have it open in the background, it randomly crashes. If you're using it, it randomly crashes. When you try to send a crash report, the CRASH REPORTER CRASHES.
- Can be a bit slow.
- No way that I'm aware of to query multiple databases in the same query.
Return on Investment
- Unreliability has lead to wasted time and frustration among staff.
- The ease of testing database changes and modifying test data WHEN IT WORKS theoretically makes testing quick and easy but in reality, this is far outweighed by the wasted time and frustration involved with it not being reliable.
- The ease of seeing the relations between tables is very nice and saves time when trying to see how unfamiliar tables are connected.
Other Software Used
Snowflake, Slack, Trello, GoToMeeting, Postman, screenflow
Sequel Pro - best MySQL data editor available
Pros
- Editing existing data. Editing record contents is trivial in Sequel Pro, while not nearly as easy in MySQL Workbench or phpMyAdmin.
- Deleting data - even simpler than editing data.
- Inserting new data - using "Duplicate row" then making needed changes is very simple.
Cons
- Sequel Pro would benefit from the addition of a tool to simplify the creation of new tables.
Return on Investment
- Sequel Pro has made the process of correcting incorrect or incomplete records much faster. This allows me to operate much more efficiently.
The best tool I've used for MySQL management
Pros
- Creating new databases and managing them, like editing some specific fields and options
- Great interface; it's easy to execute functions like SQL commands that automates our workflow
- The way it imports existing databases makes everything much easier, so we just need to import ZIP or SQL files
Cons
- Improving the way we create new connections to remote databases
- I couldn't find any way to configure my local server (MySQL), so I need to make changes on server outside the application. I know that there are other tools that integrate it, so you don’t have to leave the workflow
- It could have a feature to integrate our databases or connections (favorites) with other devices, like using Google Drive or Dropbox. It would be really useful!
Return on Investment
- The user interface is great. Since all of our computers are macOS based, we can all use it and share knowledge with our colleagues
- It enables me to make things in such a faster way that it enables us to spend our time with coding and providing more solutions to our clients
- The workflow is much improved with the import and export feature, so we don't waste time with that kind of work.
Alternatives Considered
Workbench Enterprise
Other Software Used
Chrome DevTools, Google Analytics, Google Tag Manager, Apple iCloud, Apple Remote Desktop, Parallels Desktop, Skype