MySQL Client

Native MySQL client for macOS

TablePro connects to MySQL 5.7+, MySQL 8.0+, and MariaDB 10+ using libmariadb, a native C driver. No JDBC, no Java runtime, no Electron. The app starts in under a second and uses about 80 MB of memory. You get a full SQL editor with tree-sitter highlighting, schema-aware autocomplete, query history with full-text search, and an AI assistant that can write, explain, or optimize your queries.

Download for Mac Read the docs

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

Features

Built for MySQL.

Inline Data Editing

Click any cell in the data grid to edit. Add or delete rows. Review all pending changes before committing. Undo and redo supported.

SSH Tunneling

Connect to remote MySQL servers through SSH with password, private key, or agent auth. Supports jump hosts and custom ports.

Smart Autocomplete

Context-aware suggestions for table names, column names, aliases, SQL keywords, and functions. Learns your schema on connect.

Import & Export

Export to CSV, JSON, SQL dump, or XLSX. Import from CSV or SQL files with configurable error handling (skip, abort, or replace).

Table Structure Editor

Add, rename, or drop columns. Create indexes and foreign keys. Modify column types, defaults, and nullability from a visual editor.

AI SQL Assistant

Write SQL from natural language. Explain existing queries. Optimize slow queries. Works with Claude, OpenAI, or 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, and views in the sidebar
Run multiple queries in tabs with separate results
Filter and sort data without writing SQL
View and edit table structure (columns, indexes, foreign keys)
Auto-reconnect on connection drop with exponential backoff
Export query results or entire tables
Full-text search across query history
Safe mode to prevent accidental writes

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

Try TablePro for free.

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

Download for Mac Setup guide