SQL Server client

Enter a host and TCP port, then choose Authentication: SQL Server login, Kerberos or Microsoft Entra ID. Database-scoped logins, including Azure SQL contained users, also need the Database field.

Kerberos uses the ticket already in your credential cache, or requests one from a principal and password you enter. Connect by hostname rather than IP address, because the ticket is issued for the server’s registered SPN. TablePro never runs kinit or edits /etc/krb5.conf.

Microsoft Entra ID uses device-code sign-in with multifactor authentication and Conditional Access. Register an Azure application and enter its client ID. Tokens refresh in the background and stay in the device-only login keychain.

New connections start on Preferred, which on SQL Server encrypts the login only. Choose Required or stricter to encrypt the whole session; Verify CA and Verify Identity check the certificate against the macOS system roots. TablePro can also run the Cloud SQL Auth Proxy for Google Cloud SQL, and SSH tunnels reach servers on a private network.

Scripts split at GO lines; GO 5 repeats the preceding batch five times. Each result set opens in a separate tab. Read PRINT output and informational messages in Output.

Use BEGIN TRAN and COMMIT when batches must be transactional. An open transaction produces a notice. Execution stops at the first failed batch, with its editor line in the error.

Every session opens with the SET options that filtered indexes, indexed views and indexes on computed columns require, such as ANSI_NULLS and QUOTED_IDENTIFIER on. That also means col = NULL matches nothing: compare with IS NULL.

Tables nest under their schema in the sidebar, and ⌘K changes database in place, with no reconnect. Row edits are staged with Preview SQL, new rows leave IDENTITY columns to the server, and nvarchar(max) values arrive whole.

The Structure tab stages changes to columns, indexes, foreign keys and constraints, and shows the T-SQL before it runs. Schemas can be dropped from the sidebar; SQL Server refuses to drop a schema that still holds objects. Create one with CREATE SCHEMA in the editor.

Compare & Sync (Starter) compares SQL Server schemas or data. Generated scripts separate statements with GO for sqlcmd or SQL Server Management Studio.

The Server Dashboard shows user sessions, uptime and database size, lists every other session and the queries running longer than a second, and ends a session with Terminate Session. There is no Cancel Query on SQL Server.

Backup Dump writes a .bacpac with sqlpackage, which you download from Microsoft, and Restore Dump loads one into an empty database. SqlPackage takes a password only on its command line, where other processes on the Mac can read it, so TablePro asks before it starts. Windows or Entra authentication avoids passing one.

Import CSV, TSV, JSON, JSONL, XLSX and SQL files. SQL files respect GO batches. Export tables or results as CSV, JSON, SQL, XLSX, Markdown, HTML and XML; SQL exports also use GO separators.