SQLPro Studio 2026.301

SQLPro Studio is a native database manager for macOS that lets you work with MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, SQLite, Oracle, Snowflake, and Amazon Redshift in one app. Built with Swift and Objective-C, it launches instantly and uses minimal system resources, with no Java or Electron runtime required. One app and one license cover all your databases.

Supported databases
Connect to the most widely used relational databases, from local files to cloud-scale data warehouses.

• 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: Works with SQL Server 2005 and above, including Azure SQL Database and Amazon RDS for SQL Server.
• SQLite: Open local .sqlite, .db, and .sqlite3 files directly, with no server required.
• Oracle: Connect to Oracle 8i and above, including Oracle Cloud and Amazon RDS for Oracle.
• Snowflake: Run SQL queries against your Snowflake data warehouse.
• Amazon Redshift: Query your Redshift data warehouse using the PostgreSQL wire protocol.

Query editor
Write and run SQL in an 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, which reduces typos and speeds up query writing.
• Multiple result sets: Execute several queries at once and see all results, including errors and messages, 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.

Data management
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: Bring data from CSV, JSON, and SQL files directly into your tables.
• Export: Save query results and table data as CSV, JSON, XML, or SQL.
• Table structure editing: Create, alter, and drop tables, columns, indexes, and constraints through a visual interface.

Connection and security
Connect to databases wherever they are: local, in the cloud, or behind a firewall.

• SSH tunneling: Reach remote databases through an SSH server using password or key-based authentication.
• SSL/TLS: Use encrypted connections to protect data in transit.
• iCloud Keychain: Connection credentials are stored securely in iCloud Keychain.
• Cloud databases: Works with Amazon RDS, Azure SQL, Google Cloud SQL, Heroku Postgres, DigitalOcean Managed Databases, and Snowflake.