SQLPro for MSSQL Features

Everything you need to manage Microsoft SQL Server databases from a native app on macOS, iOS, and Windows.

SQL Server support

SQLPro for MSSQL supports Microsoft SQL Server 2005 and above, including all cloud-hosted variants.

SQL Server 2005 through 2022 -- Connect to any on-premises SQL Server instance.
Azure SQL Database -- Full support for Azure SQL Database and Azure SQL Managed Instance.
Amazon RDS for SQL Server -- Connect to SQL Server instances running on Amazon RDS.
Google Cloud SQL for SQL Server -- Works with Cloud SQL instances on Google Cloud.
SQL Server on Linux -- Connects to SQL Server running on Linux or in Docker containers.

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

Syntax highlighting -- T-SQL keywords, strings, numbers, and comments are color-coded for readability.
Autocomplete -- Table names, column names, stored procedures, 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 errors and execution errors are highlighted inline with clear error messages.
GO batch separator -- Full support for GO batch separators, just like SQL Server Management Studio.

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.

Browse and manage all SQL Server 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 and database triggers.
Indexes -- Create and manage clustered, non-clustered, and unique indexes.
Schemas -- Work with multiple schemas in the same database.
Users and roles -- View database users, roles, and their permissions.

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

SSH tunneling -- Connect to remote SQL Server instances 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.
Windows Authentication -- Support for connecting with Windows/domain credentials.

SQLPro for MSSQL runs natively on every platform it supports -- no Java, no Electron, no virtual machines.

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 SQL Server on the go. Available on the App Store.
Windows -- Available on the Microsoft Store.

Dark mode -- Follows your system appearance on macOS, iOS, and Windows.
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.
Familiar workflow -- Similar interface and workflow to SQL Server Management Studio, with macOS-native improvements.