If you need a tool that runs directly on macOS, these are the most highly recommended options:
Official is a Windows-only application and cannot be installed directly on macOS. However, you can manage SQL Server on a Mac by using cross-platform alternatives, virtualization, or containerization. Top Native Alternatives for Mac sql server management for mac
Automation scripts, quick maintenance, or developers who live in the terminal. If you need a tool that runs directly