MySQL

A MySQL client that belongs on a Mac.

Write queries, edit rows in place and design tables on MySQL — with your Keychain, your Touch ID and no account.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

MySQL

What MySQL gets.

The kinds of object that exist on an engine are the kinds the app shows. This is MySQL's row of the features table, and what stands behind it.

EngineEditable gridDesignersUsers & RolesDiagram
MySQL and MariaDB✓✓tables, triggers, events, sequences on MariaDB✓✓

Tables, triggers, events and tablespaces

Each has a designer that opens as a tab and previews its SQL. A view, a function or a procedure opens as its CREATE script in a query tab.

Guide: kinds of object

Column changes, restated in full

MySQL can only change a column by restating all of it. The designer restates it in full, collation included, and refuses a column whose extra attributes it could not restate safely, pointing you to SQL.

Guide: the table designer

It says what cannot be undone

MySQL applies each structure change at once, so a failure partway leaves the earlier ones in place. A note beside the designer's buttons says so before you apply.

Guide: the table designer

Accounts as MySQL names them

An account is name@host, with a connection limit and grants at global, database and table level. Read the SQL preview, then create or save.

Guide: users and roles
Connect

Connect to MySQL.

Click Add Connection under the sidebar and pick the MySQL tile. Paste a connection string — the field reads mysql:// addresses — and the fields fill themselves in, or type the host, port, database, user and password. Click Test Connection, then Add.

Default port
3306
SSL
Disabled, Required, Verify Certificate
Servers
MySQL 5.7 and newer, as the driver documents.
Console
mysql — brew install mysql-client
Notes
Designers for tables, triggers, events and tablespaces. Each structure change applies at once, so a failure partway leaves the earlier changes in place; the designer says so.

Guide: MySQL in the docs Guide: your first connection

Every engine

One app for the rest of your databases, too.

Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient