Skip to content
MySQL

MySQL Client

The MySQL GUI Client for Mac.

A fast, native MySQL GUI client for Mac. Connect to MySQL 5.7, 8.0, or any MariaDB drop-in over TCP, socket, or SSH. Browse schemas, edit cells, run queries. Starts in under a second. Idles at 80 MB. Free and open source.

TablePro connected to a MySQL database showing the data grid and SQL editor

Features

Built for MySQL.

Inline Cell Editing

Edit any cell in the data grid. Add or delete rows. Review every pending change before commit. Full undo and redo across the session.

SSH Tunnel Built In

Reach a remote MySQL through SSH from the connection form. Password, key, or ssh-agent. Jump hosts and custom ports work.

Schema-Aware Autocomplete

Suggests table names, column names, aliases, MySQL functions, and CTEs. Reads your schema on connect, refreshes on demand.

Import and Export

Export to CSV, JSON, SQL dump, or XLSX. Import from CSV or .sql files. Choose skip, abort, or replace on error.

Visual Structure Editor

Add columns, rename, drop. Create indexes and foreign keys. Change types, defaults, nullability without writing DDL.

AI SQL Assistant

Ask in English, get SQL. Explain or rewrite slow queries. Works with Claude, OpenAI, and local Ollama models.

Data Grid

Browse and edit data.

Sort, filter, and edit MySQL data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing MySQL table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with MySQL query and autocomplete

Capabilities

What you can do.

  • Browse databases, tables, views, and stored procedures
  • Run multiple queries in tabs with separate result sets
  • Filter and sort rows without writing SQL
  • Edit table structure: columns, indexes, foreign keys
  • Auto-reconnect after a dropped connection
  • Stream-export million-row tables without OOM
  • Full-text search across query history
  • Safe mode blocks UPDATE without WHERE

Connect

Get connected in seconds.

# Connect with TablePro Host: 127.0.0.1 Port: 3306 User: root Database: mydb # Or via terminal mysql -h 127.0.0.1 -P 3306 -u root -p mydb

Supported versions

MySQL 5.7+, MySQL 8.0+, MariaDB 10.3+

Connection types

  • TCP/IP
  • Unix Socket
  • SSH Tunnel (password, key, agent)
  • SSL/TLS

Default port

3306

How to

Connect to MySQL in four steps.

  1. 1

    Install TablePro

    brew install --cask tablepro, or download the DMG from tablepro.app/download.

  2. 2

    Open New Connection

    Click New Connection on the welcome screen. Pick MySQL.

  3. 3

    Fill in the credentials

    Host 127.0.0.1, port 3306, user root, password, database. SSH tab for remote.

  4. 4

    Connect

    Click Test, then Connect. Schemas appear in the sidebar.

FAQ

Common MySQL questions.

Is TablePro free?

Yes. AGPLv3 open source. No per-feature gate. The MySQL driver ships built in.

Does it run on Apple Silicon?

Yes. Universal Binary, native arm64 and x86_64. M1/M2/M3/M4 all run at full speed.

How does TablePro compare to MySQL Workbench?

MySQL Workbench is the official Oracle client, written in C and C++. It's slow to start (10+ seconds on a fresh launch) and heavy for what it does. TablePro is native SwiftUI for Mac, starts in under 1 second, and includes an AI assistant.

Can I connect through a bastion?

Yes. Open the SSH tab in the connection form. Add bastion host, port, and credential. TablePro builds the tunnel.

Does the AI assistant send data to a server?

Only if you choose a cloud provider (Claude, OpenAI). Pick Ollama and everything stays on the Mac.

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.