SQL Server
A SQL Server client that belongs on a Mac.
Query and manage Microsoft SQL Server from a native Mac app: edit rows in place, design tables, and see who is granted — or denied — what.
Free for a month, then one price. Pricing
What SQL Server gets.
The kinds of object that exist on an engine are the kinds the app shows. This is SQL Server's row of the features table, and what stands behind it.
| Engine | Editable grid | Designers | Users & Roles | Diagram |
|---|---|---|---|---|
| SQL Server | ✓ | ✓plus synonyms, partition functions and schemes | ✓ | ✓ |
Synonyms and partitions
Beyond tables, sequences and triggers there are designers for synonyms, partition functions and partition schemes, where an edit is a SPLIT or a MERGE.
Guide: kinds of objectA DENY is not a missing grant
SQL Server has three states for a permission: granted, denied, and not set. A DENY wins even where a role would allow, and the editor keeps it apart from a missing grant.
Guide: users and rolesStructure changes in a transaction
The table designer's script runs in a transaction on SQL Server. Defaults are named constraints there, so changing one is left to SQL — and the designer says so rather than hiding it.
Guide: the table designersqlcmd, already signed in
A console tab is a real terminal running sqlcmd with the connection's host, port, user and password, through its SSH tunnel or proxy if it has one. The password is never put on the command line.
Connect to SQL Server.
Click Add Connection under the sidebar and pick the SQL Server tile. Paste a connection string — the field reads sqlserver:// addresses — and the fields fill themselves in, or type the host, port, database, user and password. Click Test Connection, then Add.
- Default port
- 1433
- SSL
- Disabled, Required
- Servers
- SQL Server 2017 and newer: the app speaks TDS 7.4 and its catalog queries use
STRING_AGG. Every connection turns on the session options ODBC clients and SSMS use —QUOTED_IDENTIFIER,ANSI_NULLS,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ANSI_PADDINGandARITHABORT— so a PERSISTED computed column, an indexed view or a filtered index can be created from a query tab. - Console
sqlcmd—brew install sqlcmd- Notes
- One connection lists every database of the server; each opens beside the others in the sidebar, and a
USEin a tab takes the tab to that database. Synonyms, partition functions and partition schemes; a DENY is kept apart from a missing grant in Users & Roles. Defaults are named constraints, so changing one needs SQL.
One app for the rest of your databases, too.
Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.
Try it on your own database.
Free for a month, then one price, and never asking you to sign in.
$brew install --cask az-code-lab/taps/dbclient