What are the best MySQL GUI clients for OS X?

Database management:PostgreSQL, MySQL, Oracle, IBM DB2, SQL Server, Access, Sybase, Firebird, Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source

Top Pro

Cross-platform

Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86). See More

Top Con

Never-ending function errors

Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1). See More

MightyBarnumbirr's Experience

I am a Navicat Lite baby, that I am so accustomed to, I never bother looking for an alternative. NOT until MacOS Catalina stops me from using it, cause it is 32bit. I google for best, I first tried the SequelPro, and almost stop from searching more cause it already provided my needs.. But then decided to look one more, I came to this list and almost didn't tried at all after seeing the "unintuitive" comment of others... Well.. I normally dont bother leaving a comment for something like this... BUT, to tell honestly, If I already knew DBeaver, I might long drop Navicat Lite... You will appreciate the community behind this, definitely worth supporting the paid version... See More

Top Pro

Works for many types of databases

MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source. See More

Top Con

Requires Java

This is a pain if you don't already have Java installed. See More

DaringProphasis's Experience

It installed on Catalina. It discovered it was missing drivers and installed them with no disruption. It connected the first time to my MySQL 8 instance. It is just what I wanted. See More

Top Pro

Formatted text view

It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A. See More

Top Pro

Grouping/Pivoting and Stats

Drag and drop pivoting to quickly identify duplicates or table stats. See More

Top Pro

Follow foreign key to their primary key

If you have a table with a foreign key you can click on it to see the table row where this key references to. See More

Navicat can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc. See More

score 132 · Answer 2

Navicat for MySQL

Top Pro

Excellent choice of import/export options

Top Con

Buggy

Navicat tends to release builds that have some problems, but they usually release a patched version soon after. Also have had issues with import/export and tunneling. See More

DebonairFufluns's Experience

High cost. Not recommended See More

Top Pro

HTTP/SSH tunnel

Navicat can upload a PHP script to enable HTTP tunneling or choose a SSH tunnel instead. See More

Top Con

Still buggy, not getting better with updates

This software is way to buggy for a premium priced product. Have done many payed upgrades but I will not do a next payed upgrade. I am done with all the crashing and me losing time with this piece of software. Looking for an alternative. See More

PreciseOshunmare's Experience

Really good software See More

Top Pro

Easy to use

Navicat manages an intuitive, easy to use UI without sacrificing functionality. See More

Top Con

Cost

The cost of a license ranges from $119-$299. See More

Top Pro

Unicode support

Navicat has full unicode support. See More

Top Pro

Data and structure synchronization

Navicat can compare and synchronize your data and structure between local and remote databases. See More

Top Pro

User management

Navicat allows for simple user and access management. See More

Top Pro

Light-weighted

Top Pro

Cross-platform

Originally released on Windows, it has been ported to OS X and Linux. See More

Top Pro

SQL code completion

Navicat supports auto-complete for SQL queries. See More

Top Pro

Server monitoring

Allows you to monitor your server for inefficient queries, etc. See More

Top Pro

Batch job scheduling

Navicat can schedule things like backups, restores, data transfers or report building. See More

Top Pro

Visual query builder

Create and edit queries without writing SQL. See More

Top Pro

Visual report builder

Navicat can build reports in a visual way. Once set up, the process can be scheduled. See More

The autocomplete is amazingly fast. The UI is sleek and beautiful. I love the dark mode. The ONLY con is 2-tab restriction on free version. If your company buys it for you, then this is the one to go with. I have already recommended in my company. See More

score 68 · Answer 3

TablePlus

Top Pro

Elegant UI

Top Con

Costs money if you want more than two tabs

SociableHu's Experience

Specs

Unlike many database editors, TablePlus is simple and clean. Just enough. Think SequelPro, but for many databases. See More

Top Pro

Clean interface

tungtono's Experience

Time saving app See More

Top Pro

Powerful SQL editor

Equipped with the following features: •Highlight syntax •Indent SQL Command •Split Results into Tabs •Save favorite SQL to snippet •Customize font size See More

DebonairFufluns's Experience

Great!!. 100% recomended. Price just See More

Top Pro

It's fast

CreativeVirbius's Experience

the best See More

Top Pro

Native Mac application

High performance. See More

Top Pro

Native, beautiful and friendly

TablePlus is a native app which helps you easily edit database data and structure. See More

Top Pro

Multi-tabs & code review

TablePlus supports multi-tab and multi-window viewing, as well as generates code review whenever you make a change to your database. See More

Top Pro

Customizable appearance

TablePlus' smartly designed interface not only gives you powerful functions, but also allows you to personalize your database workspace by changing themes and font sizes. Our shortcut keys also help you work faster and be more efficient. See More

Crashes when working with mysql 8.0.12 for macos 10.13. Unable to do anything. See More

score 279 · Answer 4

Sequel Pro

Top Con

Crashes constantly

Top Pro

Great UI

Clean, easy to use, highly polished interface. See More

CulturedTangotango's Experience

does not work on MySQL 8.0 See More

Top Con

Not maintained

The app crashes when you close a tab. See More

Top Pro

Native OS X from the start

Unlike other solutions, Sequel Pro was built specifically for OS X and for MySQL from the beginning and as such the design takes better advantage of OS X features and is optimized for MySQL. See More

ProfessionalGwynApNudd's Experience

doesn't work in Mojave See More

Top Con

No MySQL 8 support

Top Pro

Free and open source

Licensed under MIT. See More

PhilosophicalHelernus's Experience

Print and import crashes See More

Top Con

Not adapted for MacOS Catalina

Top Pro

Multiple connection methods

Sequel Pro can choose between standard and SSH connection methods. See More

PerceptivePerkunas's Experience

project abandoned See More

Top Con

No multiple query tabs

Sequel Pro does not support multiple query tabs in its editor. This is incredibly frustrating for a power user. See More

Top Pro

Multiple import/export options

Sequel Pro can export to SQL, CSV and XML files and import SQL and CSV files. See More

ResponsibleMoneta's Experience

very cool See More

Top Con

Text in the query lost on connection failure & crashes

Top Pro

Command line access

Sequel Pro can also access and manage everything from the command line. See More

ExceptionalManyu's Experience

Crashes all the time See More

Top Con

OS X only, no Linux or Windows versions

Power users have to manage in many different environments. A consistent admin interface is hugely beneficial. See More

Top Pro

Excellent user management

Has easy user privilege management. See More

PatientMushmahhu's Experience

Limited use. See More

Top Con

Query editing capabilities much poorer than MySql Workbench, Querious, and others

Top Pro

Highly flexible filters

Sequel Pro has highly flexible and customizable filters. See More

SharpBuchis's Experience

Can't change data import delimiter options are completely ignored making tab separated import impossible, last nightly build was: 8 months, 5 days ago. See More

Top Con

No visual query editor

CourageousMixcoatl's Experience

crash, cannot be used for mysql 8.0.16 See More

Top Con

Unable to import from binary SQL files

I frequently import binary multipolygon data from another source, and it won’t open. See More

OrganizedChaac's Experience

I'm not seeing any efforts to fix the crashing on Mac. It's terrible See More

FlexibleXolotl's Experience

crashes a lot See More

JollyAglaophonos's Experience

works fine on mojave, https://twitter.com/chko/status/1064690419663986688 See More

GregariousMokoi's Experience

The app crashes when you close a tab. See More

HarmoniousXochiquetzal's Experience

Bad See More

EnthusiasticPuschkayts's Experience

Doesn't support modern password encryption. "'caching_sha2_password' cannot be loaded" See More

LogicalUoke's Experience

Elegantly simple, clean and sensible UI for streamlined productivity. See More

DaringProphasis's Experience

I never even got connected to my database. The program crashed when connecting - no error. On Catalina. See More

LoveableInanna's Experience

Crashes frequently. Memory leaks cause it to grind to a halt after minutes. The current version has been the current version since 2016! It used to be better but has not kept up with OS updates and is now a mess. See More

PerseveringAlala's Experience

does not work well with macos mojave and higher See More

CulturedNamtar's Experience

Opened the app, connected to a database server, selected a database, unknown exception. End of story. See More

SpiritedEmpusa's Experience

Was my app of choice for MySQL and would happily pay, but unfortunately the lack of updates makes this app unusable as crashes consistently. See More

ConscientiousArgestes's Experience

Has not been updated since 2016, Not compatible with MacOS Mojave 10.14 See More

CharmingXipeTotec's Experience

I can't work with sequel pro using mysql 8. It just keeps crashing. See More

It crashes regularly, making any productive work impossible. See More

score 58 · Answer 5

MySQL Workbench

Top Con

Terrible performance on Mac OS

Top Pro

Community version

There is a community edition available that is free and open source; licensed under GPL. See More

ExcellentHapi's Experience

Gets worse with every new release of OS X, crashes constantly. See More

Specs

Crashes constantly. Interface lags horribly when scrolling through code, and then characters get jumbled on the screen. See More

Top Con

Terribly buggy

Top Pro

Has a free and open source version

Community edition is free and open source; licensed under GPL. See More

AffableQuangeio's Experience

It doesnot support Trigger See More

Top Con

Unintuitive UI

Workbench's user interface is regarded by a lot of users as unintuitive and hard to use. It seems cluttered and hard to get used to. The left side of the application has several sections (which you get to choose which to open) with several tools for each. A lot of features are hidden behind menus and need some getting used to find them. See More

Top Pro

Cross-platform

Works on Windows, Linux, OS X. See More

BrilliantPoena's Experience

crashes repeatedly, doesn't support all functions See More

Top Con

Freezes constantly

Running any kind of query with more than a thousand records or even just opening a file and other actions crashes the application. You are unable to actually stop a query. You have to kill from Windows Task Manager every single time. See More

Top Pro

Multiple query tabs

FriendlyCheonjiwang's Experience

Since the upgrade, it rarely crashes, maintains connection persistence, and is generally more reliable. See More

Top Con

Buggy and unintuitive UI

Multiple reports of unintuitive use and bugs. See More

Top Pro

Database synchronization

Forward & reverse engeneering See More

Top Pro

Easy to use

Actions can be directly carried out on tables. The software prepares the relevant query for approval before execution. See More

Top Pro

EER diagramming

MySQL Workbench has enhanced entity–relationship modeling support. See More

HeidiSQL is a powerful client for MySQL. See More

score 44 · Answer 6

HeidiSQL

Top Pro

Powerful

Top Con

This is a Windows app

Requires a virtual Windows environment. See More

PleasantMandanu's Experience

What is this app doing in a report showing GUI for OSX - this is a windows app See More

Specs

Platforms:Windows

Technology:Delphi

Database management:PostgreSQL, MariaDB, MySQL, SQL Server, SQLite

License:GPL-2.0

Top Pro

Free

Top Con

Can be buggy

HeidiSQL is known to have some bugs that results in crashes. See More

Top Pro

Easy to use

Top Con

JSON Support

Has only basic support for MySQL's JSON data type, & no support for MariaDb JSON supporting functions ( MariaDb does not implement a JSON data type). See More

Top Pro

Portable

If you want to migrate an MS Access database to MySQL, then you are out of luck here. Navicat can save your day with ease. Also, for the love of life, stay away from MySQL WorkBench. It's so buggy, you will start to question your whole existence as a programmer. See More

score 33 · Answer 7

DataGrip

Top Con

No import and export functions

Top Pro

All in one solution for any type of database including MySQL

LoveableKukulkan's Experience

take a lot ram and slow. See More

Specs

As with all other IDEs, DataGrip is powerful and thus requires more resources than usual. It can use up to several GB's of memory when working with high-volume databases, and this has an impact on performance if your system is not equipped to handle it. See More

Top Con

Performance can be slow/sluggish when working with high-volume databases

Top Pro

Supports all major version control systems

Has support for Git, SVN, Mercurial, Perforce, among other version control systems. See More

Top Con

Not user friendly

Top Pro

Beautiful and customizable UI

DataGrip currently provides two theme options, light and dark. The UI is intuitive to navigate and provides powerful features such as a diagram view of table relationships. See More

Top Pro

Excellent code completion

DataGrip's code completion is context-sensitive and schema-aware code completion. It will take into account tables structure, foreign keys, and even database objects created in your code. See More

Top Pro

Refactoring support

You can refactor SQL code with DataGrip — it resolves all references automatically and when an object/variable is renamed, you can choose to update all references to it in your project. See More

Top Pro

Helps you avoid mistakes

It can catch SQL bugs and suggest ways to resolve them. It will inform of unresolved objects and the use of keywords as identifiers. See More

Very slick design, it just works. What i mis tough is inline filtering for quick filtering tables. See More

score 35 · Answer 8

Querious 2

Top Pro

Fast, powerful, bugfree, very good user experience

CredibleOrcus's Experience

Top Pro

Powerful import fuctionality

FearlessRheda's Experience

Hangs while viewing logs - got up to 65GB usage before I killed it. My logs are nearly empty. See More

Top Pro

It allows working on multiple queries on multiple databases (unlike SequelPro)

Top Pro

No crash and it never gets stuck (unlike MySql Work Bench)

Top Pro

Autosave the most recent queries for an easy reuse

Top Pro

User Experience and Editing capabilities

SQLPro supports saving queries that you may want to use more than once. See More

score 25 · Answer 9

SQLPro for MySQL

Top Pro

Great UI

Easy to use. See More

Top Con

Since last updates - crashes all the time

Top Pro

Easily save queries

Top Con

Proprietary

SQLPro is a paid proprietary software with licenses starting at $19.99. See More

Top Pro

Great UI for big databases

Super easy to view table structure and a double click will select top 100 rows. See More

You can download a free version from the app store. See More

score 22 · Answer 10

Valentina Studio

Top Pro

Free version

Lynn Fredricks's Experience

Always well supported on macOS with feature parity on macOS, Windows and Linux. See More

Specs

Supports several databases, MySQL/ MSSQL / PostGresSQL / and more See More

Technology:C++, QT

Top Pro

Multi DB

CoolNinhursag's Experience

Super support for both MySQL and PostgresSQL Multitab SQL autocomplete See More

Top Pro

Cross-platform

Valentina Studio works on Windows, Linux and OS X. See More

FearlessRheda's Experience

I like the inline data editor, but navigating around this app was an exercise in frustration. See More

Top Pro

Good UI

Valentina Studio has a responsive and clean user interface. See More

This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you. See More

score 9 · Answer 11

DbVisualizer

Top Pro

Professional tool

Top Con

Expensive

License for the full product is costly. See More

Specs

Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go. See More

Top Pro

Duplicate row button

Top Pro

Wildcard finder

Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns). See More

Top Pro

In-line editing

Allows you to edit and save db rows through a spread-sheet like editor. See More

Runs on Windows, Mac, and Linux. See More

score 3 · Answer 12

DbSchema

Top Pro

Multi-platform

Mike's Experience

DBSchema is a multi-platform database tool for relational databases working great with MySQL by using the Auroramysql JDBC driver. It includes an easy to use graphical schema and query editor. See More

Specs

Price (2023-06-26):196$ + Taxes

Top Pro

Graphical Diagram Editor

Includes the possibility to edit tables and data directly in the diagram without writing SQL statements. See More

Top Pro

Graphical Query Editor

Includes a visual query editor capable of using different join types, filters as well as the 'group by' clause. See More

Top Pro

SQL editor with syntax highlighting

Includes an SQL editor with syntax highlighting and code completion feature. See More

Top Pro

Generate schema from existing database

Includes the possibility to generate an ER diagram from an existing database. See More

Top Pro

Generator for Random Data

Includes the possibility to generate random numerical data or fetch random entries from a text file to populate the database. See More

Top Pro

Virtual Foreign Keys

If the Database schema is missing real foreign keys, it is possible to create virtual ones to be used within the tool. See More

Since this as an updated version of Sequel Pro, there are fewer crashes than the dead project. See More

score 15 · Answer 13

Sequel Ace

Top Pro

Doesn't crash like Sequel Pro

Top Con

Doesn't support multiple result tabs for multiple queries

This feature exists in other programs like Navicat, TablePlus, Querious, and MySQL WorkBench. See More

FerventBellona's Experience

Sequel Ace is a fork of the now-dead Sequel Pro See More

Top Pro

Open Source and on Mac App Store

https://github.com/Sequel-Ace/Sequel-Ace https://apps.apple.com/us/app/sequel-ace/id1518036000 https://sequel-ace.com See More

Top Con

Slow/laggy query editor window

Query editor window is extremely slow/unresponsive when you have several queries in it. Same as Sequel Pro. See More

EnterprisingSulis's Experience

Query editor window is extremely slow/unresponsive when you have several queries in it. Same as Sequel Pro. See More

LivelyAergia's Experience

Great app for many standard database operations, especially for free See More

No complicated flow, just select fields/values to select/filter/sort See More

score 2 · Answer 14

Adminer

Top Pro

Usable filtering UI

Top Con

No autocomplete

Probably an expected one, given that it's so lightweight and browser-based See More

Top Pro

Lightweight

The installation and Adminer itself only requires a single PHP file. Once it's uploaded you can log in and start using it. See More

Top Pro

Browser-based

You can find anything within the result set in page, use your password manager etc. See More

Top Pro

Supports more than MySQL

It supports several database management systems (Postgres, SQLite, Oracle, MS SQL and of course MySQL) See More

The autocomplete is useful but not obtrusive. See More

score 1 · Answer 15

Beekeeper Studio

Top Pro

Autocomplete

Top Con

Not for a DBA

It's great for web/app developers who interact with a database, but if you're a full time DBA you probably have better powertools available. See More

Specs

Platforms:Mac, Windows, Linux

Technology:Electron

Dark Theme:Yes

Free tier:Yes, 100% Open Source

See All Specs

Top Pro

Easy to use

Way less confusing than other DB managers, and has a simple tabbed interface that feels more like VS Code. See More

Platforms:Windows, Mac, Linux

score 1 · Answer 16

JookDB

Top Pro

Free and powerful

Specs

Technology:C++

Database management:MySQL, MariaDB, Oracle, PostgreSQL, SQLite, MongoDB, DM, OceanBase, TiDB and SQLServer

score 4 · Answer 17

Datazenit

Top Pro

Great UI

Top Con

Costly

The license costs in range of $79-$179. See More

Top Pro

Powerful data grid

Top Pro

Productivity Features

Top Pro

Charts and dataviz

Top Pro

Cross-platform

Overall smooth experience with a good selection of compatible databases, updated regularly and have never had any major issues See More

Answer 18

qStudio

john's Experience

score 2 · Answer 19

Azure Data Studio

Top Pro

Lightweight

CaringYopaat's Experience

not for MySQL only for MSsql See More

Top Pro

Extensions

Top Pro

Customizable server and database dashboards

Top Pro

Cross-platform

Top Pro

Open-source

See here. See More

Top Pro

IntelliSense

Top Pro

Code snippets