SQLPro for MySQL Features

Everything you need to manage MySQL and MariaDB databases from a fast, native app on macOS and iOS.

MySQL and MariaDB support

SQLPro for MySQL connects to MySQL 5.0 and above and to MariaDB, wherever they run.

MySQL 5.0 through 8.x - Connect to any local or on-premises MySQL server.
MariaDB - Full support for MariaDB, a drop-in MySQL replacement.
Amazon RDS and Aurora - Connect to MySQL-compatible instances on Amazon RDS and Amazon Aurora.
Azure Database for MySQL - Works with Azure's managed MySQL service.
Google Cloud SQL - Connect to Cloud SQL for MySQL instances.
MySQL in Docker - Connect to MySQL running in Docker containers, locally or remotely.

Write SQL faster with a full-featured query editor built for productivity.

Syntax highlighting - SQL keywords, strings, numbers, and comments are color-coded for readability.
Autocomplete - Table names, column names, and SQL keywords are suggested as you type.
Multiple result sets - Execute several queries at once and see all results displayed simultaneously in separate panes.
Query history - Previously executed queries are saved so you can revisit and re-run them.
Error highlighting - Syntax and execution errors are highlighted inline with clear error messages.

Browse, edit, import, and export your data without writing SQL.

Table data browsing - View table contents with sorting, filtering, and pagination.
Inline editing - Edit cell values directly in the result grid and commit changes back to the database.
Import - Import data from CSV, JSON, and SQL files directly into your tables.
Export - Export query results and table data to CSV, JSON, XML, and SQL formats.
Table structure editing - Create, alter, and drop tables, columns, indexes, and foreign keys through a visual interface.

Browse and manage all MySQL objects from the sidebar tree.

Tables and views - Browse, create, alter, and drop tables and views.
Stored procedures and functions - Browse, create, edit, and execute stored procedures and user-defined functions.
Triggers - View and manage table triggers.
Indexes and keys - Create and manage primary keys, unique keys, indexes, and foreign keys.
Users and privileges - View MySQL users and their granted privileges.

Connect securely to databases anywhere - local, cloud, or behind a firewall.

SSH tunneling - Connect to remote MySQL servers through an SSH server. Supports password and key-based authentication.
SSL/TLS - Encrypted connections to protect data in transit.
iCloud Keychain - Connection credentials are stored securely in iCloud Keychain and synced across your Mac, iPhone, and iPad.

SQLPro for MySQL runs natively on macOS and iOS - no Java, no Electron.

macOS - Built natively for the Mac. Available on the Mac App Store and as a direct download.
iOS and iPadOS - A native iPhone and iPad app for managing MySQL on the go. Available on the App Store.

Dark mode - Follows your system appearance on macOS and iOS.
Multiple tabs - Work with multiple query tabs and database connections simultaneously.
Keyboard shortcuts - Execute queries, switch tabs, and navigate the interface without leaving the keyboard.