Features

Everything you need to manage MySQL, PostgreSQL, SQL Server, SQLite, Oracle, and Snowflake databases from a single native app.

Supported databases

SQLPro Studio connects to the most widely used relational databases. One app, one license, all your databases.

MySQL and MariaDB — Full support including stored procedures, triggers, views, and user management.
PostgreSQL — Connect to PostgreSQL 9.x through 17, including Amazon RDS, Azure, Heroku Postgres, and Supabase.
Microsoft SQL Server — SQL Server 2005 and above, including Azure SQL Database and Amazon RDS for SQL Server.
SQLite — Open local .sqlite, .db, and .sqlite3 files directly. No server required.
Oracle — Oracle 8i and above, including Oracle Cloud and Amazon RDS for Oracle.
Snowflake — Connect to your Snowflake data warehouse and run SQL queries against cloud-scale data.
Amazon Redshift — Query your Redshift data warehouse using the PostgreSQL wire protocol.

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

Syntax highlighting — SQL keywords, strings, numbers, and comments are color-coded for readability across all supported databases.
Autocomplete — Table names, column names, and SQL keywords are suggested as you type, reducing typos and speeding up query writing.
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 errors 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 constraints through a visual interface.

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

SSH tunneling — Connect to remote databases 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.
Cloud databases — Works with Amazon RDS, Azure SQL, Google Cloud SQL, Heroku Postgres, DigitalOcean Managed Databases, and Snowflake.

SQLPro Studio runs natively on every platform it supports — no Java, no Electron, no compromises.

macOS — Built with AppKit and SwiftUI. Available on the Mac App Store and as a direct download.
iOS and iPadOS — A native iPhone and iPad app for managing databases on the go. Available on the App Store.
Windows — A native UWP application. Available on the Microsoft Store.

Dark mode — Follows your system appearance on macOS, iOS, and Windows.
Stored procedures and functions — Browse, create, and execute stored procedures and functions.
Views and triggers — Manage database views and triggers through the sidebar.
User management — Create and manage database users and permissions (MySQL, PostgreSQL).
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.