TrustRadius: an HG Insights company

Sequel Pro

Score9 out of 10

33 Reviews and Ratings

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

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

Free, powerful and easy to use database management tool

Pros

  • Searching and filtering
  • Connections over SSH
  • Raw SQL when you need it
  • Database and table management
  • User management, credentials and roles

Cons

  • Some queries can be slow and fail to stop
  • Support for different types of database structures like SQLite or NoSQL would be awesome

Return on Investment

  • It's free. You really can't go wrong there.

Alternatives Considered

PhpMyAdmin, DB Browser, Base, MySQL Workbench and Querious