Best for: Visual learners and tutorials.
Your OS shouldn't dictate your database tools anymore. The ecosystem has finally caught up. mac sql server
The modern dev workflow is so much cleaner: 🐳 for the instance. 💻 Azure Data Studio for the GUI. ⚡ CLI for the basics. Best for: Visual learners and tutorials
The most common and supported method is running via Docker Desktop. The modern dev workflow is so much cleaner:
Full SQL Server engine, free for development, supports all major features (Stored Procedures, SSIS limited, etc.). Cons: Consumes system resources, no GUI installer, Linux-based environment (no Windows-specific features like SQL Agent mail).
| Tool | Purpose | Key Features | |------|---------|---------------| | (Free) | Primary GUI admin/query tool | Cross-platform, notebook support, IntelliSense, Git integration | | Visual Studio Code (Free) | Code editor with SQL extension | mssql extension for queries, integrated terminal | | TablePlus (Freemium) | Lightweight GUI | Native macOS look, multiple DB support | | DBeaver (Free/EE) | Universal database tool | ER diagrams, data export | | sqlcmd (CLI) | Scripting & automation | Comes with mssql-tools via Homebrew |