SQL Server Client

Native SQL Server client for macOS

TablePro connects to SQL Server using FreeTDS, a native C driver for the TDS protocol. No ODBC configuration needed. It supports SQL Server 2016+, Azure SQL Database, and Azure SQL Managed Instance. You get a T-SQL editor with dialect-specific autocomplete, inline data editing, and a table structure viewer. Finally a real SQL Server client for Mac that does not require Azure Data Studio or Docker.

Download for Mac Read the docs

TablePro connected to a SQL Server database showing the data grid and SQL editor

Features

Built for SQL Server.

T-SQL Editor

Syntax highlighting and autocomplete for T-SQL dialect. Supports SQL Server-specific keywords (TOP, NOLOCK, CROSS APPLY, MERGE). Query history with search.

Inline Data Editing

Edit rows in the data grid. Insert new rows. Delete rows. See pending changes before committing. Handles identity columns.

Multiple Databases

Browse all databases on the server from the sidebar. Switch between databases without reconnecting. View system databases.

Azure SQL Support

Connect to Azure SQL Database and Azure SQL Managed Instance. Uses the same interface as on-premises SQL Server.

Stored Procedures & Views

Browse stored procedures, views, and functions in the sidebar. View their definitions. Run procedures with parameters.

Table Structure

View columns, indexes, constraints, and triggers. See data types, defaults, and identity specifications.

Data Grid

Browse and edit data.

Sort, filter, and edit SQL Server data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.

TablePro data grid showing SQL Server table rows with inline editing

SQL Editor

Write queries faster.

Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.

TablePro SQL editor with SQL Server query and autocomplete

Capabilities

What you can do.

Browse databases, tables, views, procedures, functions
Run T-SQL queries with syntax highlighting
Edit data inline with identity column support
View and edit table structure
Browse stored procedures and view definitions
Connect to Azure SQL Database
Export to CSV, JSON, SQL, XLSX
Multiple result sets from stored procedures

Connect

Get connected in seconds.

# Connect with TablePro
Host: 127.0.0.1
Port: 1433
User: sa
Database: mydb

# Azure SQL
Host: myserver.database.windows.net
Port: 1433
User: admin@myserver

Supported versions

SQL Server 2016+, Azure SQL Database, Azure SQL Managed Instance

Connection types

TCP/IP
SSH Tunnel
TLS/SSL (encrypted connection)

Default port

1433

Try TablePro for free.

Free and open-source. macOS 14+. Apple Silicon and Intel.

Download for Mac Setup guide