SQL Explorer

A native macOS SQL Server management app built with Swift and SwiftUI.
Fast, lightweight, and designed for developers who work with SQL Server on Mac.

---

Features

Query & Results

• Multi-tab query editor with SQL syntax highlighting, autocomplete, and keyword suggestions
• Results grid — NSTableView-backed, Excel-style cell selection, click-to-copy, context menus, export
• Query history — automatically saved, searchable, re-runnable
• Error panel — categorized errors, pre-validation, fix suggestions
• Keyboard shortcuts — Cmd+Enter execute, Cmd+T new tab, Cmd+W close

Object Explorer

• Expandable schema tree (databases, schemas, tables, columns, views, stored procedures)
• Schema filter chips + search in the sidebar
• Auto-focus query editor when a new tab opens

Database Diagrams (ERD)

• Visual entity-relationship diagrams with FK lines and drag-to-arrange tables
• Hierarchical auto-arrange layout
• Save and load named diagrams per database
• Related-table suggestions in sidebar and on canvas
• Schema filter + grouped-by-schema table list

Azure SQL Integration

• Entra ID sign-in via MSAL — silent refresh, webview fallback, Keychain-cached tokens
• Cross-subscription Groups and Favorites with a badge for members in a different subscription
• Browse all Azure SQL databases across every subscription you have access to
• Auto-trigger sign-in when connecting to a saved Entra member
• Manual connections — either fill the form or paste a connection string

Performance Monitor (Azure SQL)

Open from Object Explorer, Groups, or Favorites. Pulls Azure Monitor metrics (CPU, DTU, Data IO, Log IO, Storage, Workers, Sessions, deadlocks, connection successes/failures, firewall blocks) with:

• Hover ruler — dashed line + dot snap to the nearest sampled point with a full-precision timestamp tooltip, so spikes can be pinpointed on 24h / 7d windows
• Stats strip — Min / Avg / P95 / Max for every chart
• Trend delta — direction arrow + change vs. the start of the window
• Threshold coloring — amber above 75%, red above 90% for percentage metrics
• Expand — double-click a chart to open a focused view with peak callout and CSV export
• Pin — right-click to pin a metric to the top of the grid (persisted)
• Auto-refresh every 60 s, configurable time range (1h / 6h / 24h / 7d)

Connections

• Save, group, and organize server connections with environment labels
• Favorites & Groups for quick access
• SQL, Windows, and Entra ID authentication

Installation

Download the latest .dmg from Releases, open it, and drag SQL Explorer to your Applications folder.

First launch — macOS Gatekeeper

On first launch macOS may show "SQL Explorer is damaged and can't be opened." The app is fine — macOS is blocking the quarantine attribute your browser attached to the download.

Open Terminal and run this single command:

sudo xattr -cr "/Applications/SQL Explorer.app"

Enter your password when prompted, then open the app. Run the same command again after every update.

Requirements

• macOS 14.0 (Sonoma) or later

License

This project is proprietary software. All rights reserved.