Sequel Pro Information Reviews & Insights

Score9 out of 10

33 Reviews and Ratings

Community insights

TrustRadius Insights for Sequel Pro are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Business Problems Solved

Sequel Pro has become an indispensable tool for our engineering department, allowing us to design, investigate, query, and manage databases on a daily basis. The intuitive user interface and powerful capabilities of Sequel Pro have made it our MySQL client of choice for administering databases. It effectively solves the business problem of providing a GUI-based client for managing and administering MySQL databases, which is preferred over terminal or web-based solutions.

Developers widely use Sequel Pro for accessing MySQL and alternatives like MariaDB, providing a more efficient and convenient way to perform basic to advanced tasks and queries. It simplifies database maintenance by making it easier to correct data errors in MySQL tables. We rely on Sequel Pro for querying data from test QA databases and testing certain elements when creating new features, ensuring data accuracy and correctness. Additionally, it serves as a versatile tool for building reports, queries, and basic SQL Server management across our engineering and product departments.

Sequel Pro acts as a database IDE, allowing us to create, update, delete, and view table schemas, contributing to robust and secure software development. The software is widely used as a database management interface by engineers, product managers, and other stakeholders who need easy access to peek into databases and view tables and database schemas. Users also rely on Sequel Pro for data analysis. By pulling custom data sets, they gain insights on products, customers, sales, and more. Furthermore, the marketing department uses the software to connect to the cloud database built on our Magento eCommerce platform and write custom SQL syntax. Overall, Sequel Pro has proven to be an essential tool that enhances productivity and efficiency in managing databases.

Sequel Pro Reviews

6 Reviews

InformationComputer Software2Internet3Telecommunications1

Simple and Fast

Rating: 9 out of 10

Incentivized

October 22, 2019

Use Cases and Deployment Scope

Sequel Pro is used by the engineering department on daily basis to design, investigate, query and manage our DBs, local and remote.

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.

Likelihood to Recommend

Super easy for quick development and investigation
The interface of exporting tables to SQL can be made better, it's not easy to manually check
Not suitable for designing your DB
Connections over SSH to vagrant and Docker hosted DBs
Auto suggestion can be better

Ilyas Bakouch

Cloud Solutions Architect in Engineering at Productions TMV Inc. (Internet, 1001-5000 employees)

Vetted Review

4 years of experience

View profile

Extremely unreliable SQL program that would be great if it just worked

Rating: 4 out of 10

Incentivized

July 18, 2019

Use Cases and Deployment Scope

Sequel Pro is used to query data from our system. This is usually limited to our test QA databases. It's also used to test certain elements when creating new features to ensure that data is being created correctly in the appropriate tables. It is used across our engineering and product departments today.

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.

Likelihood to Recommend

Honestly, if Sequel Pro was more reliable it'd be a great tool for our needs. It does everything we need it to do in regards to querying a single database, seeing the data schema, modifying test data, etc. The fact is that it isn't. The constant crashing is a HUGE problem. It makes simple tasks take much longer and it is extremely frustrating. I can't even report the crash because the crash reporting tool crashes every time you try to send the report. LITERALLY EVERY TIME. I can't wait until we find a new, more reliable tool.

Jake Schlingman

Product Manager in Product Management at AppFolio, Inc. (Computer Software, 1001-5000 employees)

Vetted Review

2 years of experience

View profile

Sequel Pro - best MySQL data editor available

Rating: 10 out of 10

Incentivized

September 18, 2018

Use Cases and Deployment Scope

Sequel Pro is used in my department for database maintenance. It greatly simplifies the task of correcting data errors in MySQL tables.

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.

Likelihood to Recommend

When an existing MySQL table needs to be examined or edited, Sequel Pro excels. In the circumstance where a new table needs to be created, I believe phpMyAdmin might offer slightly better interface.

Dan Mahoney

Member of Technical Staff at Global Eagle Entertainment (formerly Row 44, Inc.) (Telecommunications, 1001-5000 employees)

Vetted Review

5 years of experience

View profile

The best tool I've used for MySQL management

Rating: 10 out of 10

Incentivized

August 24, 2018

Use Cases and Deployment Scope

I use Sequel Pro on a daily basis and it helps me to better manage and organize our project databases, without needing to use a browser based solution like phpMyAdmin. We use it in both local, staging and production environments.

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!

Likelihood to Recommend

It's my definitive solution for managing local and remote databases, and it's the best tool I've ever used for MySQL administration. I've literally learned how to use Sequel Pro in a matter of minutes. We develop a lot of Wordpress websites and it works just fine. Maybe it’s not that appropriate for large scale applications, since it can suffer from the performance viewpoint.

Carlos Eduardo de Souza

Co-founder & Manager in Information Technology at Coopers Digital Production (Internet, 1-10 employees)

Vetted Review

2 years of experience

View profile

Great Database Navigator!

Rating: 9 out of 10

Incentivized

June 15, 2017

Use Cases and Deployment Scope

Sequel Pro is used as a database management interface at our company. It's used widely across engineering, and it's a good access point for engineers, product managers, etc. It is a versatile tool for peeking into databases and being able to view the tables and db schema from a top down prospective. Makes it easy for both technical and less technical people all the same.

Pros

Easy to understand interface
Very versatile; it is powerful to both the beginner, and the expert
It makes it easy to navigate across various databases on different servers

Cons

There's not much missing, the tool is pretty complete
There could be an easier way to setup ssh tunnels that require using different keys
It would be cool if the console was more customizable

Likelihood to Recommend

It's really good for when you want to take a look at the overall db schema from a top down view. Everything is laid out in a tree structure that allows you to see the tables and how they're put together. You can also edit rows really easily without typing out update statements.

Verified User

Engineer in Engineering (Computer Software company, 501-1000 employees)

Vetted Review

3 years of experience

Sequel Pro is the first thing you should install if you're administering a MySQL server on a Mac

Rating: 9 out of 10

Incentivized

February 15, 2017

Use Cases and Deployment Scope

Sequel Pro is my MySQL client of choice. I use it on my Macbook and it is used to administer my databases, both locally and on our servers via an SSH tunnel. The main business problem it solves is to provide a GUI-based client for managing and administration of MySQL databases.

Pros

Very easy to do backups and restore of MySQL databases using their SQL export function. The function also compresses the output so you can create a .gz file. Multiple formats of export are supported, including CSV and SQL.
Connecting to remote databases using SSH tunnels works great with Sequel Pro. It automatically establishes the SSH tunnel to the correct port and logs you in seamlessly.
Seeing all currently running queries and all processes on the server is easy with Sequel Pro. It also allows you an auto-refresh option so you can constantly monitor the queries coming in. This is very useful when diagnosing MySQL query bottlenecks for web application databases.

Cons

I don't see a way in Sequel Pro to easily see and monitor MySQL's MyISAM keybuffer usage and InnoDB's buffer pool usage.
The tool currently doesn't help you optimize your MySQL configuration variables. It would be very useful to be able to keep the client open for monitoring a DB server for a long time and then based on query usage, the tool could provide you with optimum variable settings for your server.
The Query window that lets you write a SQL query by hand is not particularly smart. It doesn't autocomplete your queries or show you any syntax help or suggestions. When you try to run a bad query, you simply get back the error that MySQL would throw -- Sequel Pro will not help you debug the query.

Likelihood to Recommend

Sequel Pro is a great client for MySQL databases used for web applications. If you do development on your local machine, and your local machine is on Mac OS, installing Sequel Pro is a no-brainer first choice. Once you get used to it, you can even use it for administration of server-side databases.
Where I would not recommend using Sequel Pro would be for architecture-level configuration or setting up the structure for new databases. Their interface is not particularly helpful for configuring DB server variables or scanning through server-side logs.

Anand Chhatpar

CTO in Engineering at Growth Champ, a service by Fame Express LLC (Internet, 1-10 employees)

Vetted Review

3 years of experience

View profile

Loading Reviews List....

Sequel Pro is the first thing you should install if you're administering a MySQL server on a Mac

Rating: 9 out of 10

Incentivized

February 15, 2017

Use Cases and Deployment Scope

Pros

Very easy to do backups and restore of MySQL databases using their SQL export function. The function also compresses the output so you can create a .gz file. Multiple formats of export are supported, including CSV and SQL.
Connecting to remote databases using SSH tunnels works great with Sequel Pro. It automatically establishes the SSH tunnel to the correct port and logs you in seamlessly.
Seeing all currently running queries and all processes on the server is easy with Sequel Pro. It also allows you an auto-refresh option so you can constantly monitor the queries coming in. This is very useful when diagnosing MySQL query bottlenecks for web application databases.

Cons

I don't see a way in Sequel Pro to easily see and monitor MySQL's MyISAM keybuffer usage and InnoDB's buffer pool usage.
The tool currently doesn't help you optimize your MySQL configuration variables. It would be very useful to be able to keep the client open for monitoring a DB server for a long time and then based on query usage, the tool could provide you with optimum variable settings for your server.
The Query window that lets you write a SQL query by hand is not particularly smart. It doesn't autocomplete your queries or show you any syntax help or suggestions. When you try to run a bad query, you simply get back the error that MySQL would throw -- Sequel Pro will not help you debug the query.

Likelihood to Recommend

Anand Chhatpar

CTO in Engineering at Growth Champ, a service by Fame Express LLC (Internet, 1-10 employees)

Vetted Review

3 years of experience

View profile