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.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

SQL Server

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.

EngineEditable gridDesignersUsers & RolesDiagram
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 object

A 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 roles

Structure 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 designer

sqlcmd, 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.

Guide: console tabs
Connect

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.
Console
sqlcmd — brew install sqlcmd
Notes
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.

Guide: SQL Server in the docs Guide: your first connection

Every engine

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.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient