MySQL and MariaDB client for Mac, iPhone and iPad

Give TablePro a host, a port and a user, or paste a mysql:// URL. MySQL 8 accounts that use caching_sha2_password connect on the first try. Leave the database empty and choose one later: switching databases happens in place, on the same connection.

New connections start with SSL set to Preferred, which tries TLS first and falls back to plain text only after a failed TLS handshake. Choose Verify CA or Verify Identity with your provider’s certificate for strict checking.

For a server on a private network, connect through an SSH tunnel, with jump hosts if you need them, a SOCKS5 proxy, a Cloudflare Access tunnel or your own tunnel command such as kubectl port-forward.

On Amazon RDS and Aurora, sign in with AWS IAM, which signs a fresh token each time you connect, and import instances straight from your AWS account. For Google Cloud SQL, TablePro downloads and runs the Cloud SQL Auth Proxy for you.

Moving from Sequel Ace? Import from Other App reads its favorites and, after you confirm, the passwords it keeps in the Keychain.

The SQL editor completes table and column names from the schema, aliases and CTEs included, and runs either the statement under the cursor or the whole script. EXPLAIN FORMAT=JSON, EXPLAIN FORMAT=TREE and EXPLAIN ANALYZE are drawn as a plan diagram or tree, and EXPLAIN Compare shows what changed between two runs.

Row edits are staged until you save, and Preview SQL shows the exact statements first. Saves run as bound parameters and stop if a statement would change a different number of rows than expected. A table without a primary key can still be edited: the row is matched on every column.

Every session uses utf8mb4, so emoji and non-Latin text round-trip. For a database whose text an old client wrote through Latin 1, the UTF-8 via Latin 1 encoding reads it the way that client did.

Partitioned tables list their partitions with their bounds, such as VALUES LESS THAN (2024), and table and column comments show in the sidebar and in the grid’s column headers.

The Structure tab stages changes to columns, indexes, foreign keys, CHECK constraints and generated columns, and shows the DDL before it runs. Index keys over an expression, such as lower(email), need MySQL 8.0.13 or later.

Routines and triggers appear in the sidebar with their source. The ER diagram draws the schema as a read-only picture you can export as PNG or SQL.

Compare & Sync, part of the Starter plan, compares two MySQL or MariaDB schemas, or their data, and writes the script that brings one in line with the other. Changes that would lose data are held back until you include them.

Import CSV, TSV, JSON, JSONL, XLSX and SQL files, with column mapping for the table you load into and a choice of what happens when a row fails. Export a table or a result as CSV, JSON, SQL, XLSX, Markdown, HTML and XML.

Copy To sends tables, their data or both to another connection, on MySQL or on a different engine, and lists every column type it has to approximate.

Default port 3306Comes with the Mac appiPhone and iPad: OpensMinimum version: 10.x

MariaDB connects through the same driver as MySQL, with the same SSH, SSL/TLS and AWS IAM options. A mariadb:// URL creates a MariaDB connection.

JSON columns, which MariaDB stores as LONGTEXT, open in the JSON editor. Virtual and persistent columns are detected and left out of generated INSERT and UPDATE statements. Sequences are listed in the sidebar, read-only, and a system-versioned table is listed as an ordinary table.

Users & Roles, the Server Dashboard, table maintenance and mysqldump backups work as they do on MySQL.

MariaDB setup guide↗

Default port 4000Comes with the Mac appiPhone and iPad: OpensMinimum version: None

Point the connection at a TiDB server’s SQL port, never at PD or TiKV. TiDB Cloud uses the same port; set SSL Mode to Required there.

Stop sends KILL TIDB QUERY for your own session. Behind TiProxy or a load balancer, that needs Global Kill, which TiDB turns on by default since version 6.1.

EXPLAIN and EXPLAIN ANALYZE show TiDB’s plan as text. CHECK constraints appear in the Structure tab on TiDB 7.2 and later when the cluster enables them, foreign keys can be created, and table maintenance offers ANALYZE TABLE. Users & Roles works on TiDB, without the connection limit field.

Choose TiDB as the connection type rather than MySQL, so the sidebar, the type picker and EXPLAIN follow TiDB.

TiDB setup guide↗

Default port 2881Comes with the Mac appiPhone and iPad: OpensMinimum version: None

Put the tenant in the user name: root@test on an observer, or root@test#obcluster through OBProxy, which listens on port 2883.

Connecting checks that the server reports itself as OceanBase, so a wrong host or port fails at once. TablePro’s query timeout replaces OceanBase’s own statement limit.

EXPLAIN shows the plan as text. A table without a primary key is edited by matching every column, and a save that would change more than one row, or none, stops and says so.

Choose OceanBase as the connection type: a connection saved as MySQL that reaches OceanBase gets none of this.

OceanBase setup guide↗

Default port 3307Comes with the Mac appiPhone and iPad: Does not openMinimum version: None

Databend connects through its MySQL handler, not its HTTP API. Choose Databend as the connection type; a MySQL connection that reaches a Databend server is refused and asks you to change the type.

On Databend Cloud, ask Databend support to turn on the warehouse’s MySQL endpoint, then copy the host and port from its Connect dialog.

The Structure tab edits columns and CHECK constraints and renames tables, views and columns. EXPLAIN and EXPLAIN ANALYZE show the plan as text, and table maintenance offers ANALYZE TABLE.

ARRAY, MAP and TUPLE cells cannot be written from text. Change them with an UPDATE in the editor.

Databend setup guide↗